select sum(value) || ' bytes' "total session memory" -- X
from v$sesstat,v$statname
where name='session uga memory'
and v$sesstat.statistic#=v$statname.statistic#

large_pool_size > X

if you have Rman , you must add delta to large_pool_size

-----Message d'origine-----
De : Dustin Hayden [mailto:oracledba-ezmlmshield-x9675864.[Email address protected]
Envoyé : jeudi 1 juin 2006 14:00
À : LazyDBA Discussion
Objet : large pool

How can you tell if your large pool is being used efficiently?



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page