v$sesstat

[san]

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

[naqi]

governor,

v$sesstat - session level statistics

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

[san]

Naqi ,

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

Thanks,
San

[naqi]

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.

[DaPi]

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