RE: Why not set all sessions to resumable?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Mar 2004 21:00:41 -0600
Rich
Just a cursory glance at the feature yields the fact that not all
sessions may be eligible for this feature. The other issue is that if
someone is not expecting this behavior, they might wonder what happened to
their process, why it didn't complete, yet is not running. Kind of like when
I discovered spfile by stumbling into it. I was very frustrated until I
figured out how to turn it off.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jesse, Rich
Sent: Friday, March 05, 2004 6:39 PM
To: ORACLE-L (E-mail)
Subject: Why not set all sessions to resumable?
Hey all,
As I'm reading about the new (relatively speaking) features of 9i, I see the
"ALTER SESSION ENABLE RESUMABLE" statement. What's the catch? I haven't
been able to find out why you wouldn't set this on a process, or in some
cases, all user processes in an instance.
Why not? And where's this info?
TIA,
Rich
Rich Jesse System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
