Home » SQL & PL/SQL » SQL & PL/SQL » How to find sql statements executed in a session
How to find sql statements executed in a session [message #365791] Thu, 03 February 2000 09:29 Go to next message
Karthik
Messages: 63
Registered: February 2000
Member
Is it possible to find out all the sql statements that have been executed in a session from another session
Re: How to find sql statements executed in a session [message #365803 is a reply to message #365791] Sun, 06 February 2000 11:05 Go to previous messageGo to next message
Ales
Messages: 11
Registered: February 1999
Junior Member
Hi,

one easy way to obtain SQL statements for other sessions is with free version of T.O.A.D,
go to www.toadsoft.com.

Ales
Re: How to find sql statements executed in a session [message #365806 is a reply to message #365803] Mon, 07 February 2000 13:27 Go to previous messageGo to next message
KARTHIKR
Messages: 3
Registered: February 2000
Junior Member
IS IT POSSIBLE TO TRACE THE SQL STATEMNT EXECUTED IN STORED PROCEDURES,WHEN THESE ARE CALLED FROM FRONT END
Re: How to find sql statements executed in a session [message #365813 is a reply to message #365803] Mon, 07 February 2000 18:59 Go to previous message
Ales
Messages: 11
Registered: February 1999
Junior Member
Hi,

yes you can by selecting session for which you want a trace (you must be a DBA or have access to V$ views!). In addition to that you can easily access statistics and explain plan for each statement.

Ales
Previous Topic: Need to sum a char field in SQLPLUS
Next Topic: *URGENT** Cursor variables
Goto Forum:
  


Current Time: Tue Jun 22 00:30:51 CDT 2021