SQL Script TOP UGA Users

Updated: 04-Oct-2002
Version: 2.0

Description

Scripts displays detail so the sesion 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 rownum as rank, a.*
from (
    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 DESC) a
where rownum < 11
   ;

spool off

Related Links

Oracle 8: (SQL Script) TOP UGA Users

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