Re: Question about shrinking sga_target.
From: Dion Cho <ukja.dion_at_gmail.com>
Date: Thu, 1 May 2008 18:09:03 -0700 (PDT)
Message-ID: <1dc366fc-d4fd-4514-8962-1d1b50dec688@l17g2000pri.googlegroups.com>
Date: Thu, 1 May 2008 18:09:03 -0700 (PDT)
Message-ID: <1dc366fc-d4fd-4514-8962-1d1b50dec688@l17g2000pri.googlegroups.com>
Wouldn't it better to post the curren status of your SGA?
Like...
sql> show sga sql> show parameter sga sql> select component, current_size,min_size,max_size
from v$sga_dynamic_components;
...
Dion Cho Received on Thu May 01 2008 - 20:09:03 CDT