简单的做了一个测试
1: select user_name,user_id from all_users;
找出用户名和编号
SQL> select * from all_users;
USERNAME USER_ID CREATED
------------------------------ ---------- ----------
SYS 0 14-11月-00
SYSTEM 5 14-11月-00
OUTLN 11 14-11月-00
DBSNMP 16 14-11月-00
RAINY 41 14-1月 -03
AURORA$JIS$UTILITY$ 25 14-11月-00
OSE$HTTP$ADMIN 26 14-11月-00
AURORA$ORB$UNAUTHENTICATED 27 14-11月-00
ORDSYS 28 14-11月-00
ORDPLUGINS 29 14-11月-00
MDSYS 30 14-11月-00
CTXSYS 33 14-11月-00
SCOTT 35 14-11月-00
ADAMS 36 14-11月-00
JONES 37 14-11月-00
CLARK 38 14-11月-00
BLAKE 39 14-11月-00
MTSSYS 40 14-11月-00
PERFSTAT 45 26-2月 -03
CP 44 13-2月 -03
已选择20行。
SQL>
2: 通过sys用户找出表的信息
SQL> select OBJ# ,NAME from obj$ where owner# = 41;
OBJ# NAME
---------- ------------------------------
25095 A
25103 AAA
25104 BBB
24827 DBEXPERT_PLAN1
25038 DBMS_OUTPUT
25039 DBMS_SPACE
25192 FLT
25195 FLT2
25098 LMT0
25099 LMT1
25335 LMT2
25075 MYSEQ
24825 PLAN_TABLE
25201 PROCSENDEMAIL
25037 SHOW_SPACE
25105 T
25100 T0
25017 T1
25018 T2
25019 T2_IND
25035 TT
25036 TT1
25015 T_FREELIST
25016 T_FREELIST2
25202 UTL_SMTP
已选择25行。
3: 更新数据字典信息
SQL> update obj$ set owner# = 44 where obj# = 25335;
已更新 1 行。
SQL> commit;
提交完成。
4: 到44编号用户 cp 下
SQL> conn cp/cp
已连接。
SQL> desc lmt2
名称 空? 类型
---------------------------------------- -------- ------------------------
A NUMBER
SQL> insert into lmt2 select rownum from user_tables;
已创建29行。
SQL> commit;
提交完成。
SQL> select * from lmt2;
A
----------
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
已选择29行。
SQL> commit;
提交完成。
5: 再用sys用户把该表更改到 编号为 45的 perfstat下
SQL> conn / as sysdba
已连接。
SQL> update obj$ set owner# = 45 where obj# = 25335;
已更新 1 行。
SQL> commit;
提交完成。
SQL> conn perfstat/perfstat
已连接。
SQL> select * from lmt2;
A
----------
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
已选择29行。
SQL> insert into lmt2 values(50);
已创建 1 行。
SQL> commit;
提交完成。
由此我们可以看出这样似乎看起来是可行的
但要注意一点:
1: 相关索引也存在这样的问题,不过同样在 obj$里面应该可以改
2:对于用户如果存在quota限制,可能应该更新 tsq$,如果是 umlimited tablespace 可能问题不大
3:还有相关的一些权限等问题,比如该对象是否授权给别的用户,更改 onwer后还是否有效,我没有测试,思路给你了,发挥在你个人了
4: 本人对以后出现任何后果不承担任何责任
做了个 drop table 的操作
发现
跟user相关的有
obj$
tsq$
seg$
objauth$
我没有看完,估计应该是这些了
当drop table 的时候发现更新和删除了很多数据字典表
但是我们可以浏览所有这些表中是否存在 user# 字段
存在的我们才弄出来研究、更新
TKPROF: Release 8.1.7.0.0 - Production on 星期五 2月 28 13:00:21 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Trace file: ORA02604.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
********************************************************************************
drop table flt
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.02 0 0 0 0
Execute 1 1.37 1.45 0 1396 1 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 1.38 1.47 0 1396 1 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 41
********************************************************************************
select u2.name, o2.name
from
ind$ i, obj$ o1, obj$ o2, user$ u1, user$ u2 where i.bo# = o1.obj# and
o1.owner#=u1.user# and i.obj#=o2.obj# and o2.owner#=u2.user# and u1.name=
:1 and o1.name=:2 and i.type#=9
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.01 0 0 0 0
Execute 1 0.00 0.03 0 0 0 0
Fetch 1 0.00 0.00 0 8 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.02 0.04 0 8 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 NESTED LOOPS
1 NESTED LOOPS
1 NESTED LOOPS
2 NESTED LOOPS
2 TABLE ACCESS BY INDEX ROWID USER$
2 INDEX UNIQUE SCAN (object id 41)
2 TABLE ACCESS BY INDEX ROWID OBJ$
2 INDEX RANGE SCAN (object id 34)
1 TABLE ACCESS CLUSTER IND$
2 INDEX UNIQUE SCAN (object id 3)
0 TABLE ACCESS BY INDEX ROWID OBJ$
0 INDEX UNIQUE SCAN (object id 33)
0 TABLE ACCESS CLUSTER USER$
0 INDEX UNIQUE SCAN (object id 11)
********************************************************************************
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1
from
obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or
remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and
:5 is null)and(subname=:6 or subname is null and :6 is null)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 0 3 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID OBJ$
1 INDEX RANGE SCAN (object id 34)
********************************************************************************
select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),
audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,
avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),
nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0)
,nvl(spare2,0),spare4,nvl(spare3,0)
from
tab$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.02 0 0 0 0
Execute 16 0.00 0.00 0 0 0 0
Fetch 16 0.00 0.00 0 48 0 16
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 33 0.02 0.02 0 48 0 16
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,
o.dataobj#,o.flags
from
obj$ o where o.obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.02 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.02 0.02 0 3 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID OBJ$
1 INDEX UNIQUE SCAN (object id 33)
********************************************************************************
select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled
from
obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and
o.owner#=u.user# order by o.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.02 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.02 0.02 0 1 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS BY INDEX ROWID TRIGGER$
1 INDEX RANGE SCAN (object id 119)
0 TABLE ACCESS BY INDEX ROWID OBJ$
0 INDEX UNIQUE SCAN (object id 33)
0 TABLE ACCESS CLUSTER USER$
0 INDEX UNIQUE SCAN (object id 11)
********************************************************************************
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,spare2,decode(i.pctthres$,null,null,
mod(trunc(i.pctthres$/256),256))
from
ind$ i, (select enabled, min(cols) 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.bo#=
:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 39 0.02 0.01 0 84 0 21
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 58 0.03 0.02 0 84 0 21
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
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, charsetid,charsetform,spare1,spare2
from
col$ where obj#=:1 order by intcol#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.03 0.03 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 150 0.00 0.00 0 55 0 132
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 169 0.03 0.03 0 55 0 132
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
select con#,obj#,rcon#,enabled,nvl(defer,0)
from
cdef$ where robj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.04 0.03 0 0 0 0
Execute 25 0.02 0.01 0 0 0 0
Fetch 25 0.00 0.00 0 25 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 51 0.06 0.04 0 25 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),
rowid,cols,nvl(defer,0),mtime,nvl(spare1,0)
from
cdef$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.02 0 0 0 0
Execute 25 0.00 0.00 0 0 0 0
Fetch 192 0.04 0.04 0 218 0 167
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 218 0.06 0.06 0 218 0 167
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
select pos#,intcol#,col#,spare1
from
icol$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 21 0.01 0.02 0 0 0 0
Fetch 73 0.02 0.00 0 146 0 52
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 95 0.04 0.03 0 146 0 52
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
select count(*)
from
association$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.16 0.19 0 21 1 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.16 0.19 0 22 1 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE
0 INDEX RANGE SCAN (object id 312)
********************************************************************************
select intcol#
from
ustats$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.11 0.11 0 17 1 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.11 0.11 0 18 1 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX RANGE SCAN (object id 315)
********************************************************************************
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,
NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0)
from
seg$ where ts#=:1 and file#=:2 and block#=:3
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.02 0.01 0 3 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER SEG$
1 INDEX UNIQUE SCAN (object id 9)
********************************************************************************
select c.owner#,c.name,c.con#
from
con$ c,cdef$ d where d.obj#=:1 and d.con#=c.con#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.02 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.02 0 1 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 NESTED LOOPS
1 TABLE ACCESS CLUSTER CDEF$
1 INDEX UNIQUE SCAN (object id 27)
0 TABLE ACCESS BY INDEX ROWID CON$
0 INDEX UNIQUE SCAN (object id 46)
********************************************************************************
select intcol#,nvl(pos#,0),col#
from
ccol$ where con#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.02 0 0 0 0
Execute 167 0.04 0.05 0 0 0 0
Fetch 334 0.07 0.07 0 668 0 167
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 502 0.12 0.14 0 668 0 167
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
delete com$
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.14 0.16 0 25 1 0
Execute 1 0.00 0.00 0 2 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.14 0.16 0 27 1 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE COM$
1 INDEX RANGE SCAN (object id 106)
********************************************************************************
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
sample_size, minimum, maximum, distcnt, lowval, hival, density, col#,
spare1, spare2, avgcln
from
hist_head$ where obj#=:1 and intcol#=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.17 0.19 0 20 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.17 0.19 0 22 0 0
Misses in library cache during parse: 1
Optimizer goal: RULE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID HIST_HEAD$
2 INDEX RANGE SCAN (object id 194)
********************************************************************************
delete from hist_head$
where
obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.13 0.12 0 28 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.13 0.12 0 29 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE HIST_HEAD$
1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$
1 INDEX RANGE SCAN (object id 194)
********************************************************************************
select o.owner#, u.name, o.name, o.namespace,
o.obj#, d.d_timestamp, nvl(d.property,0)
from
dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2
or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# and
decode(:3,0,0,o.type#)=:3
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.02 0.02 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.03 0.03 0 3 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$
1 INDEX RANGE SCAN (object id 117)
0 TABLE ACCESS BY INDEX ROWID OBJ$
0 INDEX UNIQUE SCAN (object id 33)
0 TABLE ACCESS CLUSTER USER$
0 INDEX UNIQUE SCAN (object id 11)
********************************************************************************
delete from dependency$
where
d_obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.17 0.17 0 38 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.17 0.17 0 38 0 0
Misses in library cache during parse: 1
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
select o.name, u.name
from
sys.obj$ o, sys.user$ u where u.user#=o.owner# and o.obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.03 0.03 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 5 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.03 0.03 0 5 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 NESTED LOOPS
1 TABLE ACCESS BY INDEX ROWID OBJ$
1 INDEX UNIQUE SCAN (object id 33)
1 TABLE ACCESS CLUSTER USER$
1 INDEX UNIQUE SCAN (object id 11)
********************************************************************************
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)
from
clu$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 0 3 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
select master
from
sys.mlog$ where master = :2 and mowner = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.20 0.21 0 25 1 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.20 0.21 0 26 1 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS CLUSTER MLOG$
1 INDEX UNIQUE SCAN (object id 152)
********************************************************************************
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#,
d_owner#, nvl(property,0)
from
dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.04 0.04 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 10 0.00 0.00 0 32 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 14 0.04 0.04 0 32 0 8
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
6 SORT ORDER BY
6 NESTED LOOPS OUTER
7 TABLE ACCESS BY INDEX ROWID DEPENDENCY$
7 INDEX RANGE SCAN (object id 116)
6 TABLE ACCESS BY INDEX ROWID OBJ$
12 INDEX UNIQUE SCAN (object id 33)
********************************************************************************
select order#,columns,types
from
access$ where d_obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.04 0.04 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 5 0.00 0.00 0 10 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.04 0.04 0 10 0 3
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
3 TABLE ACCESS BY INDEX ROWID ACCESS$
4 INDEX RANGE SCAN (object id 118)
********************************************************************************
select actionsize
from
trigger$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.04 0.03 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 4 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.04 0.03 0 4 0 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TRIGGER$
1 INDEX UNIQUE SCAN (object id 120)
********************************************************************************
select action#
from
trigger$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.05 0.05 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 6 0.05 0.05 0 6 0 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TRIGGER$
1 INDEX UNIQUE SCAN (object id 120)
********************************************************************************
select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,
whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,
refprtname,rowid
from
trigger$ where obj# =:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.01 0.02 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 4 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.01 0.02 0 4 0 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TRIGGER$
1 INDEX UNIQUE SCAN (object id 120)
********************************************************************************
select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,
c.precision#,c.charsetid,c.charsetform
from
triggercol$ tc,col$ c ,trigger$ tr where tc.obj#=:1 and c.obj#=:2 and
tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) !=
32 or bitand(tc.type#,20) = 20) union select type#,intcol#,position#,69,0,0,
0,0,0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#,
tc.intcol#,tc.position#,121,0,0,0,0,0 from triggercol$ tc,trigger$ tr where
tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :4 and
bitand(tc.type#,20) != 20
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.17 0.19 0 31 1 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 8 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.17 0.19 0 39 1 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT UNIQUE
0 UNION-ALL
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS CLUSTER COL$
1 INDEX UNIQUE SCAN (object id 3)
0 INDEX RANGE SCAN (object id 122)
0 TABLE ACCESS BY INDEX ROWID TRIGGER$
0 INDEX UNIQUE SCAN (object id 120)
0 INDEX RANGE SCAN (object id 122)
0 NESTED LOOPS
1 INDEX RANGE SCAN (object id 122)
0 TABLE ACCESS BY INDEX ROWID TRIGGER$
0 INDEX UNIQUE SCAN (object id 120)
********************************************************************************
select /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version)
from
idl_sb4$ where obj#=:1 and version<=:2 and (part=0 or part=2) and piece#=0
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.14 0.14 0 21 1 0
Execute 2 0.06 0.06 0 0 0 0
Fetch 2 0.00 0.00 0 8 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.20 0.20 0 29 1 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE
1 INLIST ITERATOR
1 INDEX RANGE SCAN (object id 113)
********************************************************************************
select i.obj#
from
ind$ i, obj$ o where i.obj# = o.obj# and i.bo# = :1 and o.name = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5 0.08 0.08 0 0 0 0
Execute 5 0.00 0.00 0 0 0 0
Fetch 5 0.00 0.00 0 30 0 5
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15 0.08 0.08 0 30 0 5
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 3)
Rows Row Source Operation
------- ---------------------------------------------------
1 NESTED LOOPS
1 TABLE ACCESS CLUSTER IND$
1 INDEX UNIQUE SCAN (object id 3)
1 TABLE ACCESS BY INDEX ROWID OBJ$
1 INDEX UNIQUE SCAN (object id 33)
********************************************************************************
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 2 0.06 0.08 0 0 0 0
Execute 2 0.06 0.06 0 0 0 0
Fetch 6 0.00 0.00 0 16 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 10 0.12 0.14 0 16 0 4
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
2 TABLE ACCESS BY INDEX ROWID IDL_SB4$
3 INDEX RANGE SCAN (object id 113)
********************************************************************************
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 2 0.12 0.12 0 22 1 0
Execute 2 0.05 0.05 0 0 0 0
Fetch 4 0.00 0.00 0 10 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.17 0.17 0 32 1 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID IDL_UB1$
2 INDEX RANGE SCAN (object id 110)
********************************************************************************
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 2 0.13 0.13 0 21 1 0
Execute 2 0.06 0.06 0 0 0 0
Fetch 4 0.00 0.00 0 10 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.19 0.19 0 31 1 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$
2 INDEX RANGE SCAN (object id 111)
********************************************************************************
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 2 0.13 0.13 0 21 1 0
Execute 2 0.06 0.07 0 0 0 0
Fetch 4 0.00 0.00 0 14 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.19 0.20 0 35 1 4
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
2 TABLE ACCESS BY INDEX ROWID IDL_UB2$
2 INDEX RANGE SCAN (object id 112)
********************************************************************************
select dummy
from
dual where ora_dict_obj_type='ROLE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.94 0.96 0 131 4 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.94 0.96 0 131 4 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 FILTER
0 TABLE ACCESS FULL DUAL
********************************************************************************
select user#
from
sys.user$ where name = 'OUTLN'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.01 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.02 0.01 0 2 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID USER$
1 INDEX UNIQUE SCAN (object id 41)
********************************************************************************
declare
stmt varchar2(200);
BEGIN
if dictionary_obj_type = 'USER' THEN
stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';
EXECUTE IMMEDIATE stmt;
end if;
end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.10 0.09 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.10 0.09 0 0 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 30 (recursive depth: 1)
********************************************************************************
delete from col$
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.30 0.31 0 64 0 0
Execute 2 0.01 0.08 3 10 16 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.31 0.39 3 74 16 2
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE COL$
3 TABLE ACCESS CLUSTER COL$
2 INDEX UNIQUE SCAN (object id 3)
********************************************************************************
delete from icol$
where
bo#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.17 0.17 0 43 0 0
Execute 1 0.00 0.00 0 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.17 0.17 0 46 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE ICOL$
1 TABLE ACCESS CLUSTER ICOL$
2 INDEX UNIQUE SCAN (object id 3)
********************************************************************************
delete from icoldep$
where
bo#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.16 0.15 0 33 1 0
Execute 1 0.00 0.00 0 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.16 0.15 0 36 1 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE ICOLDEP$
1 TABLE ACCESS CLUSTER ICOLDEP$
2 INDEX UNIQUE SCAN (object id 3)
********************************************************************************
delete from ccol$
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.11 0.11 0 23 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.11 0.11 0 24 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE CCOL$
1 TABLE ACCESS CLUSTER CCOL$
1 INDEX UNIQUE SCAN (object id 27)
********************************************************************************
delete from ind$
where
bo#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.29 0.28 0 73 0 0
Execute 1 0.00 0.00 0 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.29 0.28 0 76 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE IND$
1 TABLE ACCESS CLUSTER IND$
2 INDEX UNIQUE SCAN (object id 3)
********************************************************************************
delete from cdef$
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.10 0.10 0 18 0 0
Execute 2 0.00 0.00 0 2 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.10 0.10 0 20 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE CDEF$
1 TABLE ACCESS CLUSTER CDEF$
1 INDEX UNIQUE SCAN (object id 27)
********************************************************************************
delete from tab$
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.29 0.31 0 73 0 0
Execute 1 0.00 0.00 0 5 1 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.29 0.31 0 78 1 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE TAB$
2 TABLE ACCESS CLUSTER TAB$
2 INDEX UNIQUE SCAN (object id 3)
********************************************************************************
delete from idl_ub1$
where
obj#=:1 and part=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.13 0.14 0 29 0 0
Execute 2 0.00 0.00 0 4 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.13 0.14 0 33 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE IDL_UB1$
1 INDEX RANGE SCAN (object id 110)
********************************************************************************
delete from idl_char$
where
obj#=:1 and part=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.13 0.16 0 28 0 0
Execute 2 0.00 0.00 0 4 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.13 0.16 0 32 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE IDL_CHAR$
1 INDEX RANGE SCAN (object id 111)
********************************************************************************
delete from idl_ub2$
where
obj#=:1 and part=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.16 0.16 0 28 0 0
Execute 2 0.01 0.02 0 4 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.17 0.18 0 32 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE IDL_UB2$
1 INDEX RANGE SCAN (object id 112)
********************************************************************************
delete from idl_sb4$
where
obj#=:1 and part=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.15 0.16 0 28 0 0
Execute 2 0.00 0.00 0 4 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.15 0.16 0 32 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 DELETE IDL_SB4$
1 INDEX RANGE SCAN (object id 113)
********************************************************************************
delete coltype$
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.26 0.28 0 56 1 0
Execute 1 0.00 0.00 0 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.26 0.28 0 59 1 0