10G 版本:

select dbid,sql_id From dba_hist_sqltext where sql_text like'%SELECT SERVICENAME,DBNAME FROM MC$LG_VERIFYMODE WHERE DBID=:B1%';
 
      DBID SQL_ID
———- ————-
2596226964 9cz5tj7cjz2qw
 
SQL> select * from dba_hist_sql_plan where sql_id='9cz5tj7cjz2qw';
 
   ROWS… …

SQL> select * From table(dbms_xplan.display_awr('9cz5tj7cjz2qw'));
 
PLAN_TABLE_OUTPUT
——————————————————————————–
SQL_ID 9cz5tj7cjz2qw
——————–
SELECT SERVICENAME,DBNAME FROM MC$LG_VERIFYMODE WHERE DBID=:B1
Plan hash value: 2974060023
——————————————————————————–
| Id  | Operation                   | Name             | Rows  | Bytes | Cost (%
——————————————————————————–
|   0 | SELECT STATEMENT            |                  |       |       |     1 (
|   1 |  TABLE ACCESS BY INDEX ROWID| MC$LG_VERIFYMODE |     1 |    30 |     1
|   2 |   INDEX UNIQUE SCAN         | SYS_C005969      |     1 |       |     0
——————————————————————————–
 
14 rows selected
 




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件