-
Log Buffer Size
i execute the following script
SQL> @c:\sga_statistics.sql;
PL/SQL procedure successfully completed.
SQL> set serveroutput on;
SQL> /
> SGA CACHE STATISTICS
> ********************
> SQL Cache Hit rate = 99.24
> Dict Cache Hit rate = 99.67
> Buffer Cache Hit rate = 99.88
> Redo Log space requests = 1440
>
> INIT.ORA SETTING
> ****************
> Shared Pool Size = 52428800 Bytes
> DB Block Buffer = 32768 Blocks
> Log Buffer = 20971520 Bytes
>
*** HINT: Log Buffer value is rather low!
should i have to increase the size of log_buffer Because Redo Log space requests = 1440 is high?
What u'll suggest Sir?
thanx in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|