Oracle, Life, etc.

Home

MOVED TO GOOGLE SITES:

https://sites.google.com/site/mnsinger/

I’m using this site to document the work I’ve done as an Oracle DBA / Developer.

Oracle Projects

• ID Card Project
• Testing a Migration from Single Instance to RAC using Workload Capture and Replay in 11g

Oracle Troubleshooting

• Creating a SQL Plan Baseline for Problem Queries

Oracle Documentation

• Useful SQL Queries and Oracle Code
• Oracle Backup Strategy
• Oracle Recovery Strategy
• Copy AWR Reports to the Filesystem Automatically

Notes for OCP 11g Upgrade Exam. From this book.

• Installing, Upgrading and Change Management
• Diagnosing and Resolving Problems
• Intelligent Infrastructure and Security
• Automatic SQL Tuning and SQL Plan Management
• Automatic Storage Management (ASM) and Partitioning Enhancements
• Performance Enhancements
• RMAN and Flashback Enhancements
• Oracle SecureFiles and Miscellaneous New Features

From 2006. Notes for OCP 10g. From this book.

• Configuring Security for the Listener
• Getting Started with Oracle Recovery Manager (RMAN)
• Using RMAN to Backup Databases
• Diagnosing Oracle Database Issues
• Recovering from Noncritical Losses
• Incomplete Database Recovery
• Using Oracle Flashback Database
• Recovering from User Errors
• Detecting and Recovering from Database Corruption
• Tools for Oracle Database 10g Tuning
• Monitoring and Managing Storage
• Managing Storage with Automatic Storage Management
• Monitoring and Managing Memory
• Managing Oracle Database Resources
• Automating Administrative Tasks