v$SQLAREA 是一张描述shared pool 父游标信息的视图。其含义为
Column | Datatype | Description | 含义 |
SQL_TEXT | VARCHAR2(1000) | First thousand characters of the SQL text for the current cursor | SQL语句前1000字符 |
SQL_FULLTEXT | CLOB | All characters of the SQL text for the current cursor | SQL语句全文 |
SQL_ID | VARCHAR2(13) | SQL identifier of the parent cursor in the library cache | SQL_ID |
SHARABLE_MEM | NUMBER | 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 | NUMBER | Fixed amount of memory used for the lifetime of an open cursor. If multiple child cursors exist, then the fixed sum of memory used for the lifetime of all the child cursors. | 所有子游标在打开的生命周期内固定内存总大小 |
RUNTIME_MEM | NUMBER | Fixed amount of memory required during execution of a cursor. If multiple child cursors exist, then the fixed sum of all memory required during execution of all the child cursors. | 所有子游标在执行生命周期内固定内存总大小 |
SORTS | NUMBER | Sum of the number of sorts that were done for all the child cursors | 所有子游标排序的次数 |
VERSION_COUNT | NUMBER | Number of child cursors that are present in the cache under this parent | 此父游标下子游标的数量 |
LOADED_VERSIONS | NUMBER | Number of child cursors that are present in the cache and have their context heap loaded | 此父游标下子游标装载到cache中的数量 |
OPEN_VERSIONS | NUMBER | Number of child cursors that are currently open under this current parent | 此父游标下当前打开的子游标数量 |
USERS_OPENING | NUMBER | Number of users that have any of the child cursors open | 所有打开子游标的用户的数量 |
FETCHES | NUMBER | Number of fetches associated with the SQL statement | SQL语句获取次数 |
EXECUTIONS | NUMBER | Total number of executions, totalled over all the child cursors | 执行次数 |
PX_SERVERS_EXECUTIONS | NUMBER | Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel) | 并行执行次数 |
END_OF_FETCH_COUNT | NUMBER | Number of times this cursor was fully executed since the cursor was brought into the library cache. The value of this statistic is not incremented when the cursor is partially executed, eithe |