Re: how to find if a session is resumable

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 12 Mar 2004 21:02:56 +1100
Message-ID: <40518ad9$0$3953$afc38c87@news.optusnet.com.au>

I'm not sure what Michael was getting at, but dba_resumable clearly shows an entry for a session immediately after it issues the 'alter session resumable' statement, regardless of whether or not that session is doing anything.

True, the values for start time, suspend time and resume time are null unless the session has actually undergone suspension and resumption, but if you just want to know what sessions have requested resumable operations, even if they aren't performing the operations yet, then dba_resumable is reliable.

Checked in 9i and 10g, here's a quick test (the test happens to come from 9i):

SQL> grant dba to scott;

Grant succeeded.

SQL> connect scott/tiger
Connected.
SQL> alter session enable resumable;

Session altered.

---

Immediately in another session

---

SQL> select user_id, session_id, status, timeout from dba_resumable;

   USER_ID SESSION_ID STATUS TIMEOUT ---------- ---------- --------- ----------

        24 7 NORMAL 7200 Regards
HJR "Thanh" <thnguyen99_at_yahoo.com> wrote in message news:386645ad.0403110609.192cc0f9_at_posting.google.com...
> Thanks for the info. I knew about the dba_resumable, but like you
> said, it only shows statements that are currently executing. I had
> thought that since you use 'alter session' to enable resumable, that
> there would be a view that tracked this as well.
>
> thanh
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:<404f6d90$0$281$626a14ce_at_news.free.fr>...
> > "Thanh" <thnguyen99_at_yahoo.com> a écrit dans le message de
> > news:386645ad.0403101041.485e5f99_at_posting.google.com...
> > > Hi, all,
> > >
> > > I'm playing around with resumable sessions, and trying to figure out
> > > if there's any way to tell if a particular session is resumable. I've
> > > gone through Metalink and Google groups, but haven't found anything
> > > yet. Thanks in advance.
> > >
> > > thanh
> >
> > DBA_RESUMABLE.
> > btw, it's not a session that is resumable but an operation, so there is
a row in this
> > view only if a statement is currently executed.
> >
> > Regards
> > Michel Cadot
Received on Fri Mar 12 2004 - 04:02:56 CST