-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
— Buffer hit ratioselect (1-(sum(decode(name, ‘physical reads’, value, 0))/(sum(decode(name, ‘db block gets’, value, 0)) +(sum(decode(name, ‘consistent gets’, value, 0))))))*100 “Buffer… READ MORE
http://www.dba-oracle.com/t_x$ksmlru_x$ksmsp_shared_pool_monitoring.htm READ MORE
One can flush the shared pool using the following DDL. SQL> ALTER SYSTEM FLUSH SHARED_POOL; System altered. Using the following… READ MORE
|
To use automatic shared memory management, the value of statistics_level must be set to “typical” or “all”. The parameter can… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 