Re: Temporary tablespace usage
From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Thu, 27 Mar 2014 12:22:22 +0200
Message-ID: <OFAF43A017.898A4597-ONC2257CA8.003884AC-C2257CA8.0038FAEF_at_seb.lt>
Date: Thu, 27 Mar 2014 12:22:22 +0200
Message-ID: <OFAF43A017.898A4597-ONC2257CA8.003884AC-C2257CA8.0038FAEF_at_seb.lt>
Sorry if it has been mentioned already:
for monitoring purpuses v$active_session_history has column TEMP_SPACE_ALLOCATED (starting with 11g)
Brgds, Laimis N
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2014 - 11:22:22 CET