V$SQLAREA

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