-
Hi...
I want to know the information about the v$session. How this table is usefull for monitoring the User information.
Thanks in advance
Sandeep
-
sandeep,
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
-
Thanks skumar...
How we can find long process is running by a user or how to find out the locking identification
Thanks again
Sandeep
-
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
ie
SQL> desc v$sesstat
Hope this would help you,
Sam
Thanx
Sam
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.
W.
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] :-)
-John
-
Bah, more PC stuff. Doesn't anybody make a decent Solaris tool anymore?
Jeff Hunter
-
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 ,
Thanks
Badrinath
-
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!)
-John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|