Session broke and query running
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Jul 2004 09:34:24 -0700 (PDT)
I am on Sun platform where the connection broke after
30 min if the OS session is idle. I logon to sqlplus
and run a query using bulk collect to insert into a
table. The query is big as the table involved contain
6 CLOB and generally take around 1 hr to insert a few
hundred thousand record into the table. I just
realized and found that mine OS connection is broken
but when i checked the OS process, I find that mine
process is still running and I used truss and it look
like it is calling open,pwrite kind of system call.
but as it is alread around 2 hours been passed and so
I am worried if it is good to kill the session as the
process is really also putting small recource on CPU
as per the TOP output.
Please advice as I thought that once the connection
broke, the database connection is also gone and the
connected process might be runaway process. I had to
insert the big data and I need some expert advice
Thanks
SAnjay
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Session broke and query running
