1. DBA_FREE_SPACE

DBA_FREE_SPACE visar information ledigt utrymme i tabellutrymmen:

SQL> DESC dba_free_space Name Null? Type ----------------------------------------- -------- ---------------------------- TABLESPACE_NAME VARCHAR2(30) FILE_ID NUMBER BLOCK_ID NUMBER BYTES NUMBER BLOCKS NUMBER RELATIVE_FNO NUMBER

2. Exempel 1: Kolla utrymme i ett tabellutrymme

I tabellutrymmet DP_EVENTHISTORY_INDEX finns följande ledigt utrymme:

SQL> select TABLESPACE_NAME , bytes from dba_free_space where tablespace_name = 'DP_EVENTHISTORY_INDEX'; TABLESPACE_NAME BYTES ------------------------------ ---------- DP_EVENTHISTORY_INDEX 41943040