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 -
Refresh : Will refresh all tabs in the SGA manager from the database
Flush SGA: Flush the system global memory (SGA)
Pin Code: Pin an object to memory
Unpin Code: Unpin an object from memory
Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled
Auto Refresh: Indicates whether to refresh the tab results automatically every X number
of seconds determined by the "Refresh Seconds"
Size: Determines the unit in which to show size columns in the tab results
|
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
|
 Oracle DBA Tools - SGA Manager - SQL Area Tab |
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
|
 Oracle DBA Tools - SGA Manager - Library Cache Tab |
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
|
 Oracle DBA Tools - SGA Manager - Library Statistics Tab |
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
|
 Oracle DBA Tools - SGA Manager - SGA Statistics Tab |
