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____________________
Author: [EMAIL PROTECTED]
Date: 9/11/2002 5:13 AM
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
