Home » RDBMS Server » Server Administration » OPTIMAL_LOGFILE_SIZE
OPTIMAL_LOGFILE_SIZE [message #210534] Thu, 21 December 2006 04:05 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
From a book
A new column optimal_logfile_size is now available in v$instance_recovery.This column shows the redo logfile size in MB which is considered an optimal size
But when i run the following

SQL> select optimal_logfile_size
2 from v$instance_recovery;

OPTIMAL_LOGFILE_SIZE
--------------------

What else i have to check?
can anybody help me in this regard?
thanx in advance
Re: OPTIMAL_LOGFILE_SIZE [message #210537 is a reply to message #210534] Thu, 21 December 2006 04:12 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

http://forums.oracle.com/forums/thread.jspa?messageID=1280430&#1280430

Also if you have access to Metalink you have some pinpoints there

[Updated on: Thu, 21 December 2006 04:19]

Report message to a moderator

Previous Topic: Brand new client installation
Next Topic: Impact on file system
Goto Forum:
  


Current Time: Thu Dec 08 01:55:41 CST 2016

Total time taken to generate the page: 0.10329 seconds