Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Combine v$statname and v$mystat

SQL> SQL> select a.name, b.value   2    from v$statname a, v$mystat b   3   where a.statistic# = b.statistic#   4     and lower(a.name) like '%pga%'   5  / NAME                                                                  VALUE ---------------------------------------------------------------- ---------- session pga memory                                                  2464720 session pga memory max                                              2743892