This is a list of all Oracle 19c initialization parameters including their names, default value in Windows, and their usage: not only their definition but also when they can be changed, what is the gain, and some examples. This comes handy due that in every new version several parameters become obsolete and new are added. The acronyms you will find are:
- ACID: Atomicity, Consistency, Reliability and Durability
- ADDM: Automatic Database Diagnostic Monitor
- AMM: Automatic Memory Management
- ASM: Automatic Storage Management
- ASO: Advanced Security Option
- AWR: Automatic Workload Repository
- BFILE: Binary File, LOB
- CDB: Container database
- DBWR: Database Writer process
- DDL: Data Definition Language
- DML: Data Manipulation Language
- DRCP: Database Resident Connection Pool, shared server
- DSS: Decision Support System
- FRA: Fast Recovery Area
- HA: High Availability
- HTTPS: Hyper-Text Transfer Protocol over SSL
- IM: In-Memory
- LDAP: Lightweight Directory Access Protocol
- MTTR: Mean Time To Recover
- MV: Materialized View
- NAS: Network Attached Storage
- NFS: Network File Storage
- OLTP: Online Transaction Processing
- OLAP: Online Analytical Processing
- PDB: Pluggable database
- PDML: Parallel Data Manipulation Language
- PGA: Program Global Area
- PL/SQL: programming language interacting with Oracle
- RAC: Real Application Cluster
- RMAN: Recovery Manager, backup and restore
- SCN: System Change Number
- SGA: Shared Global Area
- SIMD: Single Instruction Multiple Data, see RISC
- SMTP: Simple Mail Transfer Protocol
- SSL: Secure Socket Layer
- TDE: Transparent Data Encryption
- VM: Virtual Machine
- XML: Extended Markup Language
