Re: Sorting High Water Mark anywhere?

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 26 Jan 2013 09:24:06 -0800 (PST)
Message-ID: <1359221046.53148.YahooMailClassic_at_web184802.mail.gq1.yahoo.com>



> Is there a view in Oracle that will show a HWM for sort space used?
> The highest requested for memory, the highest fulfilled in memory,
> the highest sorted to disk?

V$sql_workarea can answer at least one of your questions: highest sorted to disk. Look at MAX_TEMPSEG_SIZE column. MAX_MEM_USED of v$sql_workarea_active may be "highest fulfilled in memory"

If your question is specific to sorting only, not usage of temp space in general (hashing, GTT, LOBs or any other use), then v$sql_workarea* or v$sort_usage (which is renamed to v$tempseg_usage probably for this reason) is not granular enough to answer your question.

Yong Huang

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 26 2013 - 18:24:06 CET

Original text of this message