Japanese Foods
麻布十番周辺で行きたいレストラン
Tech
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
-- Estimate SQL PlanEXPLAIN PLAN FOR SELECT * FROM tbl1;SELECT * FROM TABLE (DBMS_XPLAN.DISPLAY);-- set STATISTICS_LEVEL...
Tech Amazon Linux 2：Clientのインストール
Oraclecurl -o oracle-instantclient19.18-sqlplus-19.18.0.0.0-1.x86_64.rpm curl -o oracle-instantclient19.18-basic-19.18.0...
Tech 表領域確認SQL
表領域確認SET LINESIZE 200-- 表領域設定確認(サイズ、自動拡張、Maxサイズ、拡張サイズ)SELECT TABLESPACE_NAME , BYTES/1024/1024 MB_SIZE , AUTOEXTENSIBLE ...