Oracle DBA Tools - SGA Manager Provides manageability of the Oracle SGA area, including SQL Area, Lib Cache, Lib Cache Stats and a summary of the SGA. Allowing users to also pin and unpin code. | |
Toolbar Operations - | |
| SQL Area Tab - Provides a list of statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution. SQL: SQL text Parsing User: User that has parsed the very first cursor under this parent Sharable Mem: Amount of shared memory used by a cursor. If multiple child cursors exist, then the sum of all shared memory used by all child cursors. Persistent Mem: Fixed amount of memory used for the lifetime of an open cursor. If multiple child cursors exist, the fixed sum of memory used for the lifetime of all the child cursors. Runtime Mem: Fixed amount of memory required during execution of a cursor. If multiple child cursors exist, the fixed sum of all memory required during execution of all the child cursors. Sort: Sum of the number of sorts that were done for all the child cursors Execution: Total number of executions, totalled over all the child cursors Parse Calls: Sum of all parse calls to all the child cursors under this parent Module: Contains the name of the module that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_MODULE Buffer Gets: Sum of buffer gets over all child cursors Disk Reads: Sum of the number of disk reads over all child cursors Version Count: Number of child cursors that are present in the cache under this parent Users Opening: Number of users that have any of the child cursors open Loads: Number of times the object was loaded or reloaded First Time Load: Timestamp of the parent creation time Address: Address of the handle to the parent for this cursor Hash Value: Hash value of the parent statement in the library cache Rows Processed: Total number of rows processed on behalf of this SQL statement Command Type: Oracle command type definition Optimizer: Mode under which the SQL statement was executed | |
| Lib Cache Tab - Provides a list of database objects that are cached in the library cache. Owner: Owner of the object Package: Name of the object Type: Type of the object Size: Amount of sharable memory in the shared pool consumed by the object Loads: Number of times the object has been loaded. This count also increases when an object has been invalidated. Pinned: Indicates whether the object is pinned Runs: Total number of executions Locks: Number of users currently locking this object Pins: Number of users currently pinning this object | |
| Lib Cache Stats Tab - Provides a list of statistics about library cache performance and activity. Namespace: Library cache namespace Gets: Number of times a lock was requested for objects of this namespace Get Hits: Number of times an object’s handle was found in memory Get Hit Ratio: Ratio of GETHITS to GETS Pins: Number of times a PIN was requested for objects of this namespace Pin Hits: Number of times all of the metadata pieces of the library object were found in memory Pin Hit Ratio: Ratio of PINHITS to PINS Reloads: Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk Invalidations: The total number of times objects in this namespace were marked invalid because a dependent object was modified DLM Lock Requests: Number of GET requests lock instance locks DLM Pin Requests: Number of PIN requests lock instance locks DLM Pin Releases: Number of release requests PIN instance locks DLM Invalidation Requests: Number of GET requests for invalidation instance locks DLM Invalidations: Number of invalidation pings received from other instances | |
| SGA Stats Tab - Provides summary information about the system global area (SGA) Pool: Designates the pool in which the memory in NAME resides Name: SGA component name Size: Memory size | |
