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 |