Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

basic query - v$sesstat

710236Jul 7 2011 — edited Jul 7 2011

Per document, the value column in view v$sesstat is "Statistics Value" (no other description listed - reasonable since there could be may parameters with different o/p values).

I am pulling out some numbers using a query from v$sesstat

statistics#                         value
----------------------------------- ------------
session pga memory                  117296
session pga memory max              117296
session uga memory                  38840
session uga memory max              43340

are the above values /numbers in bytes, KB, MB or any other unit?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2011

Added on Jul 7 2011

#general-database-discussions

2 comments

641 views