Reg - V$SESSION
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Reg - V$SESSION

  1. #1
    Join Date
    Feb 2001
    Posts
    10

    Lightbulb

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    5
    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

  3. #3
    Join Date
    Feb 2001
    Posts
    10
    Thanks skumar...

    How we can find long process is running by a user or how to find out the locking identification

    Thanks again

    Sandeep

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  5. #5
    Join Date
    Mar 2001
    Posts
    5
    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.

  6. #6
    Join Date
    Nov 2000
    Posts
    344
    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

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Bah, more PC stuff. Doesn't anybody make a decent Solaris tool anymore?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Nov 2000
    Posts
    344
    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).

  9. #9
    Join Date
    Jan 2001
    Posts
    642
    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

  10. #10
    Join Date
    Nov 2000
    Posts
    344
    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
  •  



Click Here to Expand Forum to Full Width