Home » SQL & PL/SQL » SQL & PL/SQL » SQL text using SID (10.2.0.2.0 ,windows)
SQL text using SID [message #428943] Sat, 31 October 2009 01:17 Go to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member

Hi all,

How to find the user and the SQL text query that he is using ,by knowing session id in SQLPLUS ?

Can anybody answer for this?


Regards,
Re: SQL text using SID [message #428947 is a reply to message #428943] Sat, 31 October 2009 01:28 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
v$session

v$sql

regards,
Delna
Re: SQL text using SID [message #428954 is a reply to message #428947] Sat, 31 October 2009 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
delna.sexy wrote on Sat, 31 October 2009 07:28
v$session

v$sql

regards,
Delna

...and join both on sql_id.

Regards
Michel

Re: SQL text using SID [message #428989 is a reply to message #428954] Sat, 31 October 2009 10:58 Go to previous message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member


Thanks for your hints.
I got the query based on your hints.

Regards,
Previous Topic: Query
Next Topic: Create a user and give full previlages only for that schema
Goto Forum:
  


Current Time: Sat Dec 03 18:04:27 CST 2016

Total time taken to generate the page: 0.11639 seconds