Oracle Sqlplus-5. USER_EXTENTS에 대해 알아 보겠습니다.

5. USER_EXTENTS

[예1] USER_EXTENTS의 구조를 확인한다.

SQL> DESC USER_EXTENTS;

[예2] DBA_DATA_FILES에서 각 TABLE의 SPACE의 SIZE를 구한다.

SQL> SELECT SUBSTR(FILE_NAME,1,40), BYTES, SUBSTR(TABLESPACE_NAME,1,20)

2* FROM DBA_DATA_FILES;

[예3]

SQL> SELECT *

2 FROM V$SGA;

[예4]

SQL> SELECT SEGMENT_NAME, TABLESPACE_NAME

2 FROM DBA_ROLLBACK_SEGS;

[예4]

SQL> DESC DBA_ROLLBACK_SEGS

[예5]

SEGMENT_NAME TABLESPACE_NAME

—————————— ——————————

SYSTEM SYSTEM

BRBS01 BRBS

RBS01 RBS

RBS02 RBS

RBS03 RBS

RBS04 RBS

BRBS01 BRBS

7 rows selected.

[예6]

SQL> SELECT SUM(BYTES)

2 FROM DBA_FREE_SPACE

3 WHERE

4 TABLESPACE_NAME=’USER_DATA’;

[예7]

SQL> SELECT BYTES

2 FROM DBA_FREE_SPACE

3 WHERE

4* TABLESPACE_NAME=’USER_DATA’

[예8]

SQL> DESC DBA_FREE_SPACE

[예9]

SQL> SELECT TABLESPACE_NAME

2 FROM DBA_FREE_SPACE;

[예10]

SQL> SELECT TABLESPACE_NAME

2 FROM DBA_FREE_SPACE;

[예11]

SQL> SELECT SUM(BYTES)

2 FROM DBA_FREE_SPACE

3 WHERE

4 TABLESPACE_NAME =’BUSINESS’;

[예12]

SQL> SELECT SUM(BYTES)

2 FROM DBA_FREE_SPACE

3 WHERE

4 TABLESPACE_NAME=’BINDEX’;