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;


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
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member


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: Wed Jul 26 20:11:29 CDT 2017

Total time taken to generate the page: 0.09644 seconds