Shared Cursor Cache (PD_PDC)
- Organization of this page
Function
The Shared Cursor Cache (PD_PDC) record stores performance data indicating the status of the shared cursor cache at a specific point in time. PFM - Agent for Oracle creates one record for each shared cursor cache. This is a multi-instance record.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
600 |
Y |
Collection Offset |
10 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
Yes |
N |
ODBC key fields
PD_PDC_ADDRHASH
Lifetime
From the loading to the unloading from the shared SQL area
Record size
-
Fixed part: 678 bytes
-
Variable part: 1,311 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Action (ACTION) |
Name of the action that was executing when the first SQL statement was analyzed |
-- |
string(32) |
No |
All |
V$SQLAREA.ACTION |
Addrhash (ADDRHASH) |
Value identifying the SQL statement being executed |
-- |
string(38) |
No |
All |
V$SQLAREA.ADDRESS V$SQLAREA.HASH_VALUE |
Buffer Gets (BUFFER_GETS) |
Total buffer acquisitions over all child cursors |
-- |
double |
No |
All |
V$SQLAREA.BUFFER_GETS |
Command Type (COMMAND_TYPE) |
Command type |
-- |
string(32) |
No |
All |
V$SQLAREA.COMMAND_TYPE |
Disk Reads (DISK_READS) |
Number of disk blocks read by this cursor and by all cursors executed by this cursor |
-- |
double |
No |
All |
V$SQLAREA.DISK_READS |
Executions (EXECUTIONS) |
Number of times SQL statement was executed |
-- |
double |
No |
All |
V$SQLAREA.EXECUTIONS |
First Load Time (FIRST_LOAD_TIME) |
First time the cursor was loaded into system global area (SGA) |
-- |
string(19) |
No |
All |
V$SQLAREA.FIRST_LOAD_TIME |
Invalidations (INVALIDATIONS) |
Invalidations (INVALIDATIONS) Number of times the cursor's context was invalid for any of the following reasons:
|
-- |
double |
No |
All |
V$SQLAREA.INVALIDATIONS |
Kept Versions (KEPT_VERSIONS) |
Number of cursors of the same SQL statement, package, procedure, function, and trigger anonymous PL/SQL block in the shared pool |
-- |
ulong |
No |
All |
V$SQLAREA.KEPT_VERSIONS |
Loaded Versions (LOADED_VERSIONS) |
Number of cursors that have been entirely loaded because no outdated information exists |
-- |
ulong |
No |
All |
V$SQLAREA.LOADED_VERSIONS |
Loads (LOADS) |
Number of times a cursor was loaded because the cursor body was not used while the text of the SQL statement was in cache or because the cursor was no longer valid |
-- |
double |
No |
All |
V$SQLAREA.LOADS |
Module (MODULE) |
Module name when the first SQL statement was analyzed |
-- |
string(64) |
No |
All |
V$SQLAREA.MODULE |
Open Versions (OPEN_VERSIONS) |
Number of open cursors that belong to the user |
-- |
ulong |
No |
All |
V$SQLAREA.OPEN_VERSIONS |
Parse Calls (PARSE_CALLS) |
Number of times a user issued an analysis call to a cursor |
-- |
double |
No |
All |
V$SQLAREA.PARSE_CALLS |
Parsing Schema ID (PARSING_SCHEMA_ID) |
Schema ID used to analyze SQL statements |
-- |
long |
No |
All |
V$SQLAREA.PARSING_SCHEMA_ID |
Parsing User ID (PARSING_USER_ID) |
User ID that analyzed the SQL statements |
-- |
long |
No |
All |
V$SQLAREA.PARSING_USER_ID |
Persistent Mem (PERSISTENT_MEM) |
Amount of memory (in bytes) per user while the cursor was valid |
-- |
double |
No |
All |
V$SQLAREA.PERSISTENT_MEM |
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PDC) |
-- |
string(4) |
No |
All |
Agent Collector |
Rows Processed (ROWS_PROCESSED) |
Number of rows returned by processing or SQL statements |
-- |
double |
No |
All |
V$SQLAREA.ROWS_PROCESSED |
Runtime Mem (RUNTIME_MEM) |
Amount of memory (in bytes) required per user only during the execution |
-- |
double |
No |
All |
V$SQLAREA.RUNTIME_MEM |
SQL Text (SQL_TEXT) |
SQL text or PL/SQL statement that requires the cursor |
-- |
string(1000) |
No |
All |
V$SQLAREA.SQL_TEXT |
Sharable Mem (SHARABLE_MEM) |
Amount of memory that can be shared by users |
-- |
double |
No |
All |
V$SQLAREA.SHARABLE_MEM |
Sorts (SORTS) |
Number of sort operations executed by SQL statements |
-- |
double |
No |
All |
V$SQLAREA.SORTS |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Users Executing (USERS_EXECUTING) |
Number of users currently executing the cursor |
-- |
long |
No |
All |
V$SQLAREA.USERS_EXECUTING |
Users Opening SQL (USERS_OPENING_SQL) |
Number of users currently using the open cursor to analyze statements |
-- |
long |
No |
All |
V$SQLAREA.USERS_OPENING |
Version Count (VERSION_COUNT) |
Number of cursors (Multiple users might execute the same SQL statement on different versions of a single table.) |
-- |
ulong |
No |
All |
V$SQLAREA.VERSION_COUNT |