SQL Script TOP UGA Users

Updated: 04-Oct-2002
Version: 1.0

Description

Scripts displays detail so the session which are using the most UGA (User Global Area)

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

col sid form 999 heading "SID"
col program form a30 heading "Program"
col ugastat form 999,999,999,999
col maxugastat form 999,999,999,999

spool topuga.lst

SELECT v1.sid, program, v1.value ugastat, v2.value maxugastat
    FROM v$statname s1, v$statname s2, v$sesstat v1, v$sesstat v2, v$session sess
   WHERE s1.name = 'session uga memory'
     and s2.name = 'session uga memory max'
     and sess.sid = v1.sid
     and v1.statistic#=s1.statistic#
     and v2.statistic#=s2.statistic#
     and v1.sid=v2.sid
     and v1.value>0
   ORDER BY v2.value 
   ;

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links