Thanks Steve, monitor was what I had in mind but I think I actually need to
set sql_trace for the whole instance since it looks like the ability to
trace another users session only came in in 7.1 or 7.2 :(.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:uqvpk285n9dg4d_at_corp.supernews.com...
> I unfortunately date back to then.
> If I remember, correctly besides sqltrace we had the old estat and bstat.
> But, also the SQLDBA monitor had a session monitor feature
> where you could select a SID to monitor. Crude but effective.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> Author of: 'So You Want to be an Oracle DBA?'
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3dafc23a$0$1292$ed9e5944_at_reading.news.pipex.net...
> > Should one (not so hypothetically) wish to go about tracing an
individual
> > client session in Oracle 6.0.36, what tracing tools were available then.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> >
> >
>
>
Received on Fri Oct 18 2002 - 06:16:52 CDT
