DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: redo log size

  1. #1
    Join Date
    Sep 2002
    Posts
    40

    Exclamation redo log size

    Hi ,

    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 ?

    Thanks to all contributing
    OCP DBA 7.3,8,8i,9i

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well we never use default settings, do you?

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Being an OCP DBA for 9i you should be aware of this.

    Anyway, when you create OMF(Oracle Managed Files) all the datafiles are 100MB by default which are autoexetnsible to unlimited max size. And logfiles are no exception. They too are 100MB by default.
    Agasimani
    OCP(10g/9i/8i/8)

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In 9i when using OMF default size is 100MB.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I wonder who on earth would use OMF, low end servers but still... pointless

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    And I ask again, do you use default settings?

    If we all use default settings we probably have like 20MB SGA for Oracle 8 databases and 50MB SGA for Oracle 8i databases

    What's the reason when we set a large redo log? It's when we expect massive transactions going on

  7. #7
    Join Date
    Sep 2002
    Posts
    40
    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.
    Last edited by smimran; 01-22-2003 at 04:48 AM.
    OCP DBA 7.3,8,8i,9i

  8. #8
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Originally posted by agasimani
    all the datafiles are 100MB by default which are autoexetnsible to unlimited max size.
    *Shudder*... a unlimited maxsize for datafile... Why do oracle do this?
    OCP 8i, 9i DBA
    Brisbane Australia

  9. #9
    Join Date
    Jan 2001
    Posts
    2,828
    Originally posted by pando
    I wonder who on earth would use OMF, low end servers but still... pointless
    pando can you please explain what do you mean by the above statement..well all oracle9i boasts about this OMF feature..why do you think its bad ?

    can you elaborate

    regards
    Hrishy

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well it's not only me who say it, Oracle says

    Code:
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width