Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to find if a session is resumable
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 Thu Mar 11 2004 - 08:09:47 CST