strange uga in 10.2.0.1

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 31 Jul 2007 18:20:15 +0700
Message-ID: <3edcb66e0707310420o384a7843qbd87c365150914dc@mail.gmail.com>

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
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 31 2007 - 06:20:15 CDT