Question on the buffer cache
Hi All,
I have a problem that many of you may have already encountered and am looking to ways to either find a solution or an alternate.
We have an environment that has 12 gigs of buffer cache and 6 gigs of pga_aggregate_target. THis is a non-prod system and there are 4 sets of application schemas. They are all identical but one of them is meant for perf tests, one is just a dummy(no real action there), one is cvs related(again not much action there), and the last one is meant for purely tuning purposes. I am using the last mentioned schema.
I have a problem that many of you may have already encountered and am looking to ways to either find a solution or an alternate.
We have an environment that has 12 gigs of buffer cache and 6 gigs of pga_aggregate_target. THis is a non-prod system and there are 4 sets of application schemas. They are all identical but one of them is meant for perf tests, one is just a dummy(no real action there), one is cvs related(again not much action there), and the last one is meant for purely tuning purposes. I am using the last mentioned schema.
0