Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to find if a session is resumable

Re: how to find if a session is resumable

From: Thanh <thnguyen99_at_yahoo.com>
Date: 11 Mar 2004 06:09:47 -0800
Message-ID: <386645ad.0403110609.192cc0f9@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 Thu Mar 11 2004 - 08:09:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US