OraFAQ Forum: SQL & PL/SQL » How to find sql statements executed in a session

Home » SQL & PL/SQL » SQL & PL/SQL » How to find sql statements executed in a session

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find sql statements executed in a session [message #365791]

Thu, 03 February 2000 09:29

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

Report message to a moderator

Re: How to find sql statements executed in a session [message #365803 is a reply to message #365791]

Sun, 06 February 2000 11:05

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

Report message to a moderator

Re: How to find sql statements executed in a session [message #365806 is a reply to message #365803]

Mon, 07 February 2000 13:27

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

Report message to a moderator

Re: How to find sql statements executed in a session [message #365813 is a reply to message #365803]

Mon, 07 February 2000 18:59

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:31:52 CDT 2024