Oracle Default Profile on RDS for Oracle
set linesize 200set pages 100col PROFILE for a20col LIMIT for a30SELECT * FROM DBA_PROFILES where PROFILE='DEFAULT&#...
2025-06
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...
English No Stupid Questions – 3. What Does It Mean to Be a “Hard Worker”?
Angela Duckworth & Stephen Dubner discuss the science of hard work & happiness on "No Stupid Questions." Explore if you're a hard worker and the U-shaped happiness curve.
Oracle About Timezone in RDS for Oracle
SQL> SELECT DBTIMEZONE FROM DUAL;DBTIME------+00:00SQL> SELECT VALUE FROM DBA_SCHEDULER_GLOBAL_ATTRIBUTE WHERE ATTRIBUTE...
Life in the UK イギリスで飲めるビール
London PrideLondon Prideは、フラーズ醸造所の代表的なアンバーエールで、1959年にロンドンのグリフィン醸造所で初めて醸造されました。特徴は、モルトの甘みと適度な苦味がバランスよく調和し、トフィーやビスケット、爽やかな...
Oracle Oracle Statspack on RDS
Oracle StatspackSetting up-- Execute as Master User-- Unlock UserALTER USER PERFSTAT IDENTIFIED BY pwd ACCOUNT UNLOCK;--...