Hi All,
Yesterday night, temp tablespace size grow abnormally and its size is now 5.5 GB and it is taking my system space.
What steps I have to follow to release the space.
When I do the below queries.
a) SQL> select TABLESPACE_NAME,BYTES_USED,BYTES_FREE from v$temp_space_header;
TABLESPACE_NAME BYTES_USED BYTES_FREE
------------------------------ ---------- ----------
TEMP 6102712320 0
b) SQL> SELECT * FROM v$sort_usage;
no rows selected
c) SQL> SELECT * FROM V$SQLAREA WHERE ADDRESS='sqladress' ;
no rows selected
d) SQL> SELECT tablespace_name,
2 total_extents, used_extents, free_extents
3 FROM v$sort_segment;
TABLESPACE_NAME TOTAL_EXTENTS USED_EXTENTS FREE_EXTENTS
------------------------------- ------------- ------------ ------------
TEMP 5819 0 5819
Please suggest what step I have to follow and what will be impact with this condition.
Thanks,
SAL