Home » SQL & PL/SQL » SQL & PL/SQL » Session Information & SQL Call
Session Information & SQL Call [message #211094] Tue, 26 December 2006 05:12 Go to next message
Messages: 9
Registered: November 2006
Location: KL, Malaysia
Junior Member

Hi, I need to know Session Information and all the SQl Calls but with out using Database connectivity.
OR can use database connectivity but all the sql calls should be logged.

Can we find out whether any running process is using Oracle Connectivity.

Re: Session Information & SQL Call [message #222908 is a reply to message #211094] Tue, 06 March 2007 23:13 Go to previous message
Messages: 19
Registered: April 2005
Junior Member
You can check program and process in v$session. Or look at v$process.

As for logging why dont you just 'set time on' and spool.
Previous Topic: delete case sensetive
Next Topic: External Tables
Goto Forum:

Current Time: Mon Aug 21 11:02:25 CDT 2017

Total time taken to generate the page: 0.04831 seconds