oracle 新_多种块大小的支持9i

oracle 新_多种块大小的支持

conn sys/sys as sysdba
SHOW PARAMETER CACHE

ALTER SYSTEM SET DB_CACHE_SIZE=16M;
ALTER SYSTEM SET DB_4K_CACHE_SIZE=8M;

CREATE TABLESPACE K4 DATAFILE 'F:\ORACLE\ORADATA\ZL9\K4.DBF' SIZE 2M BLOCKSIZE 4K;
CREATE TABLE SCOTT.A1 TABLESPACE K4 AS SELECT * FROM SCOTT.DEPT;

SELECT BYTES, BLOCKS FROM DBA_EXTENTS WHERE SEGMENT_NAME='A1';

drop tablespace k4 including contents and datafiles;