_disable_logging
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: _disable_logging

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    can anbody explain me what this parameter does? I researched oracle but I couldnt find much info on i.t
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    It is only used for benchmarking, do not use it if you do not want to loose your database. If you set it to TRUE and your database crashes or you perform a SHUTDOWN ABORT, you will not be able to start up that database again. Ever.

    As I said, it is only used internaly by Oracle Corp when they set up their system for official (or less official) benchmark tests. It instructs the database to absolutely minimize the amount of redo information generated and written into redo log files. But it also means that no instance recovery is possible.

    Do not touch that hidden parameter unless that database is just your play toy of yours.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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