• Administration
  • Status
  • Session
  • Init Parameters
  • User
  • Roles
  • ASM
  • RAC 10gR2
  • Job Scheduler
  • Advanced Queues
  • Recycle bin
• Structure
  • Tablespace
  • Objects
  • Indexes
  • Files
  • Redo Logs
  • Undo
  • Constraints
  • Materialized view
  • Partitions
  • Triggers
• Performance
  • General
  • Locks DML
  • Locks DDL
  • Waits
  • Statistics
  • Query Tuning
  • Memory
  • Statspack
  • AWR
• Backup
  • DataGuard
  • RMAN
  • Import Export
  • Flashback
  • Datapump
• Miscellaneous
  • Useful UNIX
  • utl_file
• SQL*Net
  • tnsnames.ora
  • listener.ora

Performance - Memory

• SGA breakdown
  
• PGA usage by username
  
• Display pool usage
  

set lines 100 pages 999
col bytes format 999,999,999
compute	sum of bytes on pool
break 	on pool skip 1
select	pool
,	name
,	bytes
from 	v$sgastat
order 	by pool
,	name
/

select	st.sid "SID",
	sn.name "TYPE",
	ceil(st.value / 1024 / 1024) "MB"
from	v$sesstat st,
	v$statname sn
where	st.statistic# = sn.statistic#
and 	sid in	(select sid
		from v$session
		where username like '&user')
and	upper(sn.name) like '%PGA%'
order by st.sid,
	 st.value desc
/

select	name
,	sum(bytes)
from	v$sgastat
where	pool like 'shared pool'
group by name
/