, 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
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
] 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
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
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
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
: 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
: 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
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
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
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
11 matches
Mail list logo