| vikhardba |
Posted: Jan 12, 2008 05:02:05 AM |
Total Post: 86
Joined: Apr, 2007
|
One question - while export is going on at schema/tablespace/objects/row level, how and where should i check "How much of time is required to exp/imp db/tablespace" and also "How much of time is left to complete the exp/imp task"
Do we check in v$session view. Can you please give me complete query. |
|
|
 Vinod |
| Posted: Jan 12, 2008 06:42:35 AM |  |
|
Total Post: 54
Joined: Oct, 2007
|
SELECT s.sid,
s.serial#,
s.machine,
ROUND(sl.elapsed_seconds/60) || ':' ||
MOD(sl.elapsed_seconds,60) elapsed,
ROUND(sl.time_remaining/60) || ':' ||
MOD(sl.time_remaining,60) remaining,
ROUND(sl.sofar/sl.totalwork*100, 2) progress_pct
FROM v$session s,
v$session_longops sl
WHERE s.sid = sl.sid
AND s.serial# = sl.serial#;
|
|
|
|
|
| vikhardba |
| Posted: Jan 12, 2008 04:24:29 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
thanks for your response. I have tried this query but to no luck. It is showing "no rows selected" ... i have opened two sessions - in one, export was going on and in another i executed above mentioned query.
Version - 10.2.0.1
Os = Windows 2000
|
|
|
|
|
| vikhardba |
| Posted: Jan 12, 2008 04:37:26 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
Sorry, Now i am able to see the result. At "exporting stored procedures...." stage i see that
ELAPSED REMAINING and PROGRESS_PCT
------- --------- ------------
1:25 0:00 100
Can i know what does it mean. Specially PROGRESS_PCT value????
|
|
|
|
|
| Vinod |
| Posted: Jan 12, 2008 10:20:44 PM | |
|
Total Post: 54
Joined: Oct, 2007
|
Some minor changes needs to be made on the script ,anyway practically you can find the exact value from the count /progress .PROGRES_PCT would mean progress .
Vinod Udapudi
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
