-
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
-
governor,
v$sesstat - session level statistics
session - established for a client program connecting to oracle - assigned an id - called sid - session id
-
Naqi ,
Thanks for the reply but what is Value column in the table.
Thanks,
San
san
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|