Database Sync

Swingbench Benchmark Configuration

Swingbench Results

Case#1

 Case #2

Case #3

결론

참고만 하면 될 것 같다.

기본환경

• Oracle Database Version : Oracle Database EE 19c + RU19.14
• Oracle Database Type : Single
• AWS EC2 Instacne Type : r5.large (DB Instance Name : TEST)
• AWS RDS Instacne Type : db.r5.large (DB Instance Name : RDSTST)
• 성능 Test Tool : Swingbench

select instance_name, version_full, archiver, database_type from v$instance;

주요 Parameter 비교

select name, value
from v$spparameter
where value is not null
and name like '%target' or name = 'processes' or name = 'open_cursors'
order by 2
;

Swingbench로 초기 Data 적재 전/후 Tablespace 비교

초기 데이터 적재 전

select ddf.tablespace_name, ddf.file_name, round(ddf.bytes/1024/1024,2) MB, ddf.autoextensible, ddf.increment_by, dts.bigfile
from dba_data_files ddf, dba_tablespaces dts
where ddf.tablespace_name =  dts.tablespace_name
;

초기 데이터 적재 후

Default Tablespace Type

select * from DATABASE_PROPERTIES
where property_name='DEFAULT_TBS_TYPE'
;

AWS RDS for Oracle 생성 후 생성된 Tablespace 목록

select ddf.tablespace_name, ddf.file_name, round(ddf.bytes/1024/1024,2) MB, ddf.autoextensible, ddf.increment_by, dts.bigfile
from dba_data_files ddf, dba_tablespaces dts
where ddf.tablespace_name =  dts.tablespace_name
;

Big Tablespace와 Small Tablespace 생성

--기본값이 Bigfile인 관계로 Bigfile로 생성
CREATE TABLESPACE bigfiletest1 DATAFILE SIZE 1G AUTOEXTEND ON MAXSIZE 10G ;

CREATE BIGFILE TABLESPACE bigfiletest2 DATAFILE SIZE 1G AUTOEXTEND ON MAXSIZE 10G ;

--Smallfile을 명시하면 Smallfile로 생성 됨
CREATE SMALLFILE TABLESPACE smaillfiletest2 DATAFILE SIZE 1G AUTOEXTEND ON MAXSIZE 10G ;

select ddf.tablespace_name, ddf.file_name, round(ddf.bytes/1024/1024,2) MB, ddf.autoextensible, ddf.increment_by, dts.bigfile
from dba_data_files ddf, dba_tablespaces dts
where ddf.tablespace_name =  dts.tablespace_name
;

Default Tablespace Type을 Small file로 변경 (안됨)

alter database set default SMALLFILE tablespace;