• Home
  • DBA Scripts
    • Oracle Scripts
    • SQL Server Scripts
  • Knowledge Base
    • Oracle Database
    • MS SQL Server
    • MongoDB
    • MariaDB
  • Troubleshoot
    • Oracle Database Issues
    • SQL Server Issues
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • Courses
    • Oracle Database
    • Oracle DBA L1
    • Oracle DBA L2
    • Oracle DBA L3
  • Home
  • DBA Scripts
    • Oracle Scripts
    • SQL Server Scripts
  • Knowledge Base
    • Oracle Database
    • MS SQL Server
    • MongoDB
    • MariaDB
  • Troubleshoot
    • Oracle Database Issues
    • SQL Server Issues
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • Courses
    • Oracle Database
    • Oracle DBA L1
    • Oracle DBA L2
    • Oracle DBA L3
home/Knowledge Base/Oracle Database/Oracle 18c Database/Oracle 18c New Initialization Parameters
Popular Search:Oracle, SQL Server, MongoDB

Oracle 18c New Initialization Parameters

85 views 0 August 29, 2019 September 5, 2019 admin

ADG_ACCOUNT_INFO_TRACKING

Default LOCAL

Controls login attempts of users on Active Data Guard Standby databases by extending the control of user account security information

AWR_PDB_MAX_PARALLEL_SLAVES

Defualt 10

Enables a DBA to allocate the correct amount of resources to enable quick and timely Automatic Workload Repository (AWR) flushes

MEMOPTIMIZE_POOL_SIZE

Default 0

Sets the size of the Memoptimized Rowstore in the SGA

FORWARD_LISTENER

Default Null

Specifies the name of a listener to which a connection must be forwarded by an existing set of remote listeners

OPTIMIZER_IGNORE_HINTS

Default FALSE

Causes the optimizer to ignore all hints … this should be the default setting in most databases

OPTIMIZER_IGNORE_PARALLEL_HINTS

Default FALSE

Causes the optimizer to ignore all parallel hints … this should be the default setting in all databases

PRIVATE_TEMP_TABLE_PREFIX

Default ORA$PTT_

Specifies the prefix that the database uses for private temporary tables

TDE_CONFIGURATION

Default Null

Used for per-PDB configuration for Transparent Data Encryption (TDE) Before 18c, each PDB stored their separate encryption keys in the CDB’s keystore (united mode) Starting with Oracle Database 18c, a PDB can optionally store its encryption keys in a separate keystore (isolation mode) allowing protection by a separate keystore password The WALLET_ROOT initialization parameter must be set for TDE_CONFIGURATION to take effect

DBFIPS_140

Default FALSE

Enables Transparent Data Encryption (TDE) and DBMS_CRYPTO PL/SQL package

program units to run in a mode compliant to the Federal Information Processing Standard

(known as “FIPS mode”)

 

 

Tags:Parameters

Was this helpful?

Yes  No
Related Articles
  • Table recovery using RMAN Backup – Oracle 18c
  • Backup & Restoring Databases on Oracle Cloud Service
  • dbaascli – Oracle Database Cloud Service
Leave A Comment Cancel reply

Oracle 18c Database
  • Oracle 18c New Initialization Parameters
  • Table recovery using RMAN Backup – Oracle 18c
  • Backup & Restoring Databases on Oracle Cloud Service
  • dbaascli – Oracle Database Cloud Service
Popular Articles
  • Upgrade Oracle Database from 11.2.0.3 to 12.1.0.2
  • Upgrading MariaDB on Windows
  • Oracle DBA Basic Interview Questions Part A
  • Purging Oracle Sysaux Tablespace
  • Client – Server Architecture
KB Categories
  • Oracle Database
    • Oracle RAC
    • Oracle ASM
    • Oracle GoldenGate
    • Oracle Tuning
    • Oracle 11g Database
    • Oracle Database Upgrade
    • Oracle 12c Database
    • ALL KB Oracle
    • Oracle 18c Database
    • Oracle Standby Database
  • MongoDB
  • MS SQL Server
  • MySQL
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • MariaDB
Database Organization

Database Organization (DB ORG) is knowledge base for DBA to learn and execute the fundamental of different databases under one website. DB ORG is a non-profit initiative. ORACLE, MS SQL Server, MongoDB, MariaDB, Couchbase

Join Our Community
  • KnowledgeBase
  • Documentation
  • Troubleshoot
  • FAQ
Information Links
  • About DBOrg
  • Licenses
  • Terms
  • Privacy Policy
Contact Us
    DB ORG - Database Administration,
    Knowledge Base for DBA
    Mail: support@databaseorg.com
    WhatsApp: (+91) 9306440957
    Monday to Friday: EST - 11:30 AM to 06:30 PM (IST - 9:00 PM to 4:00 AM)
  • © 2023 Database Organization - DB ORG. All Rights Reserved.

Popular Search:Oracle, SQL Server, MongoDB

WhatsApp DB Org