Tablespace TEMP

This manual describes an overview of some sql scripts related to the ‘Tablespace TEMP’.

  • Installation of Oracle Enterprise Linux or other.
  • Installation of Oracle Database Server 10g/11g/12c.

The necessary software can be downloaded by clicking on the link(s) below.

  • n.a.



To check instance-wise total allocated, total used TEMP for both rac and non-rac

Total Used and Total Free Blocks

Temporary Tablespace groups

Block wise Check

To Check Percentage Usage of Temp Tablespace

To check Used Extents ,Free Extents available in Temp Tablespace

Additional checks

Changing the default temporary Tablespace

To add tempfile to Temp Tablespace

To resize the tempfile in Temp Tablespace

To find Sort Segment Usage by Users

To find Sort Segment Usage by a particular User

To find Total Free space in Temp Tablespace

To list all tempfiles of Temp Tablespace

To find Total Space Allocated for Temp Tablespace

Displays the amount of IO for each tempfile

  • n.a.

Please let me know if this manual ‘Scripts – Tablespace TEMP’ was usefull to you. If there are faults or you have suggestions regarding this manual, please let me know. No rights can be derived from this manual.



Maarten Schoonus

Leave a Reply