v$sesstat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: v$sesstat

  1. #1
    Join Date
    Jan 2002
    Posts
    16

    v$sesstat

    Hi All ,

    Can anybody elaborate on this view ? I get large numberss in the value column for some of the sid's . What is this value ? It is related to the memory but what should I interpret if its value is high ?

    Thanks,
    San
    san

  2. #2
    Join Date
    Jul 2003
    Posts
    30
    governor,

    v$sesstat - session level statistics

    session - established for a client program connecting to oracle - assigned an id - called sid - session id

  3. #3
    Join Date
    Jan 2002
    Posts
    16
    Naqi ,

    Thanks for the reply but what is Value column in the table.

    Thanks,
    San
    san

  4. #4
    Join Date
    Jul 2003
    Posts
    30
    v$sesstat contains statistics related to the various sessions for the oracle database.

    One such statistic is physical reads , the value column will tell you how many physical reads have taken place.

    The value column is used to quantify the statistic.

    Go to otn.technet.com, check out the documentation section for the oracle database, there is a manual called: 'reference manual' . This will detail the info your looking for.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    You need to join this view with v$statname to get something meaningful. RT_M: http://www.csee.umbc.edu/help/oracle.../ch3.htm#10059

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