Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To view sql text ,PLAN_HASH_VALUE ,SQL_ID information

916413Feb 9 2012 — edited Feb 9 2012

Hi,

Below query gives me user information. I would also like to know the sql text ,PLAN_HASH_VALUE ,SQL_ID information for each of this below sid

select sid,serial#,username,status,osuser,machine,module,EVENT,logon_time from v$session where username='EFTUSER';

SID	SERIAL#	USERNAME	STATUS	OSUSER	MACHINE	MODULE	LOGON_TIME
2,719	35,384	EFTUSER	SNIPED	ASPNET	BELL\XVU-TOR-PWEBNET	aspnet_wp.exe	02-08-2012 15:00:22
2,737	53,279	EFTUSER	SNIPED	ASPNET	BELL\XVU-TOR-PWEBNET	aspnet_wp.exe	02-08-2012 15:00:22
2,845	40,655	EFTUSER	SNIPED	ASPNET	BELL\XVU-TOR-PWEBNET	aspnet_wp.exe	02-08-2012 13:36:02
2,910	21,714	EFTUSER	SNIPED	ASPNET	BELL\XVU-TOR-PWEBNET	aspnet_wp.exe	02-08-2012 13:32:26

thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2012

Added on Feb 9 2012

#general-database-discussions

7 comments

6,323 views