strange uga in 10.2.0.1

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 31 Jul 2007 18:20:15 +0700

all,

i have 10.2.0.1 on HP-UX, and DSS type application

sga = 10g
pga = 12g

real memory = 32g

i found on AWR:
session pga memory                1,847,738,288          64,196.78          
485,991.13
session pga memory max           13,043,813,104         453,186.90        
3,430,776.72
session uga memory              ###############         70,139,299.76   
530,978,001.94
session uga memory max           10,566,090,216         367,102.29        
2,779,087.38

it seems that session uga memory is strange.... why so huge...
also sysadmin reported that OS memory was exhausted (only give some MB free)...

thanks for the sharing....


-- 
regards
ujang
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » strange uga in 10.2.0.1