有人发帖了
把我这个删掉好了....
http://www.itpub.net/thread-1206680-1-1.html
他的跟踪文件用sql_trace做的
如下
# cat xtjcdb_ora_1679614_ok.trc
/oracle/admin/xtjcdb/udump/xtjcdb_ora_1679614_ok.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/1024
System name:AIX
Node name:ibmright
Release:3
Version:5
Machine:000CA31F4C00
Instance name: xtjcdb
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 1679614, image: [email=oracle@ibmright]oracle@ibmright[/email] (TNS V1-V3)
*** 2009-08-21 11:33:12.254
*** ACTION NAME
) 2009-08-21 11:33:12.253
*** MODULE NAME
SQL*Plus) 2009-08-21 11:33:12.253
*** SERVICE NAME
SYS$USERS) 2009-08-21 11:33:12.253
*** SESSION ID
316.29) 2009-08-21 11:33:12.253
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #1 len=135 dep=0 uid=40 oct=13 lid=40 tim=3533144530860 hv=0 ad='1045fc08'
CREATE SEQUENCE "HIBERNATE_SEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999
INCREMENT BY 1 START WITH 19421 CACHE 20 NOORDER NOCYCLE
END OF STMT
PARSE #1:c=0,e=2145,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=3533144530848
=====================
PARSING IN CURSOR #2 len=1664 dep=1 uid=0 oct=47 lid=0 tim=3533144531655 hv=2496337384 ad='e79d318'
DECLARE
sql_text varchar2(200);
val number;
BEGIN
if (dictionary_obj_owner != 'XDB') then
if (dictionary_obj_type = 'FUNCTION' or
dictionary_obj_type = 'INDEX' or
dictionary_obj_type = 'PACKAGE' or
dictionary_obj_type = 'PACKAGE BODY' or
dictionary_obj_type = 'PROCEDURE' or
dictionary_obj_type = 'SYNONYM' or
dictionary_obj_type = 'TABLE' or
dictionary_obj_type = 'TABLESPACE' or
dictionary_obj_type = 'TYPE' or
dictionary_obj_type = 'VIEW' or
dictionary_obj_type = 'USER'
)then
if (dictionary_obj_type!= 'PACKAGE BODY'
) then
sql_text := 'select count(*) from ALL_OBJECTS where owner = :1 and object_name = :2 and object_type = :3';
execute immediate sql_text into val using dictionary_obj_owner, dictionary_obj_name, dictionary_obj_type;
if (val = 0) then
sql_text := 'select count(*) from dropped_xdb_instll_tab where owner = :1 and object_name = :2 and object_type = :3';
execute immediate sql_text into val using dictionary_obj_owner, dictionary_obj_name, dictionary_obj_type;
if (val = 0) then
insert into xdb_installation_tab values
(dictionary_obj_owner, dictionary_obj_name, dictionary_obj_type);
end if;
end if;
end if;
else
raise_application_error(-20000, 'Trigger xdb_installation_trigger does not support object creation of type '||dictionary_obj_type);
end if;
end if;
end;
END OF STMT
PARSE #2:c=0,e=248,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3533144531648
EXEC #2:c=0,e=594,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3533144532938
ERROR #2:err=20000 tim=528507641
EXEC #1:c=0,e=2180,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3533144533187
ERROR #1:err=604 tim=528507641
*** 2009-08-21 11:33:31.964
=====================
PARSING IN CURSOR #2 len=33 dep=0 uid=40 oct=42 lid=40 tim=3533163777789 hv=525901419 ad='0'
alter session set sql_trace=false
END OF STMT
PARSE #2:c=0,e=1205,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=3533163777776
EXEC #2:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=3533163778074
[ 本帖最后由 ouyangzi 于 2009-8-21 11:58 编辑 ]
|
