Re: how to find if a session is resumable

"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

> "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 - 11:49:22 CST