** unset pga_aggregate_target

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Tue, 8 Apr 2008 17:03:22 -0700 (PDT)
Message-ID: <400280.69502.qm@web58013.mail.re3.yahoo.com>

Hi,

     I set pga_aggregate_target dynamically by setting pga_aggregate_target to a value and set workarea_size_policy. Now as I try to unset it : I am not able to set it to 0 like before. I have set workarea_size_policy to MANUAL. Does this mean it is back to the way it was before? Any other action to take? Is bounce of database needed? Any other way to verify that it is indeed not set and not functional? Thanks for help.              

---

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 08 2008 - 19:03:22 CDT