sql
-
编辑 删除
aa
http://www.eygle.com/archives/2012/05/oracle_sqlid_hash_value.htmlOracle SQLID 与 Hash_value 算法及转换这两者可以相互转换，在Oracle 10g中，提供了一个包函数，用于转换：SQL> select sql_id,hash_v...
-
编辑 删除
hard/soft parse
Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention [ID 62143.1]Hard ParseIf a new SQL statement is issued which does not exist in the shared pool then this h...
-
编辑 删除
v$sql中的LAST_ACTIVE_TIME是解析sql的时间
http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3043.htm#REFRN30246LAST_LOAD_TIMETime at which the query plan was loaded into the library cacheLAST_ACTIVE_TIMETIme at which the ...
