查询v$lock视图hang住

最新推荐文章于 2024-10-21 09:42:51 发布

huangliang0703

最新推荐文章于 2024-10-21 09:42:51 发布

阅读量496

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/huangliang0703/article/details/44888941

查询v$lock视图时行住了：

</pre><pre code_snippet_id="636664" snippet_file_name="blog_20150405_3_3131939" name="code" class="html">SQL> explain plan for select sid,addr  from v$lock;

Explained.

SQL> SELECT * FROM table(DBMS_XPLAN.DISPLAY);

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 1899724433

-------------------------------------------------------------------------------------
| Id  | Operation              | Name       | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |            |     1 |    69 |     1 (100)| 00:00:01 |
|*  1 |  HASH JOIN             |            |     1 |    69 |     1 (100)| 00:00:01 |
|   2 |   MERGE JOIN CARTESIAN |            |   100 |  5100 |     0   (0)| 00:00:01 |
|*  3 |    FIXED TABLE FULL    | X$KSUSE    |     1 |    32 |     0   (0)| 00:00:01 |
|   4 |    BUFFER SORT         |            |   100 |  1900 |     0   (0)| 00:00:01 |
|   5 |     FIXED TABLE FULL   | X$KSQRS    |   100 |  1900 |     0   (0)| 00:00:01 |
|   6 |   VIEW                 | GV$_LOCK   |    10 |   180 |     0   (0)| 00:00:01 |
|   7 |    UNION-ALL           |            |       |       |            |          |
|*  8 |     FILTER             |            |       |       |            |          |
|   9 |      VIEW              | GV$_LOCK1  |     2 |    36 |     0   (0)| 00:00:01 |
|  10 |       UNION-ALL        |            |       |       |            |          |
|* 11 |        FIXED TABLE FULL| X$KDNSSF   |     1 |    70 |     0   (0)| 00:00:01 |
|* 12 |        FIXED TABLE FULL| X$KSQEQ    |     1 |    70 |     0   (0)| 00:00:01 |
|* 13 |     FIXED TABLE FULL   | X$KTADM    |     1 |    70 |     0   (0)| 00:00:01 |
|* 14 |     FIXED TABLE FULL   | X$KTATRFIL |     1 |    70 |     0   (0)| 00:00:01 |
|* 15 |     FIXED TABLE FULL   | X$KTATRFSL |     1 |