Storage parametri kod kreiranja objekata - Storage and Data Blocks

Storage parametri kod kreiranja objekata - Space & Data Blocks

CREATE TABLESPACE (SPACE MANAGEMENT AUTO&MANUAL)

CREATE TABLESPACE - EXTENT MANAGEMENT LOCAL SPACE MANAGEMENT AUTO

CREATE TABLESPACE - EXTENT MANAGEMENT LOCAL SPACE MANAGEMENT MANUAL

CREATE TABLE (SPACE MANAGEMENT AUTO&MANUAL)

SEGMENT SPACE MANAGEMENT AUTO NO STORAGE PARAMETERS

SEGMENT SPACE MANAGEMENT MANUAL NO STORAGE PARAMETERS

SEGMENT SPACE MANAGEMENT MANUAL - STORAGE PARAMETERS SPECIFIED

SEGMENT SPACE MANAGEMENT AUTO - STORAGE PARAMETERS SPECIFIED

DICTIONARY INFORMATION

User_Tables

Dba_Extents

Oracle Enterprise Manager

SEGMENT SPACE MANAGEMENT AUTO NO STORAGE PARAMETERS

SEGMENT SPACE MANAGEMENT MANUAL NO STORAGE PARAMETERS

SEGMENT SPACE MANAGEMENT MANUAL - STORAGE PARAMETERS SPECIFIED

SEGMENT SPACE MANAGEMENT AUTO - STORAGE PARAMETERS SPECIFIED

CREATE TABLESPACE (SPACE MANAGEMENT AUTO&MANUAL)

CREATE TABLESPACE - EXTENT MANAGEMENT LOCAL SPACE MANAGEMENT AUTO

CREATE SMALLFILE TABLESPACE "TEST"

DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\GLOB\test' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED

LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

CREATE TABLESPACE - EXTENT MANAGEMENT LOCAL SPACE MANAGEMENT MANUAL

CREATE SMALLFILE TABLESPACE "MANUAL_SEG_MAN"

DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\GLOB\MANUAL_SEG_MAN' SIZE 20M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED

LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT MANUAL

CREATE TABLE (SPACE MANAGEMENT AUTO&MANUAL)

SEGMENT SPACE MANAGEMENT AUTO NO STORAGE PARAMETERS

TABLE Storage_analyse3

CREATE TABLE Storage_analyse3

(adress_id NUMBER(2),

adress_name VARCHAR2(14))

TABLESPACE TEST

-- NO STORAGE PARAMETERS LOCAL SEGMENT SPACE MANAGEMENT AUTO

SEGMENT SPACE MANAGEMENT MANUAL NO STORAGE PARAMETERS

TABLE Storage_analyse2

CREATE TABLE Storage_analyse2

(adress_id NUMBER(2),

adress_name VARCHAR2(14))

TABLESPACE MANUAL_SEG_MAN

-- NO STORAGE PARAMETERS LOCAL SEGMENT SPACE MANAGEMENT MANUAL

SEGMENT SPACE MANAGEMENT MANUAL - STORAGE PARAMETERS SPECIFIED

TABLE Storage_analyse1

CREATE TABLE Storage_analyse1

(adress_id NUMBER(2),

adress_name VARCHAR2(14))

TABLESPACE MANUAL_SEG_MAN

PCTFREE 40 PCTUSED 50

STORAGE

(INITIAL

100K NEXT 50K

MINEXTENTS 2

MAXEXTENTS 50 PCTINCREASE 5) -- storage parameters LOCAL SEGMENT SPACE MANAGEMENT MANUAL

SEGMENT SPACE MANAGEMENT AUTO - STORAGE PARAMETERS SPECIFIED

TABLE Storage_analyse

CREATE TABLE Storage_analyse

(adress_id NUMBER(2),

adress_name VARCHAR2(14))

TABLESPACE TEST

PCTFREE 40

STORAGE

(INITIAL 100K

NEXT 50K

MINEXTENTS 2

MAXEXTENTS 50 PCTINCREASE 5); -- storage parameters LOCAL SEGMENT SPACE MANAGEMENT AUTO

DICTIONARY INFORMATION

User_Tables

SQL> select TABLE_NAME, TABLESPACE_NAME, PCT_FREE, PCT_USED, INI_TRANS,INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS from user_tables

order by TABLE_NAME desc

TABLE_NAME TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ------------------------------ ---------- ---------- ---------- -------------- ----------- -----------

STORAGE_ANALYSE3 TEST 10 1 65536 1

STORAGE_ANALYSE2 MANUAL_SEG_MAN 10 40 1 65536 1

STORAGE_ANALYSE1 MANUAL_SEG_MAN 40 50 1 163840 1

STORAGE_ANALYSE TEST 40 1 163840 1

Dba_Extents

SQL> select count(*), SEGMENT_NAME,sum(bytes) from dba_extents

where owner='TEST'

group by SEGMENT_NAME

order by SEGMENT_NAME desc

COUNT(*) SEGMENT_NAME SUM(BYTES)

---------- --------------------------------------------------------------------------------- ----------

1 STORAGE_ANALYSE3 65536

1 STORAGE_ANALYSE2 65536

3 STORAGE_ANALYSE1 196608

3 STORAGE_ANALYSE 196608