Oracle extents视图,Oracle查询dba_extents视图很慢

最新推荐文章于 2022-07-31 12:14:04 发布
最新推荐文章于 2022-07-31 12:14:04 发布
阅读量155 收藏
点赞数
文章标签： Oracle extents视图

20:27:48 SYS@anonymous> select * from table(dbms_xplan.display_cursor(null,null,'allstats last'));

PLAN_TABLE_OUTPUT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL_ID dggb0d96bj8dy, child number 4

-------------------------------------

select owner,tablespace_name from dba_extents where segment_name='AUD$'

group byowner,tablespace_namePlan hash value: 1482657742

------------------------------------------------------------------------------------------------------------------------------------------------------------

| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |

------------------------------------------------------------------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | 1 | | 1 |00:01:01.87 | 190K| 7157 | | | |

| 1 | HASH GROUP BY | | 1 | 543K| 1 |00:01:01.87 | 190K| 7157 | 2331K| 2194K| 435K (0)|

| 2 | VIEW | DBA_EXTENTS | 1 | 543K| 259 |00:01:01.87 | 190K| 7157 | | | |

| 3 | UNION-ALL | | 1 | | 259 |00:01:01.87 | 190K| 7157 | | | |

| 4 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

| 5 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

| 6 | TABLE ACCESS FULL | UET$ | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

|* 7 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 8 | VIEW | SYS_DBA_SEGS | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 9 | UNION ALL PUSHED PREDICATE | | 0 | | 0 |00:00:00.01 | 0 | 0 | | | |

| 10 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 11 | NESTED LOOPS OUTER | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 12 | MERGE JOIN CARTESIAN | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 13 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 14 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 15 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 16 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 17 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 18 | TABLE ACCESS CLUSTER | SEG$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 19 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 20 | BUFFER SORT | | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | 73728 | 73728 | |

|* 21 | INDEX SKIP SCAN | I_OBJ2 | 0 | 2 | 0 |00:00:00.01 | 0 | 0 | | | |

| 22 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 23 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 24 | VIEW | SYS_OBJECTS | 0 | 5 | 0 |00:00:00.01 | 0 | 0 | | | |

| 25 | UNION ALL PUSHED PREDICATE | | 0 | | 0 |00:00:00.01 | 0 | 0 | | | |

|* 26 | TABLE ACCESS CLUSTER | TAB$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 27 | INDEX UNIQUE SCAN | I_OBJ# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 28 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 29 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 30 | TABLE ACCESS CLUSTER | CLU$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 31 | INDEX UNIQUE SCAN | I_OBJ# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 32 | TABLE ACCESS BY INDEX ROWID | IND$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 33 | INDEX UNIQUE SCAN | I_IND1 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 34 | TABLE ACCESS BY INDEX ROWID | INDPART$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 35 | INDEX UNIQUE SCAN | I_INDPART_OBJ$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 36 | TABLE ACCESS BY INDEX ROWID | LOB$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 37 | INDEX UNIQUE SCAN | I_LOB2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 38 | TABLE ACCESS BY INDEX ROWID | TABSUBPART$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 39 | INDEX UNIQUE SCAN | I_TABSUBPART$_OBJ$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 40 | TABLE ACCESS BY INDEX ROWID | INDSUBPART$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 41 | INDEX UNIQUE SCAN | I_INDSUBPART_OBJ$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 42 | TABLE ACCESS BY INDEX ROWID | LOBFRAG$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 43 | INDEX UNIQUE SCAN | I_LOBFRAG$_FRAGOBJ$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 44 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 45 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 46 | NESTED LOOPS OUTER | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 47 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 48 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 49 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 50 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 51 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 52 | TABLE ACCESS CLUSTER | SEG$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 53 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 54 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 55 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 56 | INDEX RANGE SCAN | I_UNDO2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 57 | TABLE ACCESS BY INDEX ROWID | UNDO$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 58 | NESTED LOOPS OUTER | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 59 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 60 | NESTED LOOPS | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 61 | TABLE ACCESS BY INDEX ROWID | FILE$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 62 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 63 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 64 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 65 | TABLE ACCESS CLUSTER | SEG$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 66 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 67 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 68 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|* 69 | HASH JOIN | | 1 | 543K| 259 |00:01:01.87 | 190K| 7157 | 1214K| 1214K| 709K (0)|

|* 70 | HASH JOIN | | 1 | 20549 | 1 |00:00:00.33 | 138K| 0 | 1969K| 1969K| 1531K (0)|

| 71 | INDEX FULL SCAN | I_FILE2 | 1 | 106 | 108 |00:00:00.01 | 1 | 0 | | | |

| 72 | VIEW | SYS_DBA_SEGS | 1 | 6785 | 1 |00:00:00.33 | 138K| 0 | | | |

| 73 | UNION-ALL | | 1 | | 1 |00:00:00.33 | 138K| 0 | | | |

| 74 | NESTED LOOPS | | 1 | 6783 | 1 |00:00:00.32 | 137K| 0 | | | |

| 75 | NESTED LOOPS OUTER | | 1 | 2 | 10578 |00:00:00.10 | 21543 | 0 | | | |

| 76 | MERGE JOIN CARTESIAN | | 1 | 2 | 10578 |00:00:00.07 | 10961 | 0 | | | |

| 77 | NESTED LOOPS | | 1 | 1 | 10578 |00:00:00.06 | 10896 | 0 | | | |

| 78 | NESTED LOOPS | | 1 | 1 | 10578 |00:00:00.03 | 314 | 0 | | | |

|* 79 | TABLE ACCESS FULL | SEG$ | 1 | 1 | 10578 |00:00:00.02 | 310 | 0 | | | |

|* 80 | INDEX UNIQUE SCAN | I_FILE2 | 10578 | 1 | 10578 |00:00:00.01 | 4 | 0 | | | |

| 81 | TABLE ACCESS CLUSTER | TS$ | 10578 | 1 | 10578 |00:00:00.02 | 10582 | 0 | | | |

|* 82 | INDEX UNIQUE SCAN | I_TS# | 10578 | 1 | 10578 |00:00:00.01 | 4 | 0 | | | |

| 83 | BUFFER SORT | | 10578 | 2 | 10578 |00:00:00.01 | 65 | 0 | 2048 | 2048 | 2048 (0)|

|* 84 | INDEX SKIP SCAN | I_OBJ2 | 1 | 2 | 1 |00:00:00.01 | 65 | 0 | | | |

| 85 | TABLE ACCESS CLUSTER | USER$ | 10578 | 1 | 10578 |00:00:00.02 | 10582 | 0 | | | |

|* 86 | INDEX UNIQUE SCAN | I_USER# | 10578 | 1 | 10578 |00:00:00.01 | 4 | 0 | | | |

|* 87 | VIEW | SYS_OBJECTS | 10578 | 2 | 1 |00:00:00.22 | 116K| 0 | | | |

| 88 | UNION ALL PUSHED PREDICATE | | 10578 | | 10578 |00:00:00.21 | 116K| 0 | | | |

|* 89 | TABLE ACCESS CLUSTER | TAB$ | 10578 | 1 | 10578 |00:00:00.03 | 21161 | 0 | | | |

|* 90 | INDEX UNIQUE SCAN | I_OBJ# | 10578 | 1 | 10578 |00:00:00.01 | 10583 | 0 | | | |

| 91 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 10578 | 1 | 0 |00:00:00.01 | 10583 | 0 | | | |

|* 92 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 10578 | 1 | 0 |00:00:00.01 | 10583 | 0 | | | |

| 93 | TABLE ACCESS CLUSTER | CLU$ | 10578 | 1 | 0 |00:00:00.02 | 21161 | 0 | | | |

|* 94 | INDEX UNIQUE SCAN | I_OBJ# | 10578 | 1 | 10578 |00:00:00.01 | 10583 | 0 | | | |

|* 95 | TABLE ACCESS BY INDEX ROWID | IND$ | 10578 | 1 | 0 |00:00:00.01 | 10583 | 0 | | | |

|* 96 | INDEX UNIQUE SCAN | I_IND1 | 10578 | 1 | 0 |00:00:00.01 | 10583 | 0 | | | |

| 97 | TABLE ACCESS BY INDEX ROWID | INDPART$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

|* 98 | INDEX UNIQUE SCAN | I_INDPART_OBJ$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

|* 99 | TABLE ACCESS BY INDEX ROWID | LOB$ | 10578 | 1 | 0 |00:00:00.01 | 10583 | 0 | | | |

|*100 | INDEX UNIQUE SCAN | I_LOB2 | 10578 | 1 | 0 |00:00:00.01 | 10583 | 0 | | | |

| 101 | TABLE ACCESS BY INDEX ROWID | TABSUBPART$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

|*102 | INDEX UNIQUE SCAN | I_TABSUBPART$_OBJ$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

| 103 | TABLE ACCESS BY INDEX ROWID | INDSUBPART$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

|*104 | INDEX UNIQUE SCAN | I_INDSUBPART_OBJ$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

| 105 | TABLE ACCESS BY INDEX ROWID | LOBFRAG$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

|*106 | INDEX UNIQUE SCAN | I_LOBFRAG$_FRAGOBJ$ | 10578 | 1 | 0 |00:00:00.01 | 10578 | 0 | | | |

| 107 | NESTED LOOPS OUTER | | 1 | 1 | 0 |00:00:00.01 | 2 | 0 | | | |

| 108 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 2 | 0 | | | |

| 109 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 2 | 0 | | | |

| 110 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 2 | 0 | | | |

|*111 | TABLE ACCESS BY INDEX ROWID| UNDO$ | 1 | 1 | 0 |00:00:00.01 | 2 | 0 | | | |

|*112 | INDEX RANGE SCAN | I_UNDO2 | 1 | 1 | 0 |00:00:00.01 | 2 | 0 | | | |

|*113 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*114 | TABLE ACCESS CLUSTER | SEG$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*115 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 116 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*117 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 118 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*119 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 120 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

| 121 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

| 122 | NESTED LOOPS OUTER | | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

| 123 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

|*124 | TABLE ACCESS FULL | SEG$ | 1 | 1 | 0 |00:00:00.01 | 310 | 0 | | | |

| 125 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*126 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 127 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*128 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*129 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

|*130 | TABLE ACCESS BY INDEX ROWID | FILE$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |

| 131 | FIXED TABLE FULL | X$KTFBUE | 1 | 100K| 723K|00:01:01.20 | 52350 | 7157 | | | |

------------------------------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identifiedbyoperation id):---------------------------------------------------

7 - access("E"."TS#"="F"."TS#" AND "E"."FILE#"="F"."RELFILE#")15 - access("F"."TS#"="E"."TS#" AND "F"."RELFILE#"="E"."SEGFILE#")17 - access("TS"."TS#"="E"."TS#")18 - filter((BITAND(NVL("S"."SPARE1",0),1)=0 AND BITAND(NVL("S"."SPARE1",0),65536)=0))19 - access("S"."TS#"="E"."TS#" AND "S"."FILE#"="E"."SEGFILE#" AND "S"."BLOCK#"="E"."SEGBLOCK#")

filter(("S"."TS#"="TS"."TS#" AND "S"."TS#"="F"."TS#" AND "S"."FILE#"="F"."RELFILE#"))21 - access("O"."NAME"='AUD$')

filter("O"."NAME"='AUD$')23 - access("O"."OWNER#"="U"."USER#")24 - filter(("S"."FILE#"="SO"."HEADER_FILE" AND "S"."BLOCK#"="SO"."HEADER_BLOCK" AND "S"."TS#"="SO"."TS_NUMBER" AND"S"."TYPE#"="SO"."SEGMENT_TYPE_ID" AND "O"."TYPE#"="SO"."OBJECT_TYPE_ID"))26 - filter(("T"."BLOCK#"="E"."SEGBLOCK#" AND "T"."FILE#"="E"."SEGFILE#" AND "T"."TS#"="E"."TS#" AND BITAND("T"."PROPERTY",1024)=0))27 - access("T"."OBJ#"="O"."OBJ#")28 - filter(("TP"."BLOCK#"="E"."SEGBLOCK#" AND "TP"."FILE#"="E"."SEGFILE#" AND "TP"."TS#"="E"."TS#"))29 - access("TP"."OBJ#"="O"."OBJ#")30 - filter(("C"."BLOCK#"="E"."SEGBLOCK#" AND "C"."FILE#"="E"."SEGFILE#" AND "C"."TS#"="E"."TS#"))31 - access("C"."OBJ#"="O"."OBJ#")32 - filter(("I"."BLOCK#"="E"."SEGBLOCK#" AND "I"."FILE#"="E"."SEGFILE#" AND "I"."TS#"="E"."TS#" ANDINTERNAL_FUNCTION("I"."TYPE#")))33 - access("I"."OBJ#"="O"."OBJ#")34 - filter(("IP"."BLOCK#"="E"."SEGBLOCK#" AND "IP"."FILE#"="E"."SEGFILE#" AND "IP"."TS#"="E"."TS#"))35 - access("IP"."OBJ#"="O"."OBJ#")36 - filter(("L"."BLOCK#"="E"."SEGBLOCK#" AND "L"."FILE#"="E"."SEGFILE#" AND "L"."TS#"="E"."TS#" AND (BITAND("L"."PROPERTY",64)=0 ORBITAND("L"."PROPERTY",128)=128)))37 - access("L"."LOBJ#"="O"."OBJ#")38 - filter(("TSP"."BLOCK#"="E"."SEGBLOCK#" AND "TSP"."FILE#"="E"."SEGFILE#" AND "TSP"."TS#"="E"."TS#"))39 - access("TSP"."OBJ#"="O"."OBJ#")40 - filter(("ISP"."FILE#"="E"."SEGFILE#" AND "ISP"."BLOCK#"="E"."SEGBLOCK#" AND "ISP"."TS#"="E"."TS#"))41 - access("ISP"."OBJ#"="O"."OBJ#")42 - filter(("LF"."BLOCK#"="E"."SEGBLOCK#" AND "LF"."FILE#"="E"."SEGFILE#" AND "LF"."TS#"="E"."TS#"))43 - access("LF"."FRAGOBJ#"="O"."OBJ#")49 - access("F"."TS#"="E"."TS#" AND "F"."RELFILE#"="E"."SEGFILE#")51 - access("TS"."TS#"="E"."TS#")52 - filter((INTERNAL_FUNCTION("S"."TYPE#") AND BITAND(NVL("S"."SPARE1",0),1)=0 AND BITAND(NVL("S"."SPARE1",0),65536)=0))53 - access("S"."TS#"="E"."TS#" AND "S"."FILE#"="E"."SEGFILE#" AND "S"."BLOCK#"="E"."SEGBLOCK#")

filter("S"."TS#"="TS"."TS#")55 - access("S"."USER#"="U"."USER#")56 - access("UN"."NAME"='AUD$')57 - filter(("UN"."BLOCK#"="E"."SEGBLOCK#" AND "UN"."FILE#"="E"."SEGFILE#" AND "UN"."TS#"="E"."TS#" AND "UN"."STATUS$"<>1 AND"S"."FILE#"="UN"."FILE#" AND "S"."BLOCK#"="UN"."BLOCK#" AND "S"."TS#"="UN"."TS#" AND "UN"."TS#"="F"."TS#" AND "UN"."FILE#"="F"."RELFILE#"))62 - access("F"."TS#"="E"."TS#" AND "F"."RELFILE#"="E"."SEGFILE#")64 - access("TS"."TS#"="E"."TS#")65 - filter(("S"."TYPE#"<>6 AND "S"."TYPE#"<>5 AND "S"."TYPE#"<>8 AND BITAND(NVL("S"."SPARE1",0),1)=0 AND BITAND(NVL("S"."SPARE1",0),65536)=0 AND"S"."TYPE#"<>10 AND "S"."TYPE#"<>1))66 - access("S"."TS#"="E"."TS#" AND "S"."FILE#"="E"."SEGFILE#" AND "S"."BLOCK#"="E"."SEGBLOCK#")

filter(("S"."TS#"="TS"."TS#" AND "S"."TS#"="F"."TS#" AND "S"."FILE#"="F"."RELFILE#" ANDTO_CHAR("F"."FILE#")||'.'||TO_CHAR("S"."BLOCK#")='AUD$'))68 - access("S"."USER#"="U"."USER#")69 - access("E"."KTFBUESEGFNO"="DS"."RELATIVE_FNO" AND "E"."KTFBUESEGBNO"="DS"."HEADER_BLOCK" AND "E"."KTFBUESEGTSN"="DS"."TABLESPACE_ID" AND"E"."KTFBUEFNO"="F"."RELFILE#")70 - access("DS"."TABLESPACE_ID"="F"."TS#")79 - filter((BITAND(NVL("S"."SPARE1",0),1)=1 AND BITAND(NVL("S"."SPARE1",0),65536)=0))80 - access("S"."TS#"="F"."TS#" AND "S"."FILE#"="F"."RELFILE#")82 - access("S"."TS#"="TS"."TS#")84 - access("O"."NAME"='AUD$')

filter("O"."NAME"='AUD$')86 - access("O"."OWNER#"="U"."USER#")87 - filter(("S"."FILE#"="SO"."HEADER_FILE" AND "S"."BLOCK#"="SO"."HEADER_BLOCK" AND "S"."TS#"="SO"."TS_NUMBER" AND"S"."TYPE#"="SO"."SEGMENT_TYPE_ID" AND "O"."TYPE#"="SO"."OBJECT_TYPE_ID"))89 - filter(BITAND("T"."PROPERTY",1024)=0)90 - access("T"."OBJ#"="O"."OBJ#")92 - access("TP"."OBJ#"="O"."OBJ#")94 - access("C"."OBJ#"="O"."OBJ#")95 - filter(("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR "I"."TYPE#"=8 OR"I"."TYPE#"=9))96 - access("I"."OBJ#"="O"."OBJ#")98 - access("IP"."OBJ#"="O"."OBJ#")99 - filter((BITAND("L"."PROPERTY",64)=0 OR BITAND("L"."PROPERTY",128)=128))100 - access("L"."LOBJ#"="O"."OBJ#")102 - access("TSP"."OBJ#"="O"."OBJ#")104 - access("ISP"."OBJ#"="O"."OBJ#")106 - access("LF"."FRAGOBJ#"="O"."OBJ#")111 - filter("UN"."STATUS$"<>1)112 - access("UN"."NAME"='AUD$')113 - access("UN"."TS#"="F"."TS#" AND "UN"."FILE#"="F"."RELFILE#")114 - filter((INTERNAL_FUNCTION("S"."TYPE#") AND BITAND(NVL("S"."SPARE1",0),1)=1 AND BITAND(NVL("S"."SPARE1",0),65536)=0))115 - access("S"."TS#"="UN"."TS#" AND "S"."FILE#"="UN"."FILE#" AND "S"."BLOCK#"="UN"."BLOCK#")117 - access("S"."TS#"="TS"."TS#")119 - access("S"."USER#"="U"."USER#")124 - filter(("S"."TYPE#"<>6 AND "S"."TYPE#"<>5 AND "S"."TYPE#"<>8 AND BITAND(NVL("S"."SPARE1",0),1)=1 AND BITAND(NVL("S"."SPARE1",0),65536)=0 AND"S"."TYPE#"<>10 AND "S"."TYPE#"<>1))126 - access("S"."TS#"="TS"."TS#")128 - access("S"."USER#"="U"."USER#")129 - access("S"."TS#"="F"."TS#" AND "S"."FILE#"="F"."RELFILE#")130 - filter(TO_CHAR("F"."FILE#")||'.'||TO_CHAR("S"."BLOCK#")='AUD$')232rows selected.

Elapsed:00:00:00.10

谷桐羽
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
DBA_LMT_USED_EXTENTS视图访问缓慢
ckawt40802的专栏
03-30 90
又一个访问数据字典视图缓慢的bug。 访问DBA_LMT_USED_EXTENTS视图时出现长时间等待： SQL> SET AUTOT TRACESQL> SET TIMING ON...
oracle的dba_ segment,dba_extents和dba_segments不一致问题及原因
weixin_35097346的博客
04-03 583
dba_extents和dba_segments不一致问题及原因日志。Metalink Note 463101.1文章 HOW TO DISCOVER AND FIX THE MISTMATCH BETWEENDBA_SEGMENTS AND DBA_EXTENTS DICTIONARY VIEWS 描述了这一问题。根据描述，这个问题主要发生在并行索引创建、频繁的DELETE/INSERT等操作中...
[20170516]10g分析SYS.X$KTFBUE.txt
weixin_34137799的博客
05-16 175
[20170516]10g分析SYS.X$KTFBUE.txt --//昨天别人问的问题,就是调用dba_extents很慢,我建议他对X$进行分析. --//执行如下:exec dbms_stats.gather_fixed_objects_stats(); --//问题依旧.我google,baidu看了一下...
Oracle DBA_EXTENTS视图 与 DBA_SEGMENTS视图
最新发布
一个只求实际的程序猿
07-31 698
Oracle DBA_EXTENTS视图 与 DBA_SEGMENTS视图
Oracle10g DBA经常使用的动态性能视图和数据字典
04-06
dba_extents:数据库中所有分区的信息 dba_free_space:所有表空间中的自由分区 dba_indexs:关于数据库中所有索引的描述 dba_ind_columns:在所有表及聚集上压缩索引的列 dba_objects:数据库中所有的对象 dba_...
Oracle数据库DBA面试题及答案_经典.docx
01-11
Oracle数据库DBA面试题及答案 以下是根据给定文件信息提炼出的知识点： 1. 冷备份和热备份的不同点： 冷备份是指在数据库关闭后进行备份，适用于所有模式的数据库。热备份是指在数据库仍旧处于工作状态时进行备份...
oracle 数据库常用数据字典梳理.docx
08-14
静态视图的示例包括 dba_data_files、dba_db_links、dba_extents、dba_free_space 等。 动态视图是指从 SGA 和控制文件中获取的信息，用于记录当前数据库的活动情况，包括当前会话、锁、事务、SQL 语句执行情况等。...
ORACLE中段的HEADER_BLOCK示例详析
09-09
当我们查询`DBA_SEGMENTS`视图时，`HEADER_BLOCK`字段表示段的头部块的位置。而在`DBA_EXTENTS`视图中，`BLOCK_ID`字段则代表区的第一个块的位置。通常，`HEADER_BLOCK`并不等于`DBA_EXTENTS`中区的第一个块，这是...
Oracle DBA常用SQL语句
07-02
Oracle DBA在日常工作中会频繁使用SQL语句来管理和监控数据库。以下是一些常见的Oracle DBA SQL命令，它们涵盖了表空间、数据文件、回滚段、控制...通过熟练掌握这些查询，DBA可以更好地确保Oracle数据库的稳定运行。
Oracle DBA常用表
cilici3048的博客
06-20 384
一、DBA常用的表 1.1 dba_开头 dba_users 数据库用户信息 dba_segments 表段信息 dba_extents 数据区信息 dba_objec...
DBA_FREE_SPACE查询慢的原因及解决方法
乡下人
09-15 5397
转自:http://www.cndba.cn/Expect-le/article/261 DBA_FREE_SPACE查询慢的原因及解决方法 MOS文档271169.1 1.当执行查询表空间使用空间，速度非常慢     SELECT D.TABLESPACE_NAME,       SPACE,       (SPACE - NVL (FREE_SPACE, 0)),       
Oracle extents视图,OracleDBA_EXTENTS视图与DBA_SEGMENTS视图
weixin_36437537的博客
04-03 230
DBA_EXTENDS描述的是数据库所有表空间中段的扩展信息。使用DBA_EXTENDS必须保证相应的数据文件处于online状态，否则无法返回任何------------------------------------------------------------------------------------------------------------------------------...
解决数据库慢的方法论
DoubleJing的博客
04-05 2922
数据库慢一般有三种情况： 1.逐渐变慢 2.然变慢 3.不定时变慢 第一种情况 “逐渐变慢”，要建立一个长期的监控机制。比如，写脚本每天的忙时定时收集os,network,database的信息， 每个星期出report,对收集到的信息进行分析。 这些数据的积累，可以决定后期的优化决策，并且可以是DBA说服MANAGER采用自己决策的重要数据。DBA的价值，就在每个星期的report中体现。 第二...
查询视图v$access很慢
weiwang的专栏
09-09 7297
QUERY USING V$ACCESS IS RUNNING SLOW (文档 ID 549895.1)     In this Document   Symptoms   Cause      Bad plan   Solution This document is bein
通过DBA_EXTENTS查看占用空间的表--释放表空间
怀素的专栏
12-07 8423
1.找到数据文件对应的文件号 select file#,name from v$datafile where name like '%LOADTBS.dbf'; 2.找到文件中最大的块号 select max(block_id) from dba_extents where file_id=49; 3.计算一下文件中最大使用块占用的位置 select 39616145*8/1
oracle不能缩小表空间,更改oracle的表空间，特别是缩小时的问题 ORA-03297
weixin_30624767的博客
04-10 682
SQL> ALTER DATABASE DATAFILE'D:\ORACLE\ORADATA\ICAPP\IC_DATA6.ORA' RESIZE 300m;ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\ICAPP\IC_DATA6.ORA'RESIZE 300m*ERROR 位于第 1 行:ORA-03297: 文件包含在请求的 RESIZE 值以外...
oracle中extents存在的理由
01-13 206
extents的特性：1：一个extent由相连的多个blocks组成，多个extents组成一个segment，2：oracle在为segment分配空间时，是以extent为单位因此extents带来的好处：1：空间分配、释...
Oracle 插入大量数据很慢
TX的博客
09-03 5668
一、调整表 二、不要循环插入语句中有获取数据的其他函数 三、不要在循环插入语句中用UUID

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值