AWS EC2 Oracle과 AWS RDS for Orace간 성능 비교 준비

기본환경

• 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
;

초기 데이터 적재 후