Oracle Architecture
Memory Management
Tablespace Utilization
Temporary tablespace
Locks
Tracing
Expdp / Impdp
Undo and rollback segments
Log locations
Diagnostics alert : /u01/app/oracle/diag/rdbms/test2/<instanceid>/trace
Listener static and dynamic service registration
Table size
Scheduler,Program and Jobs
12c
Encryption :
Allows sensitive data to be encrypted within the datafiles to prevent access to it from the operating system.
ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE)(METHOD_DATA=
(DIRECTORY=/u01/app/oracle/admin/DB10G/encryption_wallet/)))
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "myPassword";
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "myPassword";
CREATE TABLE tde_test (
id NUMBER(10),
data VARCHAR2(50) ENCRYPT
)
TABLESPACE tde_test;
SELECT * FROM dba_encrypted_columns;
CREATE TABLESPACE OBE DATAFILE '/u01/app/oracle/oradata/orcl/obe' SIZE 100M
ENCRYPTION DEFAULT STORAGE (ENCRYPT);
18c New features:
Read-Only Oracle Home : orabasehome command
Password File : Password file in ORACLE_BASE
PDB Snapshot : ALTER PLUGGABLE DATABASE SNAPSHOT MODE EVERY 24 HOURS;
PDB Switchover : Planed switchover and Unplanned switchover
PDB Lockdown Profile : PRIVATE_DBAAS, SAAS, PUBLIC_DBAAS
PDB copy in STDBY : STANDBY_PDB_SOURCE_FILE_DIRECTORY(no manual file copy for pdb nsertion in stdby) and
STANDBY_PDB_SOURCE_FILE_DBLINK(remote clone doesn't requires manual copying).
CDB Migartion : non-CDB migration as a PDB to existing CDB
Shadow tablespaces : for data protection
Bulk Load : Delay commit on Primary until data applied to all standby or continue then catch up
ALTER DATABASE SET STANDBY NOLOGGING FOR [ DATA AVAILABILITY| LOAD PERFORMANCE; ]
Partitions online Merging :
Mem optimize pool : MEMOPTIMIZE_POOL_SIZE ; Create table ...MEMOPTIMIZE For Read ; Speed up high-frequency query based on PK
Kill SQL : ALTER SYSTEM CANCEL SQL ; ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’;
Sharding : PDBs as Shards and Catalogs
Disk Conversion : Converting disks to Flex Disk Groups without Restricted Mount
Parameters :
OPTIMIZER_IGNORE_HINTS
OPTIMIZER_IGNORE_PARALLEL_HINTS
PRIVATE_TEMP_TABLE_PREFIX
STANDBY_PDB_SOURCE_FILE_DBLINK
STANDBY_PDB_SOURCE_FILE_DIRECTORY
