Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> pga_aggregate_target plus sort_area_size set in init.ora
Hi all!
I hava an installation of Oracle 9.2 with pga_aggregate_target set in
init.ora.
As this parameter replaces e.g. sort_area_size and hash_area_size and other
pga relevant parameters in init.ora (in dedicated server systems),
I don't know why my predecessor let this parameters set in init.ora.
They seem to be used setting this memory pools, becaus using "show parameter
xxx"
prompts the assigned values.
I think I have to delete this parameters (sort_area_size,... and all other
pga relevant parameters)
to handle pga_aggregate_target correct.
What do you think about?
Thank you all!
Johannes Received on Wed Jun 30 2004 - 05:49:13 CDT