Hi all
,
is sort are size a part of PGA ?
Rgds.
Arslan.
Yes. Note that when you use MTS, sort area is taken from the SGA,
specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not.
With a dedicated server, sort area is a part of the process address space.
On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote:
Hi all ,
is sort are
It comes out of the total memory of the server - separate from the shared pool - it is
allocated per session - if running parallel processes in a DSS environ. can quickly
consume memory avail. be wary wary careful.
-Original Message-
Mladen Gogala
Sent: Wednesday, January 14, 2004
http://www.ixora.com.au/q+a/0011/21013327.htm
http://www.ixora.com.au/newsletter/2000_11.htm#sort_area
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 19, 2003 6:34 AM
Saw your post on o racle.server. I didnt see the
Saw your post on o racle.server. I didnt see the article on ixora about
sort_area_size and PQ slaves? which one is it? So your saying if I set 500MB
sort_area_size and have 5 slaves? each slave can use an additional 1GB of
sort_area_size?
is that in otn docs? I didnt see it.
--
Please see the
Hello,
For an SGA of about 512MB and a 2GB database (total of the *.dbf) files.
Is 1MB sort area size enough?
Thank you for any tips.
ltiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
of the *.dbf) files.
Is 1MB sort area size enough?
Thank you for any tips.
ltiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Title: RE: using a lot of temporary tablespace with large sort area size
Guys,
Have 20Gb and 16CPUS available on host. Need to do large full-table scans/joins to create materialized view. Since I have to do the full-table scans of large tables - decided to use parallel query option
Paula,
With so much data, Oralce (or Oracle, if you prefer)
might be hash joining your tables and writing temp
hash segments.
What is your hash_area_size?
jack silvey
--- [EMAIL PROTECTED] wrote:
Guys,
Have 20Gb and 16CPUS available on host. Need to do
large full-table
scans/joins to
Title: RE: using a lot of temporary tablespace with large sort area size
What
about hash_area_size?
Paul x3704
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002
10:58 AMTo: Multiple recipients of list ORACLE-LSubject:
RE
Title: RE: using a lot of temporary tablespace with large sort area size
I would think that this is the most efficient way to join the data. BTW, Version is 8.1.7.2 of Oracle. The hash_area_size is
hash_area_size integer 8388608
Also, never see from top session more than 4 GB memory
Title: RE: using a lot of temporary tablespace with large sort area size
Guys,
Note:
Oracle does not recommend using the HASH_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas
This query will help to see type of sortfor 8i above
select user,segtype,extents from v$sort_usage;
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 07 Jun 2002 07:38:26 -0800
Paula,
With so much data, Oralce (or Oracle, if
Title: RE: using a lot of temporary tablespace with large sort area size
Man
significantly improved perf. by setting hash_area_size for session. Okay
so guyshave read in metalink says hash_area_size is 2* sort_area_size by
default - is this not true? Most be the case that it isn't
true
14 matches
Mail list logo