Oracle Database Managed Files Setup (OMF)

This will eliminate the need for a dba to directly manage the operating system files in a database.

After this configured we can just create a database object without specifying the file path.

OMF will support below objects:
Tablespaces
redo log files
control files
archived logs
block change tracking files
flashback logs
RMAN backups

To enable OMF we must configure below parameters:
DB_CREATE_FILE_DEST (datafiles, temp files)
DB_CREATE_ONLINE_LOG_DEST_n (redo log and control files) DB_RECOVERY_FILE_DEST (fra)

To setup these parameters:

alter system set db_create_file_dest='/u01/prod';

alter system set db_create_online_log_dest_1='/u01/prod';

To set FRA:

alter system set db_recovery_file_dest_size = 10G;

alter system set db_recovery_file_dest = '/u01/fra';

Once the above parameter setup we create a tablespace with this command:

create tablespace test;

(here size of the datafile and location and other parameters oracle takes automatically)
Default size of the datafile will be 100MB.
It will be Locally Managed Tablespace.