Can you find out what the session is waiting on. You can use

select substr(event,1,25),sum(time_waited) from v$session_Event where
sid = &SIDVAL group by event
/

and

select state||' for '||seconds_in_wait||' seconds or '||wait_time||' total
time on '||event||
' ---> '||p1text||'='||p1||', '||p2text||'='||p2||p3text||'='||p3
Session_Waits
from v$session_wait where sid = &sid_to_check
/



Babu
----- Original Message -----
From: "Bhamani, Naushad A" <Naushad.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, February 28, 2002 1:25 PM
Subject: RE: Exports question


> Thanks Mike for your reply,
> there is plenty of space.
> Any other thoughts?
> Please let me know
> thanks
> Naushad
>
> -----Original Message-----
> From: Michael Porter [mailto:[Email Address Removed] Sent: Thursday, February 28, 2002 1:23 PM
> To: LazyDBA.com Discussion
> Subject: Re: Exports question
>
>
> Look at your export files size, you might be hitting an OS size limit. I
> have seen this and it does NOT error out or complain about insufficient
> disk space... Just a quick thought.
>
> Mike
>
> >>> "Bhamani, Naushad A" <Naushad.[Email Address Removed] 02/28/02 01:17PM
> >>>
> Hi Gurus,
>
> Is there any limitation in export with regards to users. I am doing a
> full
> export and some how it gets hung at a particular user.
>
> my export script looks like below
> exp / file=${DUMP_DIR}/${DUMP_FILE} log=${LOG_DIR}/${LOG_FILE} full=y
> compress=n consistent=y constraints=y direct=y grants=y indexes=y
> rows=y
> statistics=none triggers=y
>
> Please let me know
> thanks
> Naushad
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page