Oracle Database Tips and Tricks

• Triggers:
  • The Trouble with Triggers

• Storage:
  • Extents

• Performance Tuning:
  • Buffer Caches (e.g. Keep, Recycle)
  • Keep and Recycle Params deprecated in 12c
  • Active Session History (ASH)
  • Memory Management
    • AMM 11g, AMM, Disable AMM

• ASM:
  • Install
  • RHE 7 ASM downloads from Oracle
  • ASM Disk Setup

• RAC:
  • Install RAC VB
  • Install RAC VB 2
  • RAC 12c on Centos VMWare

• Backup and Recovery:
  • Instance/Crash Recovery – Ask Tom
  • Incremental Updated Backups
  • RMAN Quick Reference
  • DBMS_BACKUP_RESTORE reference

• Install:
  • HugePages on Linux
  • Linux Memory Settings: SHMMAX and SHMALL
    • Mysterious SHMMAX and SHMALL
    • Oracle Docs – Manual completion of Preinstallation Tasks
    • Oracle Community thread

•  EMCC:
  • EMCLI

• Maintenance:
  • Index Rebuild

• Multitenant:
  • Convert Non-CDB to CDB/PDB
    • How to migrate an existing pre-12c database (non-CDB) to 12c CDB database? (MOS Doc ID 1564657.1)
    • Create a PDB directly from a stand-alone database?
    • How to migrate an existing pre12c database(nonCDB) to 12c CDB database
    • Adopting a Non-CDB as a Pluggable Database in a Multitenant Container Database
    • Multitenant : Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1)
    • Convert a non PDB to a PDB
    • How to Move a PDB Back to a Non-CDB Using TRANSPORTABLE=ALWAYS (Doc ID 2027352.1)
    • Step by Step Examples of Migrating non-CDBs and PDBs Using ASM for File Storage (Doc ID 1576755.1)
  • Naming CDB/PDB:
    • Are your servers Pets or Cattle?

• Checkpoint and SCN:
  • SCN
  • Checkpoint & SCN
  • Read Consistency & SCN
  • Checkpoints in Action
  • Oracle 8.0 Checkpoint Paper
  • Checkpoints UKOUG

• Redo and Undo:
  • Managing Undo Data
  • *** Differences between UNDO and REDO
  • Commit, Rollback and Redo log files
  • Why not use redo for consitent read?
  • Redo Change Vector
  • When does uncommitted data rollback from data file?
  • Oracle Forensics Part 1: Dissecting the Redo Logs
  • Redo Logs and Recovery – Oracle Presentation
  • Change number of log writers

• Cursors:
  • What is a cursor – Ask Tom
  • Oracle Core (need access to Safari Online)

• Auditing:
  • Auditing Enhancements

• Julian Dyke Presentations: (all)
  • Redo Internals
  • Transaction Internals
  • SGA Internals
  • Oracle 12c New Features
  • Index Internals
  • Bitmap Index Internals
  • IOT Internals
  • Block Types

• SQLDeveloper:
  • SQLDeveloper – Jeff Smith

• Data Quality:
  • Data Quality – Craig Fisher
  • ACID and BASE in Databases

• Commands:
  • VI
  • ADRCI:
    • Basics
    • Command Interpreter + DDL 12c Enhancements
    • Docs

for_students