Is there a way of working out the maximum out of temp capacity used
since a database was started.

I currently have a temp space of 3 60g temp files & would like to
remove one if possible


regards
Chris B

On Aug 26, 6:26*am, dba cjb <chris.br... (AT) providentinsurance (DOT) co.uk>
wrote:
Look at v$sort_segment and v$tempfile. If your database is using a
true temporary tablespace then it has only one sort segment per
instance and v$sort_segment will tell you the largest amount of temp
you have used since startup.

HTH -- Mark D Powell --