Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Session broke and query running

Session broke and query running

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Thu, 29 Jul 2004 09:34:24 -0700 (PDT)
Message-ID: <20040729163424.85957.qmail@web51310.mail.yahoo.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu Jul 29 2004 - 11:30:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US