| SQL_TEXT |
Start of SQL statement |
CHAR |
60 |
0 |
|
ORASQLTEXT
|
|
| SHARABLE_M |
Total shareable memory |
DEC |
31 |
0 |
|
ORASHARMEM
|
|
| PERSISTENT |
Total 'persistent memory' |
INT4 |
10 |
0 |
|
ORAPERSMEM
|
|
| RUNTIME_ME |
Total "runtime memory" |
INT4 |
10 |
0 |
|
ORARUNTMEM
|
|
| SORTS |
Sum of the number of sorts |
INT4 |
10 |
0 |
|
ORASORTS
|
|
| VERSION_CO |
Number of children |
INT4 |
10 |
0 |
|
ORAVERSCOU
|
|
| LOADED_VER |
Loaded cursor versions |
INT4 |
10 |
0 |
|
ORALOADVER
|
|
| OPEN_VERSI |
Number of opened cursor versions |
INT4 |
10 |
0 |
|
ORAOPENVER
|
|
| USERS_OPEN |
Number of users who have opened cursor version |
INT4 |
10 |
0 |
|
ORAUSROPEN
|
|
| EXECUTIONS |
Total number of executions |
DEC |
31 |
0 |
|
ORAEXECNUM
|
|
| USERS_EXEC |
Number of users executing |
INT4 |
10 |
0 |
|
ORAUSREXEC
|
|
| LOADS |
Number of loads or reloads |
INT4 |
10 |
0 |
|
ORALOADS
|
|
| FIRST_LOAD |
Time SQL statement loaded |
CHAR |
19 |
0 |
|
ORALOAD_T
|
|
| INVALIDATI |
Number of 'invalidations' for all versions |
INT4 |
10 |
0 |
|
ORAINVALID
|
|
| PARSE_CALL |
Sum of all 'parse calls' |
INT4 |
10 |
0 |
|
ORAPARSEC
|
|
| DISK_READS |
Sum of all 'disk reads' |
DEC |
31 |
0 |
|
ORADISKR
|
|
| BUFFER_GET |
Total number of "buffer gets" |
DEC |
31 |
0 |
|
ORABUFFERG
|
|
| ROWS_PROCE |
Number of processed rows |
DEC |
31 |
0 |
|
ORAROWPROC
|
|
| COMMAND_TY |
Oracle command type definition |
INT4 |
10 |
0 |
|
ORACOMTYPE
|
|
| OPTIM_MODE |
Optimizer mode |
CHAR |
10 |
0 |
|
ORAOPTMODE
|
|
| PARSING_US |
ID of the user who built this child cursor |
INT4 |
10 |
0 |
|
ORAPARSUSR
|
|
| PARSING_SC |
Schema ID |
INT4 |
10 |
0 |
|
ORAPARSSCH
|
|
| KEPT_VERSI |
Indicator for using DBMS_SHARED_POOL |
INT4 |
10 |
0 |
|
ORAKEPTVER
|
|
| ADDRESS |
Address of statement in the cache |
CHAR |
16 |
0 |
|
ORAADDRESS
|
|
| HASH_VALUE |
Hash value of statement |
FLTP |
16 |
16 |
|
ORAHASHVAL
|
|
| MODULE |
Program Name |
CHAR |
64 |
0 |
|
ORAMODULE
|
|
| DB_USER |
Column USERNAME in V$SESSION |
CHAR |
10 |
0 |
|
ORAUSER
|
|
| MODULE_HAS |
Hash value of module |
FLTP |
16 |
16 |
|
ORAMODULEH
|
|
| ACTION |
Action name |
CHAR |
64 |
0 |
|
ORAACTION
|
|
| ACTION_HAS |
Hash value of action |
FLTP |
16 |
16 |
|
ORAACTIONH
|
|
| SERIALIZAB |
Number of producing ORA-8177 |
INT4 |
10 |
0 |
|
ORASERIAL
|
|
| CHILD_LATC |
Child Latch Number |
INT4 |
10 |
0 |
|
ORACHILDLA
|
|
| CPU_TIME |
CPU Time in Miroseconds |
DEC |
31 |
0 |
|
ORACPUTIME
|
|
| ELAPSED_TI |
Elapsed Time in Microseconds |
DEC |
31 |
0 |
|
ORAELAPSED
|
|
| DISKRPER_E |
Number of 'disk reads' for each execution |
DEC |
31 |
1 |
|
ORADRPERE
|
|
| BUFFGPER_E |
Number of 'buffer gets' for each execution |
DEC |
31 |
1 |
|
ORABGPERE
|
|
| PARSCPER_E |
Parse calls per execution |
DEC |
31 |
1 |
|
ORAPCPERE
|
|
| ROWSPPER_E |
Number of rows processed for each execution |
DEC |
31 |
1 |
|
ORARPPERE
|
|
| BUFFGPER_R |
Number of 'buffer gets' for each row |
DEC |
31 |
1 |
|
ORABGPERR
|
|
| COLFIELD |
Field for controlling colors in ABAP List Viewer |
CHAR |
3 |
0 |
|
ORACOLFIEL
|
|
| WAIT_TIME |
Wait time |
DEC |
31 |
0 |
|
ORAWAITTIM
|
|
| CPU_TIME_E |
CPU Time per Execution |
DEC |
31 |
1 |
|
ORACTPERE
|
|
| ELAPSEDTIE |
Elapsed Time per Execution |
DEC |
31 |
1 |
|
ORAELAPERE
|
|
| WAITTIME_E |
Wait Time per Execution |
DEC |
31 |
1 |
|
ORAWTPERE
|
|