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
nksnare
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.

Regards,
NKS
Re: Session Information & SQL Call [message #222908 is a reply to message #211094] Tue, 06 March 2007 23:13 Go to previous message
ptgeorge
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: Oracle 9i UTL_SMPT gives different send time to actual send date
Next Topic: PLS-00103: Encountered the symbol "CREATE"
Goto Forum:
  


Current Time: Tue Dec 06 08:41:25 CST 2016

Total time taken to generate the page: 0.12505 seconds