| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Detect long running jobs where user shuts down their work
Rick,
Once a query is submitted to the server for processing the client can evaporate without disturbing it's execution. The database server will know nothing about the client's status until it has the first row of data ready to send, which can be hours or days later. At that point the database will know that the client has died/disappeared & close out the connection dumping the result set in the process. Bummer!!
The solution I set was to set everyone's profile in the database with CPU_PER_CALL = 360000. This provides ~ 4 hours for any one query to complete before it auto terminates. Note that things like DBMS_LOCK.SLEEP or DBMS_LOCK.REQUEST or DBMS_ALERT.WAITxx do not count against this limit. And you must have RESOURCE_LIMIT=TRUE in init.ora.
Dick Goulet
____________________Reply Separator____________________Subject: Detect long running jobs where user shuts down their worksta Author: Rick_Cale_at_teamhealth.com
Hi All,
We have users who sql access who will issue long running queries(you know the type) and just shuts down their computer while running.
I assume once sent to the server that server is still executing it or will it die once connection is broken. Can someone explain what actually happens in this scenario.
Is there anyway to detect/kill process.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Rick_Cale_at_teamhealth.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 11 2002 - 08:40:00 CDT
 |
 |