Temporary tablespace is always full

[Yogeeraj_1]

hi,

If you created your temporary tablespace using "create temporary tablespace...." and using LMTs....

Temporary tablespaces should appear "full" after a while in a normally running database. Extents are allocated once and then managed by the system. Rather than doing the rather expensive operation of "space management" (data dictionary updates), the system will allocate an extent in TEMP and then keep it and manage it itself. This is normal and to be expected and is not an indication that you do not have any temporary space.

You may wish to see the dynamic performance views V$SORT_USAGE and V$SORT_SEGMENT for more information regarding the usage of space within these temporary segments.

For instance, V$SORT_USAGE will tell you WHO is using WHAT.

hope this helps!

regards
Yogeeraj