|
08.09.2019, 10:47
#39858946
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
Участник
Откуда: Нижний Новгород
Сообщения: 1 928
Рейтинг:
0
/ 0
|
|
|
|
Oracle SQL Developer при входе в БД завис.
Стало интересно, и я зашел Allround PL/SQL девелопером (быстро, как обычно).
И увидел, что Oracle SQL Developer выполняет при входе.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
SELECT object_type, owner, object_name
FROM all_objects
WHERE object_type in ('TABLE',
'VIEW',
'SYNONYM',
'PACKAGE',
'PROCEDURE',
'FUNCTION',
'SEQUENCE')
and object_name not like 'BIN$%'
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
-------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 16746 | 2428170 | 365 | 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID | SUM$ | 1 | 26 | 0 | 00:00:01 |
| * 2 | INDEX UNIQUE SCAN | I_SUM$_1 | 1 | | 0 | 00:00:01 |
| * 3 | VIEW | ALL_OBJECTS | 16746 | 2428170 | 365 | 00:00:01 |
| * 4 | FILTER | | | | | |
| * 5 | HASH JOIN | | 72766 | 11205964 | 364 | 00:00:01 |
| 6 | TABLE ACCESS FULL | USER$ | 122 | 2196 | 4 | 00:00:01 |
| * 7 | HASH JOIN | | 72766 | 9896176 | 359 | 00:00:01 |
| 8 | INDEX FULL SCAN | I_USER2 | 122 | 3050 | 1 | 00:00:01 |
| * 9 | TABLE ACCESS FULL | OBJ$ | 72766 | 8077026 | 357 | 00:00:01 |
| 10 | NESTED LOOPS | | 1 | 31 | 4 | 00:00:01 |
| 11 | NESTED LOOPS | | 1 | 22 | 3 | 00:00:01 |
| 12 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 10 | 2 | 00:00:01 |
| * 13 | INDEX UNIQUE SCAN | I_IND1 | 1 | | 1 | 00:00:01 |
| * 14 | TABLE ACCESS CLUSTER | TAB$ | 1 | 12 | 1 | 00:00:01 |
| * 15 | INDEX RANGE SCAN | I_OBJ1 | 1 | 9 | 1 | 00:00:01 |
| * 16 | TABLE ACCESS CLUSTER | TAB$ | 1 | 12 | 2 | 00:00:01 |
| * 17 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 1 | 00:00:01 |
| * 18 | TABLE ACCESS BY INDEX ROWID | SEQ$ | 1 | 8 | 1 | 00:00:01 |
| * 19 | INDEX UNIQUE SCAN | I_SEQ1 | 1 | | 0 | 00:00:01 |
| * 20 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 8 | 2 | 00:00:01 |
| * 21 | INDEX UNIQUE SCAN | I_IND1 | 1 | | 1 | 00:00:01 |
| 22 | NESTED LOOPS | | 1 | 15 | 2 | 00:00:01 |
| 23 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 24 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| * 25 | HASH JOIN | | 1 | 22 | 3 | 00:00:01 |
| 26 | NESTED LOOPS | | 1 | 19 | 3 | 00:00:01 |
| 27 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 10 | 2 | 00:00:01 |
| * 28 | INDEX UNIQUE SCAN | I_IND1 | 1 | | 1 | 00:00:01 |
| * 29 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 9 | 1 | 00:00:01 |
| 30 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| 31 | NESTED LOOPS | | 1 | 15 | 2 | 00:00:01 |
| 32 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 33 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 34 | NESTED LOOPS | | 1 | 15 | 2 | 00:00:01 |
| 35 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 36 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 37 | NESTED LOOPS | | 1 | 79 | 8 | 00:00:01 |
| 38 | NESTED LOOPS | | 4 | 79 | 8 | 00:00:01 |
| 39 | NESTED LOOPS | | 1 | 69 | 5 | 00:00:01 |
| 40 | NESTED LOOPS | | 1 | 57 | 4 | 00:00:01 |
| 41 | MERGE JOIN CARTESIAN | | 1 | 53 | 3 | 00:00:01 |
| * 42 | INDEX RANGE SCAN | I_OBJ5 | 1 | 50 | 3 | 00:00:01 |
| 43 | BUFFER SORT | | 2 | 6 | 0 | 00:00:01 |
| 44 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 45 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 | 00:00:01 |
| * 46 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| * 47 | INDEX RANGE SCAN | I_DEPENDENCY1 | 4 | | 2 | 00:00:01 |
| * 48 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | 3 | 00:00:01 |
| * 49 | HASH JOIN | | 1 | 25 | 2 | 00:00:01 |
| 50 | NESTED LOOPS | | 1 | 22 | 2 | 00:00:01 |
| 51 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 1 | 10 | 1 | 00:00:01 |
| * 52 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 1 | | 0 | 00:00:01 |
| * 53 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 54 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 55 | HASH JOIN | | 1 | 25 | 2 | 00:00:01 |
| 56 | NESTED LOOPS | | 1 | 22 | 2 | 00:00:01 |
| 57 | TABLE ACCESS BY INDEX ROWID | TABCOMPART$ | 1 | 10 | 1 | 00:00:01 |
| * 58 | INDEX UNIQUE SCAN | I_TABCOMPART$ | 1 | | 0 | 00:00:01 |
| * 59 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 60 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| 61 | NESTED LOOPS | | 1 | 79 | 8 | 00:00:01 |
| 62 | NESTED LOOPS | | 4 | 79 | 8 | 00:00:01 |
| 63 | NESTED LOOPS | | 1 | 69 | 5 | 00:00:01 |
| 64 | NESTED LOOPS | | 1 | 57 | 4 | 00:00:01 |
| 65 | MERGE JOIN CARTESIAN | | 1 | 53 | 3 | 00:00:01 |
| * 66 | INDEX RANGE SCAN | I_OBJ5 | 1 | 50 | 3 | 00:00:01 |
| 67 | BUFFER SORT | | 2 | 6 | 0 | 00:00:01 |
| 68 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 69 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 | 00:00:01 |
| * 70 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| * 71 | INDEX RANGE SCAN | I_DEPENDENCY1 | 4 | | 2 | 00:00:01 |
| * 72 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | 3 | 00:00:01 |
| * 73 | HASH JOIN | | 1 | 29 | 2 | 00:00:01 |
| 74 | NESTED LOOPS | | 1 | 26 | 2 | 00:00:01 |
| * 75 | TABLE ACCESS BY INDEX ROWID | TRIGGER$ | 1 | 14 | 1 | 00:00:01 |
| * 76 | INDEX UNIQUE SCAN | I_TRIGGER2 | 1 | | 0 | 00:00:01 |
| * 77 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 78 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 79 | HASH JOIN | | 1 | 35 | 3 | 00:00:01 |
| 80 | NESTED LOOPS | | 1 | 32 | 3 | 00:00:01 |
| 81 | NESTED LOOPS | | 1 | 20 | 2 | 00:00:01 |
| 82 | TABLE ACCESS BY INDEX ROWID | TABSUBPART$ | 1 | 10 | 1 | 00:00:01 |
| * 83 | INDEX UNIQUE SCAN | I_TABSUBPART$_OBJ$ | 1 | | 0 | 00:00:01 |
| 84 | TABLE ACCESS BY INDEX ROWID | TABCOMPART$ | 1 | 10 | 1 | 00:00:01 |
| * 85 | INDEX UNIQUE SCAN | I_TABCOMPART$ | 1 | | 0 | 00:00:01 |
| * 86 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 87 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| 88 | VIEW | | 1 | 13 | 2 | 00:00:01 |
| 89 | FAST DUAL | | 1 | | 2 | 00:00:01 |
| 90 | NESTED LOOPS | | 1 | 15 | 2 | 00:00:01 |
| 91 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 92 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | 1 | 00:00:01 |
| 93 | NESTED LOOPS | | 1 | 12 | 2 | 00:00:01 |
| 94 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 95 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | 1 | 00:00:01 |
| 96 | SORT GROUP BY NOSORT | | 1 | 35 | 9 | 00:00:01 |
| 97 | NESTED LOOPS | | 1 | 35 | 7 | 00:00:01 |
| 98 | NESTED LOOPS | | 4 | 92 | 3 | 00:00:01 |
| * 99 | INDEX UNIQUE SCAN | I_OLAP_CUBES$ | 1 | 13 | 0 | 00:00:01 |
| 100 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 4 | 40 | 3 | 00:00:01 |
| * 101 | INDEX RANGE SCAN | I_DEPENDENCY1 | 4 | | 2 | 00:00:01 |
| * 102 | INDEX RANGE SCAN | I_OBJ1 | 1 | 12 | 1 | 00:00:01 |
| 103 | NESTED LOOPS | | 1 | 12 | 2 | 00:00:01 |
| 104 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | 0 | 00:00:01 |
| * 105 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | 1 | 00:00:01 |
| * 106 | TABLE ACCESS BY INDEX ROWID BATCHED | USER_EDITIONING$ | 1 | 6 | 2 | 00:00:01 |
| * 107 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | | 1 | 00:00:01 |
| * 108 | TABLE ACCESS BY INDEX ROWID BATCHED | USER_EDITIONING$ | 1 | 6 | 2 | 00:00:01 |
| * 109 | INDEX RANGE SCAN | I_USER_EDITIONING | 2 | | 1 | 00:00:01 |
| 110 | NESTED LOOPS | | 1 | 29 | 2 | 00:00:01 |
| * 111 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | 1 | 00:00:01 |
| * 112 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | 1 | 00:00:01 |
-------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
------------------------------------------
* 2 - access("S"."OBJ#"=:B1)
* 3 - filter("OBJECT_TYPE"='FUNCTION' OR "OBJECT_TYPE"='PACKAGE' OR "OBJECT_TYPE"='PROCEDURE' OR "OBJECT_TYPE"='SEQUENCE' OR "OBJECT_TYPE"='SYNONYM' OR "OBJECT_TYPE"='TABLE' OR "OBJECT_TYPE"='VIEW')
* 4 - filter(("O"."TYPE#"<>1 AND "O"."TYPE#"<>2 AND "O"."TYPE#"<>6 OR "O"."TYPE#"=1 AND NOT EXISTS (SELECT 0 FROM "SYS"."OBJ$" "IO","SYS"."TAB$" "T","SYS"."IND$" "I" WHERE "I"."OBJ#"=:B1 AND
"I"."BO#"="T"."OBJ#" AND BITAND("T"."PROPERTY",36893488147419103232)=36893488147419103232 AND "IO"."OBJ#"="I"."BO#" AND "IO"."TYPE#"=2) OR "O"."TYPE#"=2 AND (SELECT 1 FROM "SYS"."TAB$" "T" WHERE
"T"."OBJ#"=:B2 AND BITAND("T"."PROPERTY",36893488147419103232)=0)=1 OR "O"."TYPE#"=6 AND (SELECT 1 FROM "SYS"."SEQ$" "S" WHERE "S"."OBJ#"=:B3 AND (BITAND("S"."FLAGS",1024)=0 OR "S"."FLAGS" IS
NULL))=1) AND ("O"."TYPE#"<>1 AND "O"."TYPE#"<>10 OR "O"."TYPE#"=1 AND (SELECT 1 FROM "SYS"."IND$" "I" WHERE "I"."OBJ#"=:B4 AND ("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#"=9))=1) AND (("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR ("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5
OR "O"."TYPE#"=6 OR "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=22 OR "O"."TYPE#"=23 OR "O"."TYPE#"=32 OR "O"."TYPE#"=33 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35 OR "O"."TYPE#"=42 OR "O"."TYPE#"=44
OR "O"."TYPE#"=46 OR "O"."TYPE#"=48 OR "O"."TYPE#"=59 OR "O"."TYPE#"=62 OR "O"."TYPE#"=66 OR "O"."TYPE#"=67 OR "O"."TYPE#"=68 OR "O"."TYPE#"=79 OR "O"."TYPE#"=81 OR "O"."TYPE#"=82 OR "O"."TYPE#"=87
OR "O"."TYPE#"=92 OR "O"."TYPE#"=94 OR "O"."TYPE#"=95 OR "O"."TYPE#"=100) AND ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 OR ("O"."TYPE#"=57 OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR
"O"."TYPE#"=74 OR "O"."TYPE#"=101) OR ("O"."TYPE#"=150 OR "O"."TYPE#"=151 OR "O"."TYPE#"=152) AND ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 OR "O"."TYPE#"<>29 AND "O"."TYPE#"<>13 AND
"O"."TYPE#"<>30 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>56 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>28 AND "O"."TYPE#"<>93 AND
EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OBJAUTH$","SYS"."X$KZSRO" "X$KZSRO" WHERE "OBJ#"=:B5 AND "GRANTEE#"="KZSROROL" AND ("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR
"PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18)) OR "O"."TYPE#"=1 AND EXISTS (SELECT 0 FROM "SYS"."IND$" "I","SYS"."OBJAUTH$"
"OA","SYS"."X$KZSRO" "X$KZSRO" WHERE "OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="I"."BO#" AND "I"."OBJ#"=:B6) OR ("O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29
OR "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND (ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 OR EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA","SYS"."X$KZSRO" "X$KZSRO" WHERE "OA"."OBJ#"=:B7 AND
"OA"."GRANTEE#"="KZSROROL" AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))) OR "O"."TYPE#"=13 AND (ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 OR EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
"OA","SYS"."X$KZSRO" "X$KZSRO" WHERE "OA"."OBJ#"=:B8 AND "OA"."GRANTEE#"="KZSROROL" AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))) OR "O"."TYPE#"=11 AND
(ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O"."TYPE#")=1 OR EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA","SYS"."DEPENDENCY$" "DEP","SYS"."USER$" "U","SYS"."OBJ$" "O","SYS"."X$KZSRO" "X$KZSRO" WHERE
"O"."NAME"=:B9 AND "O"."SPARE3"=:B10 AND "O"."TYPE#"=9 AND "O"."OWNER#"="U"."USER#" AND "DEP"."D_OBJ#"=:B11 AND "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND
"OA"."GRANTEE#"="KZSROROL")) OR "O"."TYPE#"=19 AND ( EXISTS (SELECT 0 FROM "SYS"."TABPART$" "TABPART$","SYS"."OBJAUTH$" "OBJAUTH$","SYS"."X$KZSRO" "X$KZSRO" WHERE "GRANTEE#"="KZSROROL" AND
"BO#"="OBJ#" AND ("PRIVILEGE#"=9 OR "PRIVILEGE#"=17) AND "OBJ#"=:B12) OR EXISTS (SELECT 0 FROM "SYS"."TABCOMPART$" "TABCOMPART$","SYS"."OBJAUTH$" "OBJAUTH$","SYS"."X$KZSRO" "X$KZSRO" WHERE
"GRANTEE#"="KZSROROL" AND "BO#"="OBJ#" AND ("PRIVILEGE#"=9 OR "PRIVILEGE#"=17) AND "OBJ#"=:B13)) OR "O"."TYPE#"=14 AND (ORA_CHECK_SYS_PRIVILEGE("O"."SPARE3","O)
* 5 - access("O"."SPARE3"="U"."USER#")
* 7 - access("O"."OWNER#"="U"."USER#")
* 9 - filter("O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_' AND "O"."NAME" NOT LIKE 'BIN$%' AND "O"."LINKNAME" IS NULL AND BITAND("O"."FLAGS",128)=0)
* 13 - access("I"."OBJ#"=:B1)
* 14 - filter("I"."BO#"="T"."OBJ#" AND BITAND("T"."PROPERTY",36893488147419103232)=36893488147419103232)
* 15 - access("IO"."OBJ#"="I"."BO#" AND "IO"."TYPE#"=2)
* 15 - filter("IO"."TYPE#"=2)
* 16 - filter(BITAND("T"."PROPERTY",36893488147419103232)=0)
* 17 - access("T"."OBJ#"=:B1)
* 18 - filter(BITAND("S"."FLAGS",1024)=0 OR "S"."FLAGS" IS NULL)
* 19 - access("S"."OBJ#"=:B1)
* 20 - 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#"=9)
* 21 - access("I"."OBJ#"=:B1)
* 24 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
* 24 - filter("GRANTEE#"="KZSROROL" AND ("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR
"PRIVILEGE#"=17 OR "PRIVILEGE#"=18))
* 25 - access("OA"."GRANTEE#"="KZSROROL")
* 28 - access("I"."OBJ#"=:B1)
* 29 - access("OA"."OBJ#"="I"."BO#")
* 33 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
* 33 - filter("OA"."GRANTEE#"="KZSROROL" AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))
* 36 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
* 36 - filter("OA"."GRANTEE#"="KZSROROL" AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))
* 42 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
* 42 - filter("O"."TYPE#"=9)
* 45 - access("O"."OWNER#"="U"."USER#")
* 46 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
* 46 - filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
* 47 - access("DEP"."D_OBJ#"=:B1)
* 48 - filter("DEP"."P_OBJ#"="O"."OBJ#")
* 49 - access("GRANTEE#"="KZSROROL")
* 52 - access("OBJ#"=:B1)
* 53 - access("BO#"="OBJ#")
* 53 - filter("PRIVILEGE#"=9 OR "PRIVILEGE#"=17)
* 55 - access("GRANTEE#"="KZSROROL")
* 58 - access("OBJ#"=:B1)
* 59 - access("BO#"="OBJ#")
* 59 - filter("PRIVILEGE#"=9 OR "PRIVILEGE#"=17)
* 66 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
* 66 - filter("O"."TYPE#"=13)
* 69 - access("O"."OWNER#"="U"."USER#")
* 70 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
* 70 - filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
* 71 - access("DEP"."D_OBJ#"=:B1)
* 72 - filter("DEP"."P_OBJ#"="O"."OBJ#")
* 73 - access("OA"."GRANTEE#"="KZSROROL")
* 75 - filter(BITAND("T"."PROPERTY",24)=0)
* 76 - access("T"."OBJ#"=:B1)
* 77 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26)
* 77 - filter("OA"."PRIVILEGE#"=26)
* 79 - access("GRANTEE#"="KZSROROL")
* 83 - access("SP"."OBJ#"=:B1)
* 85 - access("SP"."POBJ#"="CP"."OBJ#")
* 86 - access("CP"."BO#"="OBJ#")
* 86 - filter("PRIVILEGE#"=9 OR "PRIVILEGE#"=17)
* 92 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
* 92 - filter("OA"."GRANTEE#"="KZSROROL" AND ("OA"."PRIVILEGE#"=0 OR "OA"."PRIVILEGE#"=29))
* 95 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
* 99 - access("C"."OBJ#"=:B1)
* 101 - access("D"."D_OBJ#"=:B1)
* 102 - access("DO"."OBJ#"="D"."P_OBJ#" AND "DO"."TYPE#"=92)
* 102 - filter("DO"."TYPE#"=92)
* 105 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
* 106 - filter("TYPE#"=:B1)
* 107 - access("UE"."USER#"=:B1)
* 108 - filter("UE"."TYPE#"=:B1)
* 109 - access("UE"."USER#"=:B1)
* 111 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
* 111 - filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
* 112 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 2G
pga_aggregate_target big integer 512M
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 1536M
sga_min_size big integer 0
sga_target big integer 1536M
unified_audit_sga_queue_size integer 1048576
Подождал выполнения 10 минут при 100% загрузке CPU, вынуло 13 тыщ строк.
Проголодался, ушел готовить еду :).
Молодцы, чо. |
|
|
