Some consideration too:
db_block_size > 8K (this has to be set
when the database was created)
You need to have this setup
to: db_file_multiblock_read_count
(as I high as Possible)
bitmap_merge_area_size
create_bitmap_area_size
hash_area_size
sort_area_size
Your temporary tablespace: initial = next =
multiple of sort_area_size (i.e: 2* 100MB if your
sort_area_size is 100 MB)
Regis
********************************************************************* This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ********************************************************************** |
- SORT_AREA_SIZE question Bart Kersteter
- RE: SORT_AREA_SIZE question David Wagoner
- RE: SORT_AREA_SIZE question Nigel Bishop
- RE: SORT_AREA_SIZE question DENNIS WILLIAMS
- RE: SORT_AREA_SIZE question Farnsworth, Dave
- Re: SORT_AREA_SIZE question Darrell Landrum
- RE: SORT_AREA_SIZE question Regis Biassala
- RE: SORT_AREA_SIZE question Rajesh . Rao
- Re: SORT_AREA_SIZE question Tanel Poder
- Re: SORT_AREA_SIZE question Tanel Poder
- RE: SORT_AREA_SIZE question Bart Kersteter
- RE: SORT_AREA_SIZE question DENNIS WILLIAMS
- RE: SORT_AREA_SIZE question John Kanagaraj
- RE: SORT_AREA_SIZE question Rajesh . Rao
- Re: SORT_AREA_SIZE question Tanel Poder
- Re: SORT_AREA_SIZE question Binley Lim
- Re: SORT_AREA_SIZE question Rajesh . Rao