Finding free/used temporary table space in Oracle
If you’re a freak who work around with Oracle as backend, you would face the sitution where the oracle temporary space would be exhausted. The usage temporary tablespace can’t be found out exactly using DBA_FREE_SPACE. To find out the true value of temporary table space we may need to use V$TEMP_SPACE_HEADER data dictonary. SELECT tablespace_name, […]
Finding free/used temporary table space in Oracle Read More »