Oracle Caching

From #oracle this morning:

06:55 the PGA was set to 8Gb
06:55 which I recommended to be brought down to 2Gb
06:55 thought it would be enough
06:55 easy to check
06:56 just query the view v$pga_target_advice

06:58 you have to manually size the individual custom caches
06:58 it’s subtracted from the total sga
06:59 you can monitor where it takes the memory in v$sga_resize_ops

Published in: oracle on April 11, 2008 at2:27 pm Comments (0)


The URI to TrackBack this entry is: http://blog.une.edu.au/dsymons2/2008/04/11/hello-world/trackback/

RSS feed for comments on this post.

Leave a Comment

You must be logged in to post a comment.