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.


Jonathan Lewis

The Co-operative Oracle Users' FAQ

Cost Based Oracle: Fundamentals

----- 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...?



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


Other related posts: