Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> pga_aggregate_target plus sort_area_size set in init.ora

pga_aggregate_target plus sort_area_size set in init.ora

From: Johannes <johannes_at_merckle.de>
Date: Wed, 30 Jun 2004 12:49:13 +0200
Message-ID: <2kfk5aF1oqsqU1@uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US