Home » SQL & PL/SQL » SQL & PL/SQL » v$ view
v$ view [message #155858] Wed, 18 January 2006 23:47 Go to next message
Messages: 26
Registered: January 2006
Junior Member

When I query V$session,i am able to find oracle programs connected eg:Toad.exe,sqlplus.exe.I want to find if any Asp.Net users are logged on to session.
Also i need to find what query is being executed by web page.
How do i query the same?

Re: v$ view [message #235453 is a reply to message #155858] Sun, 06 May 2007 04:04 Go to previous message
Messages: 242
Registered: February 2006
Senior Member
1)For finding name of the program in the sessions, Your program must give to oracle his name(not every program give them - you must specify this in program).
2)To see what SQL are executing Your session, You must to select hash_values vrom V$SESSION and run this select:
select sql_text
from v$sqltext
where hash_values='your_hash_values'
order by piece

This select will return some number of row - after splitting them You will receive SQL select running by Your program.
Previous Topic: Adding new LOB column
Next Topic: query:move data from one database to another
Goto Forum:

Current Time: Fri Jul 21 05:47:27 CDT 2017

Total time taken to generate the page: 0.36053 seconds