Sorting High Water Mark anywhere?
From: <Christopher.Taylor2_at_parallon.net>
Date: Fri, 25 Jan 2013 09:21:26 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856C3A6DFB_at_NADCWPMSGCMS10.hca.corpad.net>
I've been poking around and trying to put my hands on the information but I'm coming up empty. 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?
Date: Fri, 25 Jan 2013 09:21:26 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856C3A6DFB_at_NADCWPMSGCMS10.hca.corpad.net>
I've been poking around and trying to put my hands on the information but I'm coming up empty. 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?
I'd like to be able to determine, say over 24 hours, how much sorting is being done in memory, and how much is begin done on disk.
Thoughts?
Chris Taylor
Oracle DBA
Parallon IT&S
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2013 - 16:21:26 CET