Reg - V$SESSION

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.

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

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. http://www.ezsql.net. :-)

-John

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 ,
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