RE: sizing sort_area_size

2003-09-19 Thread Mladen Gogala
, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: sizing sort_area_size I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? I believe that if LIOs to PIOs ratio

RE: sizing sort_area_size

2003-09-19 Thread Hitchman, Peter
Hi, Looking at v$sort_segment also can gve you a good idea of how much space you are using in your temporary tablespace, across the current uptime of the instance, assuming that it is a true temporary tablespace. Regards Pete -Original Message- Sent: 18 September 2003 23:35 To: Multiple

RE: sizing sort_area_size

2003-09-19 Thread Mladen Gogala
] On Behalf Of Hitchman, Peter Sent: Friday, September 19, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: sizing sort_area_size Hi, Looking at v$sort_segment also can gve you a good idea of how much space you are using in your temporary tablespace, across the current uptime

Re: sizing sort_area_size

2003-09-19 Thread Tanel Poder
ORACLE-L Subject: sizing sort_area_size I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? I believe that if LIOs to PIOs ratio improves with the SAME query

Re: sizing sort_area_size

2003-09-19 Thread Tanel Poder
That gives you only the current use of sort segments. The same applies to reasoning based on v$sort_usage and V$TEMP_SPACE_HEADER. The only True Way(TM) of tuning sorts is by using v$sysstat and v$sesstat values, I think tuning sorts based on in-memory sort vs not-in memory sort calculations

RE: sizing sort_area_size

2003-09-19 Thread Mladen Gogala
Subject: Re: sizing sort_area_size Hi! Just few additions about 9i's nice features for tuning sorts, hash joins other work area operations: SQL select n.name,s.value 2 from v$statname n,v$sesstat s 3 where n.statistic#=s.statistic# 4 and n.name like '%workarea executions

RE: sizing sort_area_size

2003-09-19 Thread Mladen Gogala
: sizing sort_area_size That gives you only the current use of sort segments. The same applies to reasoning based on v$sort_usage and V$TEMP_SPACE_HEADER. The only True Way(TM) of tuning sorts is by using v$sysstat and v$sesstat values, I think tuning sorts based on in-memory sort vs

Re: sizing sort_area_size

2003-09-19 Thread Tanel Poder
: sizing sort_area_size That gives you only the current use of sort segments. The same applies to reasoning based on v$sort_usage and V$TEMP_SPACE_HEADER. The only True Way(TM) of tuning sorts is by using v$sysstat and v$sesstat values, I think tuning sorts based on in-memory

sizing sort_area_size

2003-09-18 Thread rgaffuri
I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? I believe that if LIOs to PIOs ratio improves with the SAME query then sort_area_size has helped right?(notice Im not trying to improve

Re: sizing sort_area_size

2003-09-18 Thread Tanel Poder
I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? I believe that if LIOs to PIOs ratio improves with the SAME query then sort_area_size has helped right?(notice Im not trying to improve

Re: sizing sort_area_size

2003-09-18 Thread Ryan
can anyone recommend a good article managing sort_Area_size and understanding temp tablespace waits? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:34 PM I have been doing some alter sessions to improve performance