Re: TOAD question re SQL sessions

That's pretty close, I wasn't expecting it there! I would have though this could have been in the Server Stats option.

Thanks again for you help.

Regards

Steve

Sybrand Bakker wrote:
>
> The option View Kill/Trace sessions will show the sessions and in a second
> panel their current sql and their current open cursors.
> Apart from that you can run all the statements you mention in Toad.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "Steve Salvemini" <steve.salvemini_at_adelaide.edu.au> wrote in message
> news:3A415779.22651F0D_at_adelaide.edu.au...
> > A couple of things I've had to run in SqlEdit so far, does anyone know
> > if I can query them in Toad in the Tuning area
> >
> > 1) I look up the active sessions and get the sid from the sessions tab,
> > then I want to look at the current sql running against this session
> >
> > ie. sid = 37 from Sessions Tab and then:
> >
> > select a.* from
> > v$sqlarea a, v$session s
> > where a.address=s.SQL_ADDRESS
> > and s.sid=37
> > order by first_load_time desc;
> >
> > How can I do this in toad
> >
> >
> > 2) Can I see which sql's are currently active, ie
> >
> > select * from v$session where status = 'ACTIVE'
> >
> > SGA Trace seems a bit limited in that it doesn't show it's status (ie
> > Active) and it doen't show what session it belongs to, and you can't
> > sort by anything useful. Am I missing something with this tool?

-- 
-----------------------------------------------------------

Steven Salvemini
Peoplesoft Technical Specialist, Information Technology Services
ADELAIDE UNIVERSITY SA 5005
AUSTRALIA
Tel: +61 8 8303 6358  Fax: +61 8 8303 4400
Email: steve.salvemini_at_adelaide.edu.au

----------------------------------------------------------- 
This email message is intended only for the addressee(s) 
and contains information which may be confidential and/or
copyright.  If you are not the intended recipient please
do not read, save, forward, disclose, or copy the contents
of this email. If this email has been sent to you in error,
please delete this email and any copies or links to this
email completely and immediately from your system.  No 
representation is made that this email is free of viruses.
Virus scanning is recommended and is the responsibility of 
the recipient.