V $ SQLAREA, V $ SQL, V $ SQLText Differences and Contact

zhaozj2021-02-12  124

V $ sqltext is stored is a complete SQL, SQL is split SQL> Desc v $ sqltextName Null? Type ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------ Address RAW (4) --------------- and address together unique logo a SQLCommand_type number number Number ---------- Sequential number SQL_Text VARCHAR2 (64) -------------- Pay attention to the length V $ SQLAREA ------- Store SQL and some related information, such as the cumulative number of execution, logically read, Physical Reading and other statistics SQL> DESC V $ SQLAREANAME NULL? TYPE -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ ---------------------------- SQL_Text varchar2 (1000) Sharable_mem number_mem number number u number NUMBERVERSION_COUNT NUMBERLOADED_VERSIONS NUMBEROPEN_VERSIONS NUMBERUSERS_OPENING NUMBERFETCHES NUMBEREXECUTIONS NUMBERUSERS_EXECUTING NUMBERLOADS NUMBERFIRST_LOAD_TIME VARCHAR2 (38) INVALIDATIONS NUMBERPARSE_CALLS NUMBERDISK_READS NUMBERBUFFER_GETS NUMBERROWS_PROCESSED NUMBERCOMMAND_TYPE NUMBEROPTIMIZER_MODE VARCHAR2 (25) PARSING_USER_ID NUMBERPARSING_SCHEMA_ID NUMBERKEPT_VERSIONS NUMBERADDRESS RAW (4) HASH_VALUE NUMBERMODULE VARCHAR2 (64 ) MODULE_HASH NUMBERACTION VARCHAR2 (64) ACTION_HASH NUMBERSERIALIZABLE_ABORTS NUMBERCPU_TIME NUMBERELAPSED_TIME NUMBERIS_OBSOLETE VARCHAR2 (1) CHILD_LATCH NUMBERv $ sql ---------- storage is the specific SQL execution plan and related information, in fact, v $ sqlarea can see Do V $ SQL, according to SQLText, etc., the information after GROUP BY, SQL>

DESC V $ SQLNAME NULL? TYPE ----------------------------------------- ------ ---------------------------- SQL_TEXT VARCHAR2 (1000) SHARABLE_MEM NUMBERPERSISTENT_MEM NUMBERRUNTIME_MEM NUMBERSORTS NUMBERLOADED_VERSIONS NUMBEROPEN_VERSIONS NUMBERUSERS_OPENING NUMBERFETCHES NUMBEREXECUTIONS NUMBERUSERS_EXECUTING NUMBERLOADS NUMBERFIRST_LOAD_TIME VARCHAR2 (38) INVALIDATIONS NUMBERPARSE_CALLS NUMBERDISK_READS NUMBERBUFFER_GETS NUMBERROWS_PROCESSED NUMBERCOMMAND_TYPE NUMBEROPTIMIZER_MODE VARCHAR2 (10) OPTIMIZER_COST NUMBERPARSING_USER_ID NUMBERPARSING_SCHEMA_ID NUMBERKEPT_VERSIONS NUMBERADDRESS RAW (4) TYPE_CHK_HEAP RAW (4) HASH_VALUE NUMBERPLAN_HASH_VALUE NUMBERCHILD_NUMBER NUMBER ---------- Note that this MODULE VARCHAR2 (64 ) MODULE_HASH NUMBERACTION VARCHAR2 (64) ACTION_HASH NUMBERSERIALIZABLE_ABORTS NUMBEROUTLINE_CATEGORY VARCHAR2 (64) CPU_TIME NUMBERELAPSED_TIME NUMBEROUTLINE_SID NUMBER -------------- Note that with the outline about CHILD_ADDRESS RAW (4) SQLTYPE NUMBERREMOTE VARCHAR2 (1) OBJECT_STATUS VARCHAR2 (19) Literal_hash_Value N UMBERLAST_LOAD_TIME VARCHAR2 (38) IS_OBSOLETE VARCHAR2 (1) Child_LATCH NUMBER NOTINETRODUCTION This QL>

转载请注明原文地址:https://www.9cbs.com/read-7229.html

New Post(0)