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.
Click here to download rac-administrator-certified-experts-10g test study guide and practice question. Become Oracle Oracle Database 10g: Admin - II certified.
Like this article? Share it with others
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.
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.
