Re: X$ksmsp (OSEE 10.2.0.2 on Solaris 8)

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 27 Jun 2006 20:46:33 -0400
Message-Id: <1151455593l.3170l.1l@medo.noip.com>

On 06/27/2006 10:30:11 AM, Schultz, Charles wrote:
> What is the alternative to track down memory issues? Sure, one could use
> DMA (Direct Memory Access), but I for one am not there yet. If there is
> a better way to diagnose and resolve memory issues, I am all ears (or
> rather, eyes *grin*).
>

Track what memory issues? Insufficient shared pool? Try with V$SGASTAT. PGA? Try with V$PROCESS_MEMORY. Buffer cache? Try with V$BUFFER_POOL_STATISTICS. What do you have in mind when you say "memory issues"? All those tables are well documented and stable.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 27 2006 - 19:46:33 CDT