Re: parallel query

Prasath wrote:
How do I avoid the sort being written to disk? Which parameter needs
to be changed?

I am using Oracle 9iR2. Since the workarea_size_policy is set to AUTO,
all the _size parameters become redundant.

Statistics
----------------------------------------------------------
0 recursive calls
4 db block gets
343188 consistent gets
331539 physical reads
0 redo size
20273 bytes sent via SQL*Net to client
859 bytes received via SQL*Net from client
86 SQL*Net roundtrips to/from client
5 sorts (memory)
2 sorts (disk)
1263 rows processed

SQL> show parameters hash

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
hash_area_size integer 1048576
hash_join_enabled boolean TRUE
SQL> show parameters sort

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
nls_sort string
sort_area_retained_size integer 0
sort_area_size integer 1048576
SQL> show parameters pga

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
pga_aggregate_target big integer 2000000000
SQL> show parameters work

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
workarea_size_policy string AUTO


What is the query?
How much RAM is in the server?
What operating system?
What have you tried?
Why is this a problem?
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages