Re: X$ksmsp (OSEE 10.2.0.2 on Solaris 8)
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: sac@xxxxxxxxxxxxx
- Date: Tue, 27 Jun 2006 20:46:33 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
