Quotidien Shaarli

Tous les liens d'un jour sur une page.

February 6, 2020

How to Shrink Temp Tablespace and Reclaim Unused Space in Oracle - orahow

Shrink TEMP Tablespace using alter tablespace command
SQL> ALTER TABLESPACE temp SHRINK SPACE KEEP 50M;.

Shrink TEMPFILE using alter tablespace command
SQL> ALTER TABLESPACE temp SHRINK TEMPFILE '/u01/app/oracle/oradata/TEST11G/temp01.dbf' KEEP 40M;

Shrink TEMP Tablespace to the smallest possible size:
SQL> ALTER TABLESPACE temp SHRINK SPACE;

tablespace TEMP enorme 33 Go et plein a 100% - Administration Oracle

SELECT pid FROM v$process
WHERE addr =
(
SELECT paddr FROM v$bgprocess
WHERE name = 'SMON'
);

ORADEBUG WAKEUP 6