Oracle Configuration

Check

Current Session

SHOW PARAMETERS

SELECT * FROM V$PARAMETER;

SELECT * FROM V$PARAMETER2;

Instance

SELECT * FROM V$SYSTEM_PARAMETER;

SELECT * FROM V$SYSTEM_PARAMETER2;

Server Parameter File

SHOW SPPARAMETERS

SELECT * FROM V$SPPARAMETER;

Recommended Configuration


Fast Recovery Area
Oracle Managed Files

Performance

Parameters

Oracle Memory

Includes...
  • MEMORY_TARGET
  • WORKAREA_SIZE_POLICY
  • SHARED_POOL_SIZE
  • OPEN_CURSORS
Includes...
  • AUDIT_SYS_OPERATIONS
  • AUDIT_TRAIL
Includes...
  • GLOBAL_NAMES
Includes...
  • LOCAL_LISTENER
  • REMOTE_LISTENER

Tablespaces

Other

Container Database/Pluggable Database
Database Migration Assistant for Unicode

Scripts