Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Question about parsing
These are the records in v_$sql.
SQL_TEXT is truncated. It is long. (31 rows each in V_$SQLTEXT)
SQL_TEXT SHARABLE_MEM PERSISTENT_MEM RUNTIME_MEM SORTS LOADED_VERSIONS OPEN_VERSIONS USERS_OPENING EXECUTIONS USERS_EXECUTING LOADS FIRST_LOAD_TIME INVALIDATIONS PARSE_CALLS DISK_READS BUFFER_GETS ROWS_PROCESSED COMMAND_TYPE OPTIMIZER_MODE OPTIMIZER_COST PARSING_USER_ID PARSING_SCHEMA_ID KEPT_VERSIONS ADDRESS TYPE_CHK_HEAP HASH_VALUE CHILD_NUMBER MODULE MODULE_HASH ACTION ACTION_HASH SERIALIZABLE_ABORTS select /*+ ORDERED */ 65124 1008 9648 0 1 0 0 4 0 2 2002-01-22/09:26:36 0 1 0 2 0 3 CHOOSE 7 17 17 0 81EEB098 00 868177513 0 01@ jj.sql 729151101 -265190056 0 select /*+ ORDERED */ 55224 868 0 0 1 1 1 0 1 3 2002-01-22/09:16:36 0 0 0 0 0 3 CHOOSE 0 17 17 0 820C3F88 82078F74 3152812833 0 0 0 0Received on Tue Jan 22 2002 - 05:37:36 CST