I want to know the information about the v$session. How this table is usefull for monitoring the User information.
Thanks in advance
V$session is the data dictionary view, which will give all the information about the users (oracle level) who are currently working with oracle.
This will be useful to identify locks, long running process,
to get the sid and serial# to kill a session etc.,
Trust this will serve ur needs.
srkumar , DBA
How we can find long process is running by a user or how to find out the locking identification
Check the following views
V$lock, v$lock_activity, v$lock_element, v$locked_object,
v$session_connect_info, v$session_wait, v$sesstat
you can get the detail description on the statistic# from v$statname.
to learn their structure in detail, do a describe
SQL> desc v$sesstat
Hope this would help you,
Life is a journey, not a destination!
You may wish to download a copy of toad from quest software which gives you this information without you needing to know where it comes from.
When you have it downloaded, give it some connection details for your db (Connect string, username and password) and you can grab session details, sql information etc at the click of a button.
PS. I dont work for quest! just like the product.
Toad schmoad. Don't give your money to a big corporate giant like Quest. Help out a little guy with a great product. EZSQL. [url]http://www.ezsql.net.[/url] :-)
Bah, more PC stuff. Doesn't anybody make a decent Solaris tool anymore?
If my day job ever involves development on Solaris, you can bet I'll make one! (That's how EZSQL came about, except with development Windows, not Solaris).
I am trying to get more info on all v$(views). I was advised to check out in oracle8i documentation, under sql reference quide on the net. Is't it available on the oracle documentation. If available, give me the link name ,
Follow these links in the 815 documentation :
1) Oracle 8i Server Release 815
2) Oracle 8i Reference
(scroll all the way down and you'll see them!)
Click Here to Expand Forum to Full Width