Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why all "estd_overalloc_count" values are zero from pga_target_advice?

550502Mar 18 2011 — edited Mar 18 2011

Hi,
I am triying to change pga_aggregate_target . First i want to look at Oracle advice.
So I used this query:

SELECT ROUND(pga_target_for_estimate/1024/1024) target_mb,
estd_pga_cache_hit_percentage cache_hit_perc,
estd_overalloc_count
FROM v$pga_target_advice;

Output:

2500	100	0
5000	100	0
10000	100	0
15000	100	0
20000	100	0
24000	100	0
28000	100	0
32000	100	0
36000	100	0
40000	100	0
60000	100	0
80000	100	0
120000	100	0
160000	100	0

All estd_overalloc_count values is 0?

My oracle database have got 6 tablespace. And active Tablespaces "Size" and "Used" values is 26.6 GB. (Usage=100%)

Oracle Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

Thanks in advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2011

Added on Mar 18 2011

#general-database-discussions

2 comments

662 views