OS환경 : Oracle Linux7.3(64bit)
DB 환경 : Oracle Database 12.2.0.1
에러 : ORA-29275: partial multibyte character
유저를 삭제하려고 하니 삭제되지 않음
|
1
2
3
4
5
6
|
SYS> drop user jsh cascade;
drop user jsh cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01740: missing double quote in identifier
|
해당 유저 접속 후 테이블 확인
|
1
2
3
4
5
|
SYS> conn jsh/jsh
Connected.
JSH> select * from tab;
ERROR:
ORA-29275: partial multibyte character
|
몇분전 한글 테이블과 영문 테이블을 만들고
캐릭터 셋을 변경해서 안되는듯함
몇분전 실행한것
|
1
2
3
4
5
6
7
8
9
10
|
SQL>CREATE TABLE "월별고객판매집계" (C1 VARCHAR2(10));
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET KO16MSWIN949;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP;
|
여기서 문제는
기존 CHARACTER SET 이 뭐였는지 모른다는것
해결 방법 : 해당 유저 접속 후 영어로된 테이블 모두 삭제(필요한경우 백업필수)
해당 유저 접속 후 영어로된 테이블 모두 삭제(필요한경우 백업필수)
|
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
|
SQL>
select 'drop table '||table_name||' purge;' from user_tables
where table_name like 'A%'
or table_name like 'B%'
or table_name like 'C%'
or table_name like 'D%'
or table_name like 'E%'
or table_name like 'F%'
or table_name like 'G%'
or table_name like 'H%'
or table_name like 'I%'
or table_name like 'J%'
or table_name like 'K%'
or table_name like 'L%'
or table_name like 'M%'
or table_name like 'N%'
or table_name like 'O%'
or table_name like 'P%'
or table_name like 'Q%'
or table_name like 'R%'
or table_name like 'S%'
or table_name like 'T%'
or table_name like 'U%'
or table_name like 'V%'
or table_name like 'W%'
or table_name like 'X%'
or table_name like 'Y%'
or table_name like 'Z%';
'DROPTABLE'||TABLE_NAME||'PURGE;'
--------------------------------------------------------------------------------------------------------------------------------------------------
drop table DEPT purge;
drop table EMP purge;
drop table EMP2 purge;
drop table T purge;
drop table LOOKUPTABLE purge;
해당 sql 실행
SQL> drop table DEPT purge;
SQL> drop table EMP purge;
SQL> drop table EMP2 purge;
SQL> drop table T purge;
SQL> drop table LOOKUPTABLE purge;
jsh 유저 테이블 재 조회
JSH@ORA> select * from tab;
ERROR:
ORA-29275: partial multibyte character
no rows selected
|
.. 음 그대로다.
drop user jsh cascade; 시 10046 트레이스를 해본 결과
drop user jsh cascade; 시 10046 트레이스를 해본 결과
TKPROF: Release 12.2.0.1.0 - Development on Mon Oct 29 15:19:35 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Trace file: ORA_ora_30854.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
The following statement encountered a error during parse:
drop table "JSH"."월별고객별판매집계" cascade constraints purge force
Error encountered: ORA-01740
********************************************************************************
SQL ID: 9babjv8yq8ru3 Plan Hash: 0
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 3
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 0 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS
********************************************************************************
SQL ID: gp8c8mhkvugbc Plan Hash: 0
drop user jsh cascade
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.01 0.03 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.01 0.03 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
********************************************************************************
SQL ID: b1wc53ddd6h3p Plan Hash: 1637390370
select audit$,options
from
procedure$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5 0.00 0.00 0 0 0 0
Execute 5 0.00 0.01 0 0 0 0
Fetch 5 0.00 0.00 0 15 0 5
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15 0.00 0.01 0 15 0 5
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=0 pw=0 time=31 us starts=1 cost=2 size=47 card=1)
1 1 1 INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=0 pw=0 time=17 us starts=1 cost=1 size=0 card=1)(object id 363)
********************************************************************************
SQL ID: 3un99a0zwp4vd Plan Hash: 1475428744
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#,
nvl(property,0),subname,type#,flags,d_attrs
from
dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5 0.00 0.00 0 0 0 0
Execute 5 0.00 0.02 0 0 0 0
Fetch 84 0.00 0.00 0 176 0 79
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 94 0.00 0.02 0 176 0 79
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
6 4 6 SORT ORDER BY (cr=13 pr=0 pw=0 time=212 us starts=1 cost=15 size=690 card=5)
6 4 6 HASH JOIN OUTER (cr=13 pr=0 pw=0 time=184 us starts=1 cost=14 size=690 card=5)
6 4 6 NESTED LOOPS OUTER (cr=13 pr=0 pw=0 time=174 us starts=1 cost=14 size=690 card=5)
6 4 6 STATISTICS COLLECTOR (cr=4 pr=0 pw=0 time=104 us starts=1)
6 4 6 TABLE ACCESS BY INDEX ROWID BATCHED DEPENDENCY$ (cr=4 pr=0 pw=0 time=65 us starts=1 cost=4 size=135 card=5)
6 4 6 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=0 pw=0 time=51 us starts=1 cost=3 size=0 card=5)(object id 85)
6 4 6 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=9 pr=0 pw=0 time=41 us starts=6 cost=2 size=111 card=1)
6 4 6 INDEX RANGE SCAN I_OBJ1 (cr=6 pr=0 pw=0 time=26 us starts=6 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=111 card=1)
********************************************************************************
SQL ID: 0sbbcuruzd66f Plan Hash: 2239883476
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
sample_size, minimum, maximum, distcnt, lowval, hival, density, col#,
spare1, spare2, avgcln, minimum_enc, maximum_enc
from
hist_head$ where obj#=:1 and intcol#=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 107 0.00 0.00 0 0 0 0
Fetch 107 0.00 0.00 0 317 0 103
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 214 0.00 0.00 0 317 0 103
Misses in library cache during parse: 0
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 2sxqgx5hx76qr Plan Hash: 3312420081
select /*+ rule */ bucket, endpoint, col#, epvalue, epvalue_raw,
ep_repeat_count, endpoint_enc
from
histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 47 0.00 0.00 0 0 0 0
Fetch 47 0.00 0.00 0 154 0 703
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 94 0.00 0.00 0 154 0 703
Misses in library cache during parse: 0
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 4)
********************************************************************************
SQL ID: 8swypbbr0m372 Plan Hash: 570326988
select order#,columns,types
from
access$ where d_obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5 0.00 0.00 0 0 0 0
Execute 5 0.00 0.00 0 0 0 0
Fetch 86 0.00 0.00 0 172 0 81
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 96 0.00 0.00 0 172 0 81
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
5 3 5 TABLE ACCESS BY INDEX ROWID BATCHED ACCESS$ (cr=7 pr=0 pw=0 time=37 us starts=1 cost=3 size=161 card=7)
5 3 5 INDEX RANGE SCAN I_ACCESS1 (cr=5 pr=0 pw=0 time=27 us starts=1 cost=2 size=0 card=7)(object id 87)
********************************************************************************
SQL ID: 3k0c6241uw582 Plan Hash: 1964643588
select actionsize
from
trigger$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 6 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 0 6 0 3
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=26 us starts=1 cost=1 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=16 us starts=1 cost=0 size=0 card=1)(object id 270)
********************************************************************************
SQL ID: 04kug40zbu4dm Plan Hash: 4006480256
select policy#, action#
from
aud_object_opt$ where object# = :1 and type = 2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 17 0.00 0.00 0 0 0 0
Fetch 17 0.00 0.00 0 153 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 34 0.00 0.00 0 153 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: 121ffmrc95v7g Plan Hash: 2542797530
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,
i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,
i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,
nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),
i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),
nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,
null,mod(trunc(i.pctthres$/256),256)),nvl(i.evaledition#,1),
nvl(i.unusablebefore#,0),nvl(i.unusablebeginning#,0), ist.cachedblk,
ist.cachehit,ist.logicalread
from
ind$ i, ind_stats$ ist, (select enabled, min(intcols) unicols,
min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4)))
valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where
i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 33 0.00 0.00 0 82 0 21
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 45 0.00 0.00 0 82 0 21
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: 5n1fs4m2n2y0r Plan Hash: 452367486
select pos#,intcol#,col#,spare1,bo#,spare2,spare3
from
icol$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 21 0.00 0.00 0 0 0 0
Fetch 61 0.00 0.00 0 122 0 40
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 82 0.00 0.00 0 122 0 40
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: 9t4vxdppkv534 Plan Hash: 3765558045
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,
nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,
scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,
rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,
nvl(spare3,0), nvl(evaledition#,1),nvl(unusablebefore#,0),
nvl(unusablebeginning#,0), case when (type# in (1,8,9,96,112)) then
nvl(collid, 16382) else 0 end case, nvl(collintcol#,0), nvl(acdrrescol#, 0),
nvl(spare7, 0)
from
col$ where obj#=:1 order by intcol#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 14 0.00 0.00 0 0 0 0
Fetch 198 0.00 0.00 0 46 0 184
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 212 0.00 0.00 0 46 0 184
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: 07pcqtmt58zv9 Plan Hash: 1964643588
select action#
from
trigger$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 9 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 0 9 0 3
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=16 us starts=1 cost=1 size=8 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=9 us starts=1 cost=0 size=0 card=1)(object id 270)
********************************************************************************
SQL ID: 7akvnu9t168d3 Plan Hash: 1964643588
select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,
whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,
refprtname,rowid,actionlineno,trignameline,trignamecol, trignamecolofs,
actioncolno
from
trigger$ where obj# =:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 6 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 0 6 0 3
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=15 us starts=1 cost=1 size=150 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=9 us starts=1 cost=0 size=0 card=1)(object id 270)
********************************************************************************
SQL ID: 5wxyshspv54v4 Plan Hash: 1996182059
select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,
c.precision#,c.charsetid,c.charsetform, decode(bitand(c.property,8388608),
8388608, c.spare3, 0)
from
triggercol$ tc,col$ c, trigger$ tr where tc.obj#=:1 and tc.intcol#=c.intcol#
and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#,
20) = 20) and ( c.obj#=:2 and (bitand(tc.type#, 1024) = :3 or tc.type# =
0) or c.obj#=:4 and bitand(tc.type#, 1024) = :5 or c.obj#=:6 and
tc.type# = 0 and tc.position# = 0) union select type#,intcol#,position#,69,
0,0,0,0,0,0 from triggercol$ where obj#=:7 and intcol#=1001 union select
tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0,0 from triggercol$ tc,
trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and
tc.obj# = :8 and bitand(tc.type#,20) != 20
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.01 0.02 0 0 0 0
Fetch 3 0.00 0.00 0 48 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.02 0.02 0 48 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT UNIQUE (cr=16 pr=0 pw=0 time=103 us starts=1 cost=16 size=297 card=9)
0 0 0 UNION-ALL (cr=16 pr=0 pw=0 time=87 us starts=1)
0 0 0 CONCATENATION (cr=12 pr=0 pw=0 time=70 us starts=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=45 us starts=1 cost=3 size=56 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=43 us starts=1 cost=3 size=56 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=43 us starts=1 cost=2 size=23 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=24 us starts=1 cost=1 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=12 us starts=1 cost=0 size=0 card=1)(object id 270)
0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=16 us starts=1 cost=1 size=14 card=1)(object id 272)
0 0 0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 50)
0 0 0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=33 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=11 us starts=1 cost=3 size=56 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=10 us starts=1 cost=3 size=56 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=9 us starts=1 cost=2 size=23 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=4 us starts=1 cost=1 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=0 card=1)(object id 270)
0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=1 size=14 card=1)(object id 272)
0 0 0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 50)
0 0 0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=33 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=9 us starts=1 cost=3 size=56 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=8 us starts=1 cost=2 size=23 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=3 us starts=1 cost=1 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=0 card=1)(object id 270)
0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=3 us starts=1 cost=1 size=14 card=1)(object id 272)
0 0 0 TABLE ACCESS CLUSTER COL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=33 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 3)
0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=4 us starts=1 cost=2 size=14 card=1)(object id 272)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=9 us starts=1 cost=2 size=115 card=5)
0 0 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=9 card=1)
1 1 1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=0 card=1)(object id 270)
0 0 0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=70 card=5)(object id 272)
********************************************************************************
SQL ID: 4zzxr8rvht74z Plan Hash: 3368685730
select case when (bitand(u.spare1, 16) = 0) then 0 when
(u.type# = 2) then (u.spare2) else 1 end
from
obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 9 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 0 9 0 3
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 HASH JOIN (cr=3 pr=0 pw=0 time=49 us starts=1 cost=3 size=32 card=1)
1 1 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=41 us starts=1 cost=3 size=32 card=1)
1 1 1 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=32 us starts=1)
1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=24 us starts=1 cost=2 size=8 card=1)(object id 36)
1 1 1 INDEX RANGE SCAN I_USER2 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=1 size=24 card=1)(object id 47)
0 0 0 INDEX FULL SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=1)(object id 47)
********************************************************************************
SQL ID: ct6c4h224pxgz Plan Hash: 0
BEGIN
BEGIN
IF (sys.is_vpd_enabled(sys.dictionary_obj_owner,
sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner,
sys.dictionary_obj_name);
ELSIF
(sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name,
xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner,
sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 86kwhy1f0bttn Plan Hash: 3410375810
SELECT /*+ ALL_ROWS */ COUNT(*)
FROM
DBA_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND
(V.POLICY_NAME LIKE '%xdbrls%' OR V.POLICY_NAME LIKE '%$xd_%') AND
V.FUNCTION = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.03 0.03 0 0 0 0
Fetch 2 0.00 0.00 0 0 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.03 0.03 0 0 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=0 pr=0 pw=0 time=76 us starts=1)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=66 us starts=1)
0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=65 us starts=1 cost=5 size=243 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=50 us starts=1 cost=5 size=243 card=1)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=49 us starts=1)
0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=38 us starts=1 cost=4 size=219 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=33 us starts=1 cost=4 size=219 card=1)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=30 us starts=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=11 us starts=1 cost=3 size=163 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=9 us starts=1 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=6 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 TABLE ACCESS FULL RLS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=145 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=56 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=56 card=1)
0 0 0 INDEX SKIP SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 37)
0 0 0 INDEX RANGE SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=1)(object id 47)
0 0 0 INDEX FULL SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=1)(object id 47)
0 0 0 TABLE ACCESS FULL USER_EDITIONING$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=6 card=1)
0 0 0 TABLE ACCESS FULL USER_EDITIONING$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=6 card=1)
0 0 0 NESTED LOOPS SEMI (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=29 card=1)
0 0 0 INDEX SKIP SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=20 card=1)(object id 47)
0 0 0 INDEX RANGE SCAN I_OBJ4 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=9 card=1)(object id 39)
********************************************************************************
SQL ID: acmvv4fhdc9zh Plan Hash: 813480514
select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1,
spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382),
creappid, creverid, modappid, modverid, crepatchid, modpatchid
from
obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null
and linkname is null and subname is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 0 23 0 5
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12 0.00 0.00 0 23 0 5
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3755742892
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,
NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),
NVL(scanhint,0),NVL(bitmapranges,0)
from
seg$ where ts#=:1 and file#=:2 and block#=:3
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 0 12 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.00 0.00 0 12 0 4
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 87gaftwrm2h68 Plan Hash: 1072382624
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname
from
obj$ o where o.obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 16 0.00 0.00 0 0 0 0
Fetch 16 0.00 0.00 0 35 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 32 0.00 0.00 0 35 0 3
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: grwydz59pu6mc Plan Hash: 3684871272
select text
from
view$ where rowid=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 4 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 0 8 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12 0.00 0.00 0 8 0 4
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=18 us starts=1 cost=1 size=15 card=1)
********************************************************************************
SQL ID: cn6hhn36a4rrs Plan Hash: 3845132125
select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3,refact
from
cdef$ where robj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 0 4 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.00 0.00 0 4 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: gx4mv66pvj3xz Plan Hash: 2570921597
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),
rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3
from
cdef$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 14 0.00 0.00 0 20 0 10
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 18 0.00 0.00 0 20 0 10
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 53saa2zkr6wc3 Plan Hash: 3038981986
select intcol#,nvl(pos#,0),col#,nvl(spare1,0)
from
ccol$ where con#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 10 0.00 0.00 0 0 0 0
Fetch 20 0.00 0.00 0 40 0 10
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 30 0.00 0.00 0 40 0 10
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
declare
TYPE attrs_cur IS REF CURSOR;
m_cur attrs_cur;
m_event varchar2(512);
m_user varchar2(512);
m_owner varchar2(512);
m_type varchar2(512);
m_name varchar2(5120);
m_column varchar2(5120);
m_cnt NUMBER;
m_adt NUMBER;
m_stmt varchar2(4000);
m_stmt1 varchar2(4000);
m_var varchar2(512);
m_o_stmt VARCHAR2(5120);
PRAGMA AUTONOMOUS_TRANSACTION;
begin
m_stmt := 'select mdsys.GetMdsysEvent() from dual';
execute immediate m_stmt into m_cnt;
if ( m_cnt != 0 ) then
return;
end if;
m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual';
execute immediate m_stmt into m_type;
if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE'))
then
return;
end if;
m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual';
execute immediate m_stmt into m_owner;
m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual';
execute immediate m_stmt into m_name;
m_stmt:='select sys.dbms_standard.sysevent from dual';
execute immediate m_stmt into m_event;
if ( m_type = 'TABLE' and m_event != 'DROP' and m_event != 'RENAME' ) then
m_stmt := 'select mdsys.TblContainsAdt(:own, :tab) from dual';
begin
execute immediate m_stmt into m_adt using m_owner, m_name;
exception when others then
m_adt := 1;
end;
if ( m_adt = 0 ) then
return;
end if;
end if;
m_stmt:='select SYS_CONTEXT(''USERENV'',''SESSION_USER'') from dual';
execute immediate m_stmt into m_user;
if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER')
then
m_stmt:='select column_name from dba_tab_columns where owner=:1 and table_name=:2';
begin
open m_cur for m_stmt using m_owner,m_name;
loop
fetch m_cur into m_column;
exit when m_cur%NOTFOUND;
m_stmt:='select sdo_geor_def.isDropColumn(:1) from dual';
execute immediate m_stmt into m_stmt1 using m_column;
if (trim(m_stmt1)='TRUE')
then
m_stmt:='begin sdo_geor_def.doAlterDropColumn(:1,:2,:3); end;';
execute immediate m_stmt using m_owner,m_name,m_column;
end if;
end loop;
close m_cur;
EXCEPTION WHEN OTHERS THEN
IF m_cur%ISOPEN THEN
close m_cur;
END IF;
RAISE;
end;
end if;
if ((m_event='DROP' and m_type='USER') or (m_event='DROP' and m_type='TABLESPACE'))
then
m_stmt:='insert into sdo_geor_ddl__table$$ values (1)';
EXECUTE IMMEDIATE m_stmt;
commit;
end if;
if (m_event='DROP' and m_type='TABLE')
then
if((m_user!='SYS' and m_user!='SYSTEM' and m_user!='MDSYS'and m_owner!='MDSYS' and m_owner!='SYS'))
then
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2 and ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner,m_name;
if(m_cnt!=0)
then
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_ddl__table$$ where ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt;
if(m_cnt=0)
then
m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be dropped.'')';
execute immediate m_stmt;
end if;
end if;
end if;
m_stmt:='insert into sdo_geor_ddl__table$$ values (2)';
EXECUTE IMMEDIATE m_stmt;
commit;
end if;
if(m_user='SYS' or m_user='SYSTEM' or m_user='MDSYS'
or m_owner='MDSYS' or m_owner='SYS')
then
return;
end if;
if (m_event='RENAME' and m_type='TABLE')
then
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2 and ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner,m_name;
if(m_cnt!=0)
then
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_ddl__table$$ where ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt;
if(m_cnt=0)
then
m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be renamed directly.'')';
execute immediate m_stmt;
end if;
end if;
end if;
if (m_type='TRIGGER' and m_event='DROP')
then
m_stmt:='select REGEXP_SUBSTR(:1,''GRDMLTR_.+'',1,1,''i'') from dual';
EXECUTE IMMEDIATE m_stmt into m_var using m_name;
if(m_var is null)
then
return;
end if;
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_ddl__table$$ where ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt;
if(m_cnt=0)
then
m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be dropped.'')';
execute immediate m_stmt;
end if;
end if;
if (m_type='TRIGGER' and m_event='ALTER')
then
m_stmt:='select sdo_geor_def.getSqlText from dual';
execute immediate m_stmt into m_o_stmt;
m_o_stmt:=nls_upper(trim(m_o_stmt));
if(instr(m_o_stmt,' COMPILE ')>0 or instr(m_o_stmt,' ENABLE ')>0
or substr(m_o_stmt,length(m_o_stmt)-8,8)=' COMPILE' or substr(m_o_stmt,length(m_o_stmt)-7,7)=' ENABLE' )
then
return;
end if;
m_stmt:='select REGEXP_SUBSTR(:1,''GRDMLTR_.+'',1,1,''i'') from dual';
EXECUTE IMMEDIATE m_stmt into m_var using m_name;
if(m_var is null)
then
return;
end if;
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_ddl__table$$ where ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt;
if(m_cnt=0)
then
m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be altered.'')';
execute immediate m_stmt;
end if;
end if;
if (m_type='TRIGGER' and m_event='CREATE')
then
m_stmt:='select REGEXP_SUBSTR(:1,''GRDMLTR_.+'',1,1,''i'') from dual';
EXECUTE IMMEDIATE m_stmt into m_var using m_name;
if(m_var is null)
then
return;
end if;
m_stmt:='select /*+ FIRST_ROWS(1) */ count(*) from sdo_geor_ddl__table$$ where ROWNUM < 2';
EXECUTE IMMEDIATE m_stmt into m_cnt;
if(m_cnt=0)
then
m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster reserved names cannot be used to create regular triggers.'')';
execute immediate m_stmt;
end if;
end if;
Exception
when others then
if(sqlcode=-13391)
then
m_stmt:=sqlerrm;
m_stmt:=substr(m_stmt,11);
m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391,'''||m_stmt||''')';
execute immediate m_stmt;
end if;
end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 1)
********************************************************************************
SQL ID: fh5ufah919kun Plan Hash: 1697022209
select /*+ index(idl_sb4$ i_idl_sb41) */ piece#,length,piece
from
idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 7 0.00 0.00 0 0 0 0
Execute 7 0.00 0.00 0 0 0 0
Fetch 17 0.00 0.00 0 44 0 10
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 31 0.00 0.00 0 44 0 10
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=5 pr=0 pw=0 time=36 us starts=1 cost=3 size=19 card=1)
2 2 2 INDEX RANGE SCAN I_IDL_SB41 (cr=4 pr=0 pw=0 time=27 us starts=1 cost=2 size=0 card=1)(object id 371)
********************************************************************************
SQL ID: 03guhbfpak0w7 Plan Hash: 3246118364
select /*+ index(idl_ub1$ i_idl_ub11) */ piece#,length,piece
from
idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 7 0.00 0.00 0 0 0 0
Execute 7 0.00 0.00 0 0 0 0
Fetch 20 0.00 0.00 0 70 0 17
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 34 0.00 0.00 0 70 0 17
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 2 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=4 pr=0 pw=0 time=26 us starts=1 cost=3 size=18 card=1)
1 1 2 INDEX RANGE SCAN I_IDL_UB11 (cr=3 pr=0 pw=0 time=21 us starts=1 cost=2 size=0 card=1)(object id 368)
********************************************************************************
SQL ID: 9tt2m0mpc2qqp Plan Hash: 1319326155
select /*+ index(idl_char$ i_idl_char1) */ piece#,length,piece
from
idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 7 0.00 0.00 0 0 0 0
Execute 7 0.00 0.00 0 0 0 0
Fetch 10 0.00 0.00 0 24 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 0.00 0.00 0 24 0 3
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=3 pr=0 pw=0 time=28 us starts=1 cost=3 size=21 card=1)
1 1 1 INDEX RANGE SCAN I_IDL_CHAR1 (cr=3 pr=0 pw=0 time=22 us starts=1 cost=2 size=0 card=1)(object id 369)
********************************************************************************
SQL ID: a3jpjzh7mtwwp Plan Hash: 2317816222
select /*+ index(idl_ub2$ i_idl_ub21) */ piece#,length,piece
from
idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 7 0.00 0.00 0 0 0 0
Execute 7 0.00 0.00 0 0 0 0
Fetch 13 0.00 0.00 0 42 0 9
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 27 0.00 0.00 0 42 0 9
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 5 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=6 pr=0 pw=0 time=32 us starts=1 cost=3 size=42 card=2)
2 2 5 INDEX RANGE SCAN I_IDL_UB21 (cr=4 pr=0 pw=0 time=31 us starts=1 cost=2 size=0 card=2)(object id 370)
********************************************************************************
SQL ID: dgqztvysuhmgy Plan Hash: 1388734953
select mdsys.GetMdsysEvent()
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=8 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: bcv9qynmu1nv9 Plan Hash: 1388734953
select sys.dbms_standard.dictionary_obj_type
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: ar9nmtmd28460 Plan Hash: 1388734953
select sys.dbms_standard.dictionary_obj_owner
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: 4a3ccstvk0ssw Plan Hash: 1388734953
select sys.dbms_standard.dictionary_obj_name
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: 12kw3xcxv1qpg Plan Hash: 1388734953
select sys.dbms_standard.sysevent
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: d7y4tdacc7f3j Plan Hash: 1388734953
select SYS_CONTEXT('USERENV','SESSION_USER')
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: 622ufbrgvxdc7 Plan Hash: 381121033
select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$,
t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192),
8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0),
decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name
from
obj$ o where o.obj# = u.spare2 and o.type# =57),
decode(bitand(t.property, 524288), 524288, 1, 0) from sys.obj$ o,
sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and
bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj#
and o.owner#=u.user# and o.type# = 12 and bitand(property,16)=0 and
bitand(property,8)=0 order by o.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 4 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 4 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=44 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=0 card=1)(object id 36)
0 0 0 SORT ORDER BY (cr=4 pr=0 pw=0 time=151 us starts=1 cost=11 size=269 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=134 us starts=1 cost=7 size=269 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=131 us starts=1 cost=6 size=120 card=1)
0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=131 us starts=1 cost=4 size=73 card=1)
1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=0 pw=0 time=118 us starts=1 cost=3 size=47 card=1)(object id 40)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED TRIGGER$ (cr=1 pr=0 pw=0 time=9 us starts=1 cost=1 size=52 card=2)
0 0 0 INDEX RANGE SCAN I_TRIGGER1 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=2)(object id 269)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=47 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=149 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 11)
********************************************************************************
SQL ID: 6h3cwmunz5z8q Plan Hash: 2968095032
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)),
max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16),
max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128)
from
objauth$ where obj#=:1 and col# is not null group by privilege#, col#,
grantee# order by col#, grantee#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT GROUP BY (cr=2 pr=0 pw=0 time=62 us starts=1 cost=4 size=16 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 time=38 us starts=1 cost=3 size=16 card=1)
0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=36 us starts=1 cost=2 size=0 card=1)(object id 62)
********************************************************************************
SQL ID: a4n4ayr88dbhy Plan Hash: 2968095032
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),
max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16),
max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128)
from
objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by
grantee#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT GROUP BY (cr=2 pr=0 pw=0 time=56 us starts=1 cost=4 size=16 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 time=30 us starts=1 cost=3 size=16 card=1)
0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=26 us starts=1 cost=2 size=0 card=1)(object id 62)
********************************************************************************
SQL ID: d7zvk9bn8dyr6 Plan Hash: 3646447030
select /* QOSD */ /*+ index(do) */ dir_cnt
from
opt_directive_own$ do where dir_own# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 5 0.00 0.00 0 0 0 0
Fetch 5 0.00 0.00 0 5 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 10 0.00 0.00 0 5 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 4nrusbrr521bm Plan Hash: 0
insert into sdo_geor_ddl__table$$
values
(1)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 3 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 1 3 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 90 (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL SDO_GEOR_DDL__TABLE$$ (cr=1 pr=0 pw=0 time=214 us starts=1)
********************************************************************************
SQL ID: 8ggw94h7mvxd7 Plan Hash: 0
COMMIT
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 1 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 1 0
Misses in library cache during parse: 0
Parsing user id: 90 (recursive depth: 2)
********************************************************************************
SQL ID: 8v4apsucza8wv Plan Hash: 0
begin dbms_streams_adm_utl.process_drop_user_cascade(:1); end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.01 0.01 0 48 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.01 0.01 0 48 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 7hj57uz99sm9k Plan Hash: 4141019660
select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,
maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),
nvl(flags,0),nvl(spare1,0), nvl(spare2,0)
from
clu$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 4 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 4 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS CLUSTER CLU$ (cr=4 pr=0 pw=0 time=22 us starts=1 cost=2 size=45 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=11 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: 5u7g54s63p4ts Plan Hash: 4285252131
select toid
from
type$ where package_obj#=:1 and typ_name=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 0 77 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 18 0.00 0.00 0 77 0 6
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 INDEX FAST FULL SCAN I_TYPE6 (cr=14 pr=0 pw=0 time=106 us starts=1 cost=12 size=25 card=1)(object id 730)
********************************************************************************
SQL ID: 9zbjgq87hy6uv Plan Hash: 2035254952
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,
nvl(t.clucols,0),t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,
t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,
t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),
t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),
nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread,
ts.im_imcu_count,ts.im_block_count,ts.im_sys_incarnation,
ts.im_stat_update_time,ts.scanrate,nvl(t.acdrflags, 0),nvl(t.acdrtsobj#, 0),
t.acdrdefaulttime, nvl(t.acdrrowtsintcol#, 0)
from
tab$ t,tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 10 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 10 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 MERGE JOIN OUTER (cr=5 pr=0 pw=0 time=47 us starts=1 cost=2 size=178 card=1)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=28 us starts=1 cost=2 size=138 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=11 us starts=1 cost=1 size=0 card=1)(object id 3)
0 0 0 BUFFER SORT (cr=2 pr=0 pw=0 time=14 us starts=1 cost=0 size=40 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=2 pr=0 pw=0 time=8 us starts=1 cost=0 size=40 card=1)
0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 time=5 us starts=1 cost=0 size=0 card=1)(object id 74)
********************************************************************************
SQL ID: gd28w82ct6rva Plan Hash: 2970138452
select audit$
from
tab$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=15 us starts=1 cost=2 size=44 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: gngtvs38t0060 Plan Hash: 3679945446
SELECT /*+ CONNECT_BY_FILTERING */ s.privilege#
FROM
sys.sysauth$ s CONNECT BY s.grantee# = PRIOR s.privilege#
AND (s.privilege# > 0 OR s.privilege# = -352)
START WITH (s.privilege# > 0 OR s.privilege# = -352) AND
s.grantee# IN (SELECT c1.privilege# FROM sys.codeauth$ c1 WHERE c1.obj#
= :1) UNION
SELECT c2.privilege# FROM sys.codeauth$ c2 WHERE c2.obj# =
:2 ORDER BY 1 ASC
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 4 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.01 0.00 0 4 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 2
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT UNIQUE (cr=2 pr=0 pw=0 time=76 us starts=1 cost=10 size=294 card=12)
0 0 0 UNION-ALL (cr=2 pr=0 pw=0 time=68 us starts=1)
0 0 0 CONNECT BY WITH FILTERING (UNIQUE) (cr=1 pr=0 pw=0 time=59 us starts=1)
0 0 0 HASH JOIN (cr=1 pr=0 pw=0 time=44 us starts=1 cost=2 size=48 card=3)
0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=37 us starts=1 cost=2 size=48 card=3)
0 0 0 STATISTICS COLLECTOR (cr=1 pr=0 pw=0 time=34 us starts=1)
0 0 0 INDEX RANGE SCAN I_CODEAUTH1 (cr=1 pr=0 pw=0 time=28 us starts=1 cost=1 size=8 card=1)(object id 507)
0 0 0 INDEX RANGE SCAN I_SYSAUTH1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=3)(object id 147)
0 0 0 INDEX FAST FULL SCAN I_SYSAUTH1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=3)(object id 147)
0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us starts=0 cost=5 size=168 card=8)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=5 size=168 card=8)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 CONNECT BY PUMP (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX RANGE SCAN I_SYSAUTH1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=3)(object id 147)
0 0 0 INDEX FAST FULL SCAN I_SYSAUTH1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=24 card=3)(object id 147)
0 0 0 INDEX RANGE SCAN I_CODEAUTH1 (cr=1 pr=0 pw=0 time=4 us starts=1 cost=1 size=8 card=1)(object id 507)
********************************************************************************
SQL ID: 9u90vxb14fa37 Plan Hash: 1457651150
SELECT U.USER#
FROM
USER$ U WHERE U.NAME = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=19 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=11 us starts=1 cost=0 size=0 card=1)(object id 46)
********************************************************************************
SQL ID: 153zn10knzfua Plan Hash: 1063056891
SELECT CAPTURE_NAME, STATUS, DECODE(FLAGS, 512, 'YES', 'NO') IS_SYNC_CAP
FROM
SYS.STREAMS$_CAPTURE_PROCESS WHERE CAPTURE_USERID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS FULL STREAMS$_CAPTURE_PROCESS (cr=3 pr=0 pw=0 time=51 us starts=1 cost=2 size=105 card=1)
********************************************************************************
SQL ID: 50zdt73ajz2r0 Plan Hash: 3526036174
SELECT APPLY_NAME, STATUS
FROM
SYS.STREAMS$_APPLY_PROCESS WHERE APPLY_USERID = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS FULL STREAMS$_APPLY_PROCESS (cr=3 pr=0 pw=0 time=29 us starts=1 cost=2 size=92 card=1)
********************************************************************************
SQL ID: 5c4wgqz4sbbat Plan Hash: 1969080267
SELECT PRIVILEGE_TYPE, PRIVILEGE_LEVEL
FROM
SYS.GOLDENGATE$_PRIVILEGES WHERE USERNAME = :B1 FOR UPDATE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 FOR UPDATE (cr=1 pr=0 pw=0 time=23 us starts=1)
0 0 0 BUFFER SORT (cr=1 pr=0 pw=0 time=20 us starts=1)
0 0 0 INDEX RANGE SCAN GOLDENGATE$_PRIVILEGES_I (cr=1 pr=0 pw=0 time=14 us starts=1 cost=0 size=92 card=1)(object id 1142)
********************************************************************************
SQL ID: c5a301cq1m9nq Plan Hash: 1699151739
SELECT PRIVILEGE_TYPE, PRIVILEGE_LEVEL
FROM
SYS.XSTREAM$_PRIVILEGES WHERE USERNAME = :B1 FOR UPDATE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 FOR UPDATE (cr=1 pr=0 pw=0 time=20 us starts=1)
0 0 0 BUFFER SORT (cr=1 pr=0 pw=0 time=17 us starts=1)
0 0 0 INDEX RANGE SCAN I_XSTREAM_PRIVILEGES (cr=1 pr=0 pw=0 time=11 us starts=1 cost=0 size=92 card=1)(object id 1144)
********************************************************************************
SQL ID: dhnv5y3mz1sja Plan Hash: 628481501
select obj#
from
RecycleBin$ where owner#=:1 and to_number(bitand(flags, 4)) = 4
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED RECYCLEBIN$ (cr=1 pr=0 pw=0 time=37 us starts=1 cost=1 size=39 card=1)
0 0 0 INDEX RANGE SCAN RECYCLEBIN$_OWNER (cr=1 pr=0 pw=0 time=35 us starts=1 cost=1 size=0 card=1)(object id 252)
********************************************************************************
SQL ID: 42qtt12gqxq4p Plan Hash: 628481501
select obj#, type#, flags, related, bo, purgeobj, con#
from
RecycleBin$ where owner#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED RECYCLEBIN$ (cr=1 pr=0 pw=0 time=14 us starts=1 cost=1 size=104 card=1)
0 0 0 INDEX RANGE SCAN RECYCLEBIN$_OWNER (cr=1 pr=0 pw=0 time=12 us starts=1 cost=1 size=0 card=1)(object id 252)
********************************************************************************
SQL ID: 065x8dx4gnc4t Plan Hash: 1149692100
select u.name, o2.name, o2.obj#
from
ind$ i, obj$ o1, obj$ o2, user$ u where o1.owner# = :1 and o1.type# = 2 and
i.type# = 9 and i.bo# = o1.obj# and i.obj# = o2.obj# and o2.owner# =
u.user# and i.type# = 9 and o1.owner# != o2.owner#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 6 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 6 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=6 pr=0 pw=0 time=909 us starts=1 cost=42 size=86 card=1)
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=902 us starts=1 cost=42 size=86 card=1)
0 0 0 STATISTICS COLLECTOR (cr=6 pr=0 pw=0 time=901 us starts=1)
0 0 0 HASH JOIN (cr=6 pr=0 pw=0 time=894 us starts=1 cost=41 size=68 card=1)
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=890 us starts=1 cost=41 size=68 card=1)
0 0 0 STATISTICS COLLECTOR (cr=6 pr=0 pw=0 time=890 us starts=1)
0 0 0 HASH JOIN (cr=6 pr=0 pw=0 time=883 us starts=1 cost=39 size=25 card=1)
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=877 us starts=1 cost=39 size=25 card=1)
1 1 1 STATISTICS COLLECTOR (cr=3 pr=0 pw=0 time=850 us starts=1)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=39 us starts=1 cost=37 size=1008 card=84)(object id 37)
0 0 0 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=25 us starts=1 cost=1 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=8 us starts=1 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS FULL IND$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=13 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=43 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 11)
0 0 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
********************************************************************************
SQL ID: 83c1surm0xhcg Plan Hash: 4167171786
select u.name, o.name, o.obj#
from
obj$ o, user$ u, ind$ i where o.owner#=:1 and o.owner#=u.user# and o.obj#=
i.obj# and i.type#=9
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 11 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 11 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=11 pr=0 pw=0 time=222 us starts=1 cost=148 size=69 card=1)
0 0 0 NESTED LOOPS (cr=11 pr=0 pw=0 time=218 us starts=1 cost=148 size=69 card=1)
0 0 0 NESTED LOOPS (cr=11 pr=0 pw=0 time=215 us starts=1 cost=148 size=69 card=2807)
4 4 4 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=192 us starts=1)
4 4 4 MERGE JOIN CARTESIAN (cr=5 pr=0 pw=0 time=185 us starts=1 cost=37 size=171227 card=2807)
1 1 1 TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=149 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=131 us starts=1 cost=0 size=0 card=1)(object id 11)
4 4 4 BUFFER SORT (cr=3 pr=0 pw=0 time=34 us starts=1 cost=36 size=120701 card=2807)
4 4 4 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=15 us starts=1 cost=36 size=120701 card=2807)(object id 37)
0 0 0 INDEX UNIQUE SCAN I_IND1 (cr=6 pr=0 pw=0 time=13 us starts=4 cost=0 size=0 card=1)(object id 41)
0 0 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=8 card=1)
0 0 0 TABLE ACCESS FULL IND$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=8 card=1)
********************************************************************************
SQL ID: 88mpkctz6n2tn Plan Hash: 0
begin sys.dbms_cdc_utility.drop_user(:1); end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 4cnzhrcy1vmmn Plan Hash: 0
begin sys.dbms_parallel_execute_internal.drop_all_tasks(:1); end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 8jjwsj7410gbd Plan Hash: 1901476396
SELECT USER_ID
FROM
DBA_USERS WHERE USERNAME = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.03 0.03 0 0 0 0
Fetch 1 0.00 0.00 0 21 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.03 0.03 0 21 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=21 pr=0 pw=0 time=557 us starts=1 cost=12 size=196 card=2)
1 1 1 MERGE JOIN CARTESIAN (cr=18 pr=0 pw=0 time=520 us starts=1 cost=10 size=95 card=1)
1 1 1 HASH JOIN (cr=16 pr=0 pw=0 time=479 us starts=1 cost=9 size=86 card=1)
1 1 1 HASH JOIN (cr=13 pr=0 pw=0 time=227 us starts=1 cost=7 size=83 card=1)
1 1 1 NESTED LOOPS (cr=13 pr=0 pw=0 time=221 us starts=1 cost=7 size=83 card=1)
1 1 1 STATISTICS COLLECTOR (cr=11 pr=0 pw=0 time=214 us starts=1)
1 1 1 HASH JOIN (cr=11 pr=0 pw=0 time=202 us starts=1 cost=6 size=80 card=1)
1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=197 us starts=1 cost=6 size=80 card=1)
1 1 1 STATISTICS COLLECTOR (cr=9 pr=0 pw=0 time=189 us starts=1)
1 1 1 HASH JOIN OUTER (cr=9 pr=0 pw=0 time=179 us starts=1 cost=5 size=77 card=1)
1 1 1 NESTED LOOPS OUTER (cr=9 pr=0 pw=0 time=175 us starts=1 cost=5 size=77 card=1)
1 1 1 STATISTICS COLLECTOR (cr=7 pr=0 pw=0 time=161 us starts=1)
1 1 1 HASH JOIN (cr=7 pr=0 pw=0 time=152 us starts=1 cost=4 size=74 card=1)
1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=147 us starts=1 cost=4 size=74 card=1)
1 1 1 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=93 us starts=1)
1 1 1 NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=76 us starts=1 cost=3 size=65 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=22 us starts=1 cost=1 size=36 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=10 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 TABLE ACCESS FULL RESOURCE_GROUP_MAPPING$ (cr=3 pr=0 pw=0 time=49 us starts=1 cost=2 size=29 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED PROFILE$ (cr=2 pr=0 pw=0 time=49 us starts=1 cost=1 size=9 card=1)
18 18 18 INDEX RANGE SCAN I_PROFILE (cr=1 pr=0 pw=0 time=29 us starts=1 cost=0 size=0 card=18)(object id 423)
0 0 0 TABLE ACCESS FULL PROFILE$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=9 card=1)
1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=9 us starts=1 cost=1 size=3 card=1)
1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=4 us starts=1 cost=0 size=0 card=1)(object id 7)
0 0 0 TABLE ACCESS FULL TS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=3 card=1)
1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=3 card=1)
1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=3 us starts=1 cost=0 size=0 card=1)(object id 7)
0 0 0 TABLE ACCESS FULL TS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=3 card=1)
1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=3 card=1)
1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=2 us starts=1 cost=0 size=0 card=1)(object id 7)
0 0 0 TABLE ACCESS FULL TS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=3 card=1)
3 3 3 TABLE ACCESS FULL PROFNAME$ (cr=3 pr=0 pw=0 time=54 us starts=1 cost=2 size=9 card=3)
1 1 1 BUFFER SORT (cr=2 pr=0 pw=0 time=36 us starts=1 cost=8 size=9 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED PROFILE$ (cr=2 pr=0 pw=0 time=19 us starts=1 cost=1 size=9 card=1)
18 18 18 INDEX RANGE SCAN I_PROFILE (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=18)(object id 423)
1 1 1 TABLE ACCESS FULL USER_ASTATUS_MAP (cr=3 pr=0 pw=0 time=34 us starts=1 cost=2 size=9 card=3)
********************************************************************************
SQL ID: 0363bfvrm60h1 Plan Hash: 1104865917
DELETE FROM DBMS_PARALLEL_EXECUTE_TASK$
WHERE
TASK_OWNER# = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE DBMS_PARALLEL_EXECUTE_TASK$ (cr=1 pr=0 pw=0 time=14 us starts=1)
0 0 0 INDEX RANGE SCAN PK_DBMS_PARALLEL_EXECUTE_1 (cr=1 pr=0 pw=0 time=12 us starts=1 cost=0 size=79 card=1)(object id 9998)
********************************************************************************
SQL ID: 00yds36q4sw1f Plan Hash: 1191833520
select name
from
obj$ where owner# = :1 and type# = 82
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=26 us starts=1 cost=37 size=42 card=1)(object id 37)
********************************************************************************
SQL ID: c48rt0bqx6tj6 Plan Hash: 309091028
select vname, decode(bitand(flag3, 512), 512, 1, 0) iszmap
from
sys.snap$ where sowner = :1 and instsite = 0 and parent_vname IS NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED SNAP$ (cr=1 pr=0 pw=0 time=14 us starts=1 cost=0 size=224 card=1)
0 0 0 INDEX RANGE SCAN I_SNAP2 (cr=1 pr=0 pw=0 time=12 us starts=1 cost=0 size=0 card=1)(object id 864)
********************************************************************************
SQL ID: fua5ry3xfv7gj Plan Hash: 4169703363
select name
from
sys.transformations$ where owner = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS FULL TRANSFORMATIONS$ (cr=3 pr=0 pw=0 time=41 us starts=1 cost=2 size=78 card=3)
********************************************************************************
SQL ID: 5zwjutaaqbvz6 Plan Hash: 974465959
select queue_name
from
"_DBA_STREAMS_QUEUES" where queue_owner=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 10 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 10 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 VIEW _DBA_STREAMS_QUEUES (cr=10 pr=0 pw=0 time=82 us starts=1 cost=10 size=528 card=4)
0 0 0 SORT UNIQUE (cr=10 pr=0 pw=0 time=80 us starts=1 cost=10 size=528 card=4)
0 0 0 UNION-ALL (cr=10 pr=0 pw=0 time=65 us starts=1)
0 0 0 TABLE ACCESS FULL STREAMS$_CAPTURE_PROCESS (cr=3 pr=0 pw=0 time=35 us starts=1 cost=2 size=132 card=1)
0 0 0 INDEX RANGE SCAN STREAMS$_PROP_P_I2 (cr=1 pr=0 pw=0 time=10 us starts=1 cost=0 size=132 card=1)(object id 927)
0 0 0 TABLE ACCESS FULL STREAMS$_APPLY_PROCESS (cr=3 pr=0 pw=0 time=9 us starts=1 cost=2 size=132 card=1)
0 0 0 TABLE ACCESS FULL STREAMS$_MESSAGE_CONSUMERS (cr=3 pr=0 pw=0 time=9 us starts=1 cost=2 size=132 card=1)
********************************************************************************
SQL ID: 6p5h831792nfk Plan Hash: 3881751134
delete from system.aq$_internet_agent_privs
WHERE
db_username = NLS_UPPER(:1)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE AQ$_INTERNET_AGENT_PRIVS (cr=1 pr=0 pw=0 time=30 us starts=1)
0 0 0 INDEX SKIP SCAN UNQ_PAIRS (cr=1 pr=0 pw=0 time=24 us starts=1 cost=1 size=75 card=3)(object id 8604)
********************************************************************************
SQL ID: 50vxqdkj4zu1w Plan Hash: 1457651150
select user#,password,datats#,tempts#,type#,defrole,resource$,ptime,
decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,
ext_username,spare2,nvl(spare3,16382),spare9,spare10
from
user$ where name=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=26 us starts=1 cost=1 size=149 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=11 us starts=1 cost=0 size=0 card=1)(object id 46)
********************************************************************************
SQL ID: 586g10917q05y Plan Hash: 154039361
select name
from
system.aq$_queue_tables where schema = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS FULL AQ$_QUEUE_TABLES (cr=3 pr=0 pw=0 time=40 us starts=1 cost=2 size=104 card=4)
********************************************************************************
SQL ID: 92hhyh1ku7xg9 Plan Hash: 3021620271
delete from sys.streams$_propagation_process
where
source_queue_schema = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE STREAMS$_PROPAGATION_PROCESS (cr=1 pr=0 pw=0 time=13 us starts=1)
0 0 0 INDEX RANGE SCAN STREAMS$_PROP_P_I2 (cr=1 pr=0 pw=0 time=11 us starts=1 cost=0 size=396 card=1)(object id 927)
********************************************************************************
SQL ID: gtuttayaq3k7t Plan Hash: 3077212135
select o.name
from
rule_set$ rs, obj$ o, user$ u where u.name = :1 and o.owner# = u.user# and
o.obj# = rs.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 22 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 22 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=22 pr=0 pw=0 time=137 us starts=1 cost=25 size=66 card=1)
0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=125 us starts=1 cost=25 size=66 card=1)
0 0 0 NESTED LOOPS (cr=22 pr=0 pw=0 time=124 us starts=1 cost=25 size=66 card=19)
19 19 19 STATISTICS COLLECTOR (cr=3 pr=0 pw=0 time=74 us starts=1)
19 19 19 NESTED LOOPS (cr=3 pr=0 pw=0 time=32 us starts=1 cost=2 size=437 card=19)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=20 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=12 us starts=1 cost=0 size=0 card=1)(object id 46)
19 19 19 INDEX FULL SCAN I_RULE_SET (cr=1 pr=0 pw=0 time=8 us starts=1 cost=1 size=95 card=19)(object id 7822)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=19 pr=0 pw=0 time=60 us starts=19 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=43 card=1)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
********************************************************************************
SQL ID: bywathxbx9afa Plan Hash: 2394962431
select o.name
from
rule$ r, obj$ o, user$ u where u.name = :1 and o.owner# = u.user# and
o.obj# = r.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 5 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 5 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=5 pr=0 pw=0 time=86 us starts=1 cost=4 size=66 card=1)
0 0 0 NESTED LOOPS (cr=5 pr=0 pw=0 time=77 us starts=1 cost=4 size=66 card=1)
0 0 0 NESTED LOOPS (cr=5 pr=0 pw=0 time=75 us starts=1 cost=4 size=66 card=1)
1 1 1 STATISTICS COLLECTOR (cr=3 pr=0 pw=0 time=63 us starts=1)
1 1 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=44 us starts=1 cost=2 size=23 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=19 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=10 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX FULL SCAN I_RULE (cr=1 pr=0 pw=0 time=23 us starts=1 cost=1 size=5 card=1)(object id 7828)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=10 us starts=1 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=43 card=1)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
********************************************************************************
SQL ID: 3z16dy9dgdwzy Plan Hash: 3336425030
select o.name
from
rule_ec$ ec, obj$ o, user$ u where u.name = :1 and o.owner# = u.user# and
o.obj# = ec.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 19 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 19 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=19 pr=0 pw=0 time=105 us starts=1 cost=18 size=66 card=1)
0 0 0 NESTED LOOPS (cr=19 pr=0 pw=0 time=97 us starts=1 cost=18 size=66 card=1)
0 0 0 NESTED LOOPS (cr=19 pr=0 pw=0 time=94 us starts=1 cost=18 size=66 card=13)
13 13 13 STATISTICS COLLECTOR (cr=3 pr=0 pw=0 time=41 us starts=1)
13 13 13 NESTED LOOPS (cr=3 pr=0 pw=0 time=36 us starts=1 cost=2 size=299 card=13)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=15 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=10 us starts=1 cost=0 size=0 card=1)(object id 46)
13 13 13 INDEX FULL SCAN I_RULE_EC (cr=1 pr=0 pw=0 time=19 us starts=1 cost=1 size=65 card=13)(object id 7833)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=16 pr=0 pw=0 time=48 us starts=13 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=43 card=1)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
********************************************************************************
SQL ID: fyxhuqjjpnv3w Plan Hash: 0
begin dbms_rule_adm.drop_evaluation_context(:1, true); end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 73snhuv2xs8ct Plan Hash: 901283876
SELECT X.OBJNUM
FROM
(select a.obj# OBJNUM, b.owner# OWNNUM from sys.scheduler$_job a,
sys.obj$ b where a.obj# = b.obj# union all select c.obj#, d.userid
from sys.scheduler$_comb_lw_job c, sys.scheduler$_lwjob_obj d where
c.obj# = d.obj#) X WHERE X.OWNNUM = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 6 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 6 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 1m4ccdttfr04t Plan Hash: 1766724478
select a.obj#
from
sys.scheduler$_program a, sys.obj$ b where a.obj# = b.obj# and b.owner# =
:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 5 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 5 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 9h3jgjunuvyuq Plan Hash: 2412728030
select a.obj#
from
sys.scheduler$_schedule a, sys.obj$ b where a.obj# = b.obj# and b.owner# =
:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 5 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 5 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 664fgzxupa7ub Plan Hash: 3689362975
select a.obj#
from
sys.scheduler$_chain a, sys.obj$ b where a.obj# = b.obj# and b.owner# = :1
여기에는 한글 테이블이 잘 보인다.
하지만 xshell 에서 trace 파일을 보면 아래사진처럼 보인다.
trace 결과를 보니 한글 테이블을 지우지 못해서
유저 삭제도 안되는듯 하다.
정확한 해결방법!
1. DB 종료후 마운트 상태로 startup
|
1
2
|
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
|
2. DB restricted mode 활성화
|
1
|
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
|
3. 파라미터 변경(job프로세스가 실행되지 못하게 설정)
|
1
2
|
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
|
4. DB 오픈
|
1
|
SQL>ALTER DATABASE OPEN;
|
5. 캐릭터셋 강제 변경
* 이작업은 실제 운영DB에서는 하지않는것이 좋음
https://positivemh.tistory.com/153 참조
테스트 DB에서 문제가 발생한 경우에만 사용하기를 권장함
캐릭터셋 강제 변경의 경우 기존 한글테이블들의 데이터가 깨질수 있음을 인지하고 풀 백업 후 작업해야함
|
1
|
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
|
6. DB 재기동
|
1
2
|
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP;
|
7. 유저 접속후 확인
|
1
2
3
4
5
6
|
SQL> conn jsh/jsh
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
-------------------- ------- ----------
????????? TABLE (null)
1 row selected.
|
에러가 발생하지 않음
8. 다시 유저 삭제 시도
|
1
2
3
|
SYS> drop user jsh cascade;
User dropped.
|
정상적으로 삭제가 된다.
원인 : 한글이 깨져 오라클이 해당 테이블을 삭제하지 못해 발생한 에러
한글이 깨져 오라클이 해당 테이블을 삭제하지 못해 발생한 에러
|
1
2
|
ORA-00604: error occurred at recursive SQL level 1
ORA-01740: missing double quote in identifier
|
캐릭터셋이 다르게 설정되어 나타나는 에러
|
1
|
ORA-29275: partial multibyte character
|
참조 : https://positivemh.tistory.com/153
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| DBMS_SQLTUNE.REPORT_SQL_MONITOR 실행시 결과가 모두 나오지 않을때 (0) | 2018.11.12 |
|---|---|
| Resize operation completed for file# n 이란 (0) | 2018.11.08 |
| sqlplus 에서 show sga 값 E+10 으로 나올 때 (0) | 2018.10.29 |
| Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter. (0) | 2018.10.24 |
| ORA-09925: Unable to create audit trail file (0) | 2018.10.15 |