Set the DB_CACHE_ADVICE initialization parameter to READY to disable the advice collection feature temporarily. Setting this parameter to READY means that the advisory is turned off but the memory for the advisory remains allocated. Allocating the memory before the advisory is actually turned on, avoids the risk of an error when you switch the parameter to ON.
If the parameter is switched to this state from ON, the contents of the view are preserved and the memory for the advisory is retained.
If the parameter is switched to this state from OFF, you may get an error. Setting this parameter to OFF means that the advisory is turned off and the memory for the advisory is not allocated.
Download free practice test for Oracle RAC Certified Expert 10g exam. Download free practice test for Oracle Oracle Database 10g: Admin - II exam.If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.