Re: how to find if a session is resumable

"Paul Drake" <drak0nian_at_yahoo.com> wrote in message news:1ac7c7b3.0403120949.31d8229d_at_posting.google.com... > "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<40518ad9$0$3953$afc38c87_at_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

>
> Howard,
>
> you forgot the following:
>
> revoke dba from scott;
>
> Paul

LOL! I was being a bit naughty there, I, er, grant you. Regards
HJR Received on Fri Mar 12 2004 - 13:54:40 CST