Friday , July 21 2017
Home / Oracle DBA / ORACLE MANAGED FILES (OMF)

ORACLE MANAGED FILES (OMF)

ORACLE MANAGED FILES (OMF)

  1. OMF gives flexibility in managing CRD files
  2. We can use OMF by setting below parameter
db_create_file_dest
db_create_online_log_dest                 dynamic parameters

COMMANDS

# To configure OMF parameters
SQL> alter system set db_create_file_dest=’/u02/prod’ scope=memory;
SQL> alter system set db_create_online_log_dest=’/u02/prod’ scope=memory;
Read More:
BIGFILE TABLESPACE
LOCAL Vs DICTIONARY managed tablespaces
ARCHIVELOG FILES

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

Your email address will not be published. Required fields are marked *