Home » RDBMS Server » Server Administration » v$db_object_cache
v$db_object_cache [message #57038] Thu, 15 May 2003 21:18 Go to next message
K Praveen Kumar
Messages: 1
Registered: May 2003
Junior Member
1.Can anyone pls expalin what excatly the EXECUTIONS and LOADS column
in v$sqlarea means.Is it the total(till now) number of reloads and execution ever happened after the stored procedure or package has been compiled in the system.

2. How to find wheather a segment has been fragmented and how to avoid this.
Re: v$db_object_cache [message #57039 is a reply to message #57038] Fri, 16 May 2003 00:37 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
V$SQLAREA
V$DB_OBJECT_CACHE

MHE
Previous Topic: extend temp tablespace
Next Topic: About .Net compact framework and windows ce
Goto Forum:
  


Current Time: Mon Dec 30 17:24:02 CST 2024