I have noticed that the default redolog size in 9i datbase's is around 100 mb where as before in the earlier versions it used to be only 1 mb. Am i mistaken ?
If this is the case why such a sizeable change .How about some opinions from u guys ?
Testing for specific users at times.. yes sometimes i use the default settings !!I know what large redo logs are used for thankyou but just wanted to know the default change in size of the redologs
Anyways thankyou Sanjay for your input that was a nice short and precise answer.
Who Can Use Oracle-Managed Files?
• Low end databases
1. A single initialization parameter, DB_CREATE_FILE_DEST, is
specified. This is probably a low end database since all files are
create in the same filesystem. You can seperate redo logs and
controlfiles but not datafiles unless you create manually (so what's
the point of using OMF if later, I have to create datafiles manually
if I want to distribute I/O?)
OMF is for those shops with no DBAs, is for those peeps who does
create database and they have a database running, is for low-end servers for 1 or 2 or 3 filesystems assigned for Oracle, and only one of them is used for datafiles, no file distribution. In our databases we have file naming convention and if we see a datafile we know what tablespace it belongs, this is not the case with OMF, it's probably no harm but it's like SAP tables with dodgy names then if I want to know what is it I have to look up the dictionary table