Re: how to find if a session is resumable

Arghh... you're right. I'm not sure why I thought that it wasn't the case. I just hope it was just a case of too many windows open, and not a sign of showing my age. Thanks, everyone, for your input.

thanh

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4051a319$0$20658$afc38c87_at_news.optusnet.com.au>...
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message
> news:4051923e$0$314$626a14ce_at_news.free.fr...
> >
> > "Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message de
> > 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.
> > >
> > <snip>
> >
> > Sorry for my wrong answer.
> > As i did not have a 9i db when i answered, i relied on my memory.
> > I should not have to. :-(
> >
> > Thanks
> > Michel Cadot
> >
>
> Not to worry! The greater mystery is why Thanh agreed with you!
>
> Regards
> HJR
Received on Fri Mar 12 2004 - 09:08:42 CST