HI,
From documentation
"With PGA_AGGREGATE_TARGET, sizing of work areas for all dedicated sessions is automatic and all *_AREA_SIZE parameters are ignored for these sessions."

The curious is when you create a database using the wizard from Oracle you find both parameters set

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=524288

The questions is:
Is this wrong, or this is useful.

Thanks

Hi,

Wow, good catch.

I don't think this is useful at all, and I would call it a bug.

It's never a good idea to introduce superflous parameters. . . .

If I were you, I could log an iTar and raise hell!

Thanks Mr. Burleson,
I'm don't think necessary to raise hell, I'm not the kind that tries to kill other people who made mistakes or uses wrongly a word, anyway I don't have metalink access.

Every time I investigate something I ask the more experts I can,
Tom Kyte gave this answer, what do you thing?
http://asktom.oracle.com/Please/ask/f?p=49...2972729023:::::

Hi.

What's your name? Please call me Don!

Tom's observation, as always, is correct:

"UNLESS you use shared server which did not support pga-aggregate
target and then sort_area_size/hash_area_size (which defaults based on sort area
size) will used."

However, in my experience, hardly anybody uses shared server (multi-threaded server MTS) anymore.

I disagree with this, though:

"in 10g, this changes - pga agg. tgt can be used for shared server and dedicated.
but setting the sort area size at that point is "harmless""

In my experience, setting an obsolete, do-nothing parameter can make life confusing, especially with the inter-ralationships between parameters settings. I like to keep-it-simple when possible!

Thanks Don

My name is Juan Carlos Reyes Pacheco

Hi Juan Carlos Reyes Pacheco,

Whew, that a mouthful!

May I just call you "Juan"?

Sorry I didn't read your reply, I read it searching for a comment about MTS is not used too frequently.

Yes, you can callme as you want, I am the guy that assign nicknames to all my friends so callme as you like, no problem

And thanks for your help, unless you don't agree I'll be trying to ask a question maximum daily at maximum.