Oracle Default Profile on RDS for Oracle
set linesize 200set pages 100col PROFILE for a20col LIMIT for a30SELECT * FROM DBA_PROFILES where PROFILE='DEFAULT&#...
Tech
Oracle 
AWS How to check minor version upgrade targets
Finding automatic minor version upgrade targetsaws rds describe-db-engine-versions \ --engine <Engine> \ --engine-versio...
MySQL The basics of InnoDB space file layout を日本語で読む
Source:The basics of InnoDB space filelayoutThe physical structure of InnoDB index pagesInOn learning InnoDB: A journey ...
MySQL MySQL Basic – File Space Management
17.11.2 File Space ManagementTablespcaeTablespcae は ibdata1、ibdata2などの物理ファイルで構成される。各テーブルスペースは、データベースページで構成される。-- Aurora ...
MySQL An In-Depth Analysis of Buffer Pool in InnoDB を日本語で読み解く
An In-Depth Analysis of Buffer Pool in InnoDBBy Kang Wang1. PrefaceBuffer Pool is a vital component of InnoDB and one of...
Oracle Read Replica on RDS for Oracle
Archived redo log retentionIf a primary DB instance has no cross-Region read replicas, Amazon RDS for Oracle keeps a min...
Oracle About Timezone in RDS for Oracle
SQL> SELECT DBTIMEZONE FROM DUAL;DBTIME------+00:00SQL> SELECT VALUE FROM DBA_SCHEDULER_GLOBAL_ATTRIBUTE WHERE ATTRIBUTE...
Oracle Oracle Statspack on RDS
Oracle StatspackSetting up-- Execute as Master User-- Unlock UserALTER USER PERFSTAT IDENTIFIED BY pwd ACCOUNT UNLOCK;--...
Oracle SQL queries related to REDO logs
checking REDO Log file size and pathset linesize 200col MEMBER for a80SELECT l.group# , l.status , l.bytes/1024/1024 AS ...
Oracle Using EXPLAIN to obtain the execution plan
How to get execution plan of Oracle Database