您的位置: 旅游网 > 影视

获得Export-Import的trace文件(二)

发布时间:2019-09-12 10:01:27

3、hr窗口执行sql

SQL> select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

COUNTRIES TABLE

DEPARTMENTS TABLE

EMPLOYEES TABLE

EMP_DETAILS_VIEW VIEW

JOBS TABLE

JOB_HISTORY TABLE

LOCATIONS TABLE

REGIONS TABLE

8 rows selected.

SQL> select * from employees;

EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID

----------- -------------------- ------------------------- ------------------------- -------------------- --------------- ----------

SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID

---------- -------------- ---------- -------------

100 Steven King SKING 515.123.4567 17-JUN-87 AD_PRES

24000 90

101 Neena Kochhar NKOCHHAR 515.123.4568 21-SEP-89 AD_VP

17000 100 90

102 Lex De Haan LDEHAAN 515.123.4569 13-JAN-93 AD_VP

17000 100 90

4、重新检查trace是否生成,并关掉10046

SQL> oradebug tracefile_name;

/opt/oracle/admin/yang/udump/yang_ora_8882.trc

SQL> oradebug event 10046 trace name context off

Statement processed.

SQL> exit

5、查看trace

oracle@yang:~> vi /opt/oracle/admin/yang/udump/yang_ora_8882.trc

opt/oracle/admin/yang/udump/yang_ora_8882.trc

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

ORACLE_HOME = /opt/oracle/product/9ir2

System name: Linux

Node name: yang

Release: 2.4.21-138-default

Version: #1 Fri Oct 31 00:44:18 UTC 2003

Machine: i686

Instance name: yang

Redo thread mounted by this instance: 1

Oracle process number: 15

Unix process pid: 8882, image: oracle@yang (TNS V1-V3)

*** 2006-04-21 18:15:49.954

*** SESSION ID<img src="images/smilies/2.gif" border="0" alt="皱眉">23.405) 2006-04-21 18:15:49.943

WAIT #0: nam='SQL*Net message from client' ela= 239971432 p1=1650815232 p2=1 p3=0

=====================

PARSING IN CURSOR #2 len=198 dep=1 uid=0 oct=3 lid=0 tim=1118764208951706 hv=2703824309 ad='52b9d678'

select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

END OF STMT

PARSE #2:c=0,e=1318,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1118764208951664

BINDS #2:

bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0

bfp=0ada7a90 bln=22 avl=02 flg=05

value=29

bind 1: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0

bfp=0adace7c bln=32 avl=03 flg=

查看本文来源

三个月大的宝宝咳嗽怎么办
三岁宝宝脸发黄
小孩子老是不爱吃饭怎么办
小孩脾胃虚弱怎么办
猜你会喜欢的
猜你会喜欢的