一直以来感觉跟踪EXP都比较麻烦,MOS 上有篇文章来介绍EXP的跟踪
Getting 10046 Trace for Export and Import [ID 258418.1]
最近发现EXP还有个专门的跟踪参数TRACE=TRUE,这使得跟踪EXP变的格外简单。
[oracle@db2server ~]$ exp test/test file=test.dmp trace=true
Export: Release 11.2.0.3.0 - Production on Thu Aug 1 00:37:39 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
. . exporting table A 0 rows exported
. . exporting table CPIC 0 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table HAIER 9 rows exported
. . exporting table PART_TAB_P1 0 rows exported
. . exporting table PART_TAB_P2 1 rows exported
. . exporting table PART_TAB_P3 1 rows exported
. . exporting table PART_TAB_P4 1 rows exported
. . exporting table PART_TAB_P5 2 rows exported
. . exporting table PRODUCT_A 2 rows exported
. . exporting table PRODUCT_B 2 rows exported
. . exporting table T1 10 rows exported
. . exporting table T2 10 rows exported
. . exporting table TEMP_TMP
. . exporting table TEST 75926 rows exported
. . exporting table TMP_T
. . exporting table T_OBJECT 146946 rows exported
. . exporting table WIDE_TBL 31 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
跟踪文件发现ORACLE实际执行了一条ALTER SESSION SET SQL_TRACE = TRUE的语句,
这仅仅是LEVEL 1的跟踪,如果要更高级别的跟踪,还得采用ID 258418.1介绍的方法。
[root@db2server trace]# more huateng_ora_16762.trc
Trace file /u01/app/oracle/diag/rdbms/huateng/huateng/trace/huateng_ora_16762.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/db11.2.0.3
System name: Linux
Node name: db2server
Release: 2.6.18-92.el5
Version: #1 SMP Tue Jun 10 18:49:47 EDT 2008
Machine: i686
VM name: VMWare Version: 6
Instance name: huateng
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 16762, image: oracle@db2server (TNS V1-V3)
*** 2013-08-01 00:37:40.524
*** SESSION ID:(1.7) 2013-08-01 00:37:40.524
*** CLIENT ID:() 2013-08-01 00:37:40.524
*** SERVICE NAME:(SYS$USERS) 2013-08-01 00:37:40.524
*** MODULE NAME:(exp@db2server (TNS V1-V3)) 2013-08-01 00:37:40.524
*** ACTION NAME:() 2013-08-01 00:37:40.524
=====================
PARSING IN CURSOR #12071688 len=34 dep=0 uid=96 oct=42 lid=96 tim=1375288660523391 hv=3913151867 ad='65feb0' sqlid='14ys3d7nmvxbv'
ALTER SESSION SET SQL_TRACE = TRUE
END OF STMT
EXEC #12071688:c=7999,e=9296,p=1,cr=17,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1375288660515824
CLOSE #12071688:c=0,e=6,dep=0,type=0,tim=1375288660526277
=====================
PARSING IN CURSOR #6850772 len=202 dep=1 uid=0 oct=3 lid=0 tim=1375288660528887 hv=3819099649 ad='2615a2e8' sqlid='3nkd3g3ju5ph1'
select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteo
wner is null and linkname is null and subname is null
END OF STMT
EXEC #6850772:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2853959010,tim=1375288660528884
FETCH #6850772:c=0,e=49,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,plh=2853959010,tim=1375288660529175
CLOSE #6850772:c=0,e=3,dep=1,type=3,tim=1375288660529216
EXEC #6850772:c=0,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2853959010,tim=1375288660529413
FETCH #6850772:c=0,e=52,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,plh=2853959010,tim=1375288660529489
CLOSE #6850772:c=0,e=5,dep=1,type=3,tim=1375288660529527
阅读(1391) | 评论(0) | 转发(0) |