Help - Search - Members - Calendar
Full Version: WhY SETTING SORT_AREA_SIZE when using PGA_AGGREGAT
Oracle DBA Forums > Oracle > Oracle Forum
cachitogoku
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
burleson
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!
cachitogoku
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:::::
smile.gif
burleson
smile.gif

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!
cachitogoku
Thanks Don

My name is Juan Carlos Reyes Pacheco wink.gif
burleson
Hi Juan Carlos Reyes Pacheco,

Whew, that a mouthful!

May I just call you "Juan"?
cachitogoku
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.