Re: SQLs consuming high TEMP space...
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Aug 2006 08:41:08 +0100
If you are using 9i, then you get some clues from
v$sql_workarea - columns max_tempseg_size and
last_tempseg_size give you an idea of space used,
xxx_executions give you an idea of how many times
space was needed and how it was used.
If you are using 10g, then the column direct_writes
in v$sql is a strong clue about use of temp for sort
and hash spilling.
Regards
Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
----- Original Message -----
From: "vikram singh" <vikramsingh120@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, August 15, 2006 8:29 AM
Subject: SQLs consuming high TEMP space...
Hi All,
What is the better way of finding out the Top-N SQLs that are consuming
high TEMP space...?
Thanks...
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.10/418 - Release Date: 14/08/2006
--
//www.freelists.org/webpage/oracle-l
Other related posts:
