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

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.