Home » RDBMS Server » Server Utilities » Export Not completed
|
|
|
|
Re: Export Not completed [message #272500 is a reply to message #272490] |
Fri, 05 October 2007 04:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
![babu.knb@gmail.com](/forum/theme/orafaq/images/google.png) ![babudba](/forum/theme/orafaq/images/skype.png)
|
|
Michel,
If i export that user it's not completed. I think some problem happening in this session. Because if i select "CONSUMPTIONCATEGORYMASTER" - this table application got hanged even told also.
So, I think problem in CONSUMPTIONCATEGORYMASTER table.
I want to know what is the problem?
Babu
[Updated on: Fri, 05 October 2007 05:23] Report message to a moderator
|
|
|
|
|
|
Re: Export Not completed [message #272514 is a reply to message #272511] |
Fri, 05 October 2007 06:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
![babu.knb@gmail.com](/forum/theme/orafaq/images/google.png) ![babudba](/forum/theme/orafaq/images/skype.png)
|
|
Dump file d:\oracle\product\10.2.0\admin\edkdb\udump\edkdb_ora_2892.trc
Fri Oct 05 16:04:19 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.1.0 - Production
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:48M/503M, Ph+PgF:898M/1697M, VA:1629M/2047M
Instance name: edkdb
Redo thread mounted by this instance: 1
Oracle process number: 38
Windows thread id: 2892, image: ORACLE.EXE (SHAD)
*** 2007-10-05 16:04:19.670
*** ACTION NAME:() 2007-10-05 16:04:19.607
*** MODULE NAME:(SQL*Plus) 2007-10-05 16:04:19.607
*** SERVICE NAME:(edkdb.samiindia) 2007-10-05 16:04:19.607
*** SESSION ID:(120.14039) 2007-10-05 16:04:19.607
=====================
PARSING IN CURSOR #3 len=32 dep=0 uid=5 oct=42 lid=5 tim=3306258614 hv=2097336573 ad='696c4578'
ALTER SESSION SET SQL_TRACE=TRUE
END OF STMT
EXEC #3:c=0,e=491,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=3306258609
*** 2007-10-05 16:04:36.795
=====================
PARSING IN CURSOR #1 len=37 dep=1 uid=0 oct=3 lid=0 tim=3323438812 hv=1398610540 ad='6cef4310'
select text from view$ where rowid=:1
END OF STMT
PARSE #1:c=15625,e=2083,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=3323438805
EXEC #1:c=0,e=2614,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=3323669620
FETCH #1:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3323675079
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=31 us)'
=====================
PARSING IN CURSOR #5 len=37 dep=1 uid=0 oct=3 lid=0 tim=3323686509 hv=1398610540 ad='6cef4310'
select text from view$ where rowid=:1
END OF STMT
PARSE #5:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323686503
EXEC #5:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323718456
FETCH #5:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3323723946
STAT #5 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=30 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=3323735463 hv=1398610540 ad='6cef4310'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323735457
EXEC #3:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323768419
FETCH #3:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3323773993
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=30 us)'
=====================
PARSING IN CURSOR #4 len=302 dep=0 uid=5 oct=3 lid=5 tim=3323819075 hv=3347503714 ad='6751fa00'
SELECT s.sid, s.serial#, pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name'))
|| '_j000_' || p.spid || '.trc' AS trace_file FROM v$session s, v$process p, v$parameter pa
WHERE pa.name = 'user_dump_dest' AND s.paddr = p.addr
AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID')
END OF STMT
PARSE #4:c=78125,e=383068,p=0,cr=6,cu=0,mis=1,r=0,dep=0,og=1,tim=3323819068
EXEC #4:c=0,e=86,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3323875183
FETCH #4:c=15625,e=10385,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=3323893423
FETCH #4:c=0,e=1098,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3323903595
STAT #4 id=1 cnt=1 pid=0 pos=1 obj=0 op='HASH JOIN (cr=0 pr=0 pw=0 time=10360 us)'
STAT #4 id=2 cnt=1381 pid=1 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=9982 us)'
STAT #4 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=0 pr=0 pw=0 time=1137 us)'
STAT #4 id=4 cnt=1 pid=3 pos=1 obj=0 op='HASH JOIN (cr=0 pr=0 pw=0 time=1114 us)'
STAT #4 id=5 cnt=1 pid=4 pos=1 obj=0 op='FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=472 us)'
STAT #4 id=6 cnt=36 pid=4 pos=2 obj=0 op='FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=159 us)'
STAT #4 id=7 cnt=1 pid=3 pos=2 obj=0 op='FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=13 us)'
STAT #4 id=8 cnt=1381 pid=2 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=6367 us)'
STAT #4 id=9 cnt=1381 pid=8 pos=1 obj=0 op='FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=4158 us)'
STAT #4 id=10 cnt=1 pid=1 pos=2 obj=0 op='FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=1036 us)'
Tel me what kind of info. here analyze?
|
|
|
|
|
Goto Forum:
Current Time: Thu Sep 12 04:47:23 CDT 2024
|