Welcome
Sr Oracle DBA Interview Questions
Sr Oracle Applications DBA Interview Questions
HA/MAA/DR/RAC/ASM Case Studies
Sr Applications DBA **A-Z** Most Wanted Metalink Bookmarks
Scripts/Code Snippets/Performance Tuning/Troubleshooting
- Identify FND UserLoad Sqlscript.
- Identify Patch Jobs Run By adpatch Sqlscript.
- Register AOL Tables Sqlscript.
- Concurrent Manager Info Sqlscript.
- Concurrent Request Load Sqlscript.
- Concurrent Manager Health Check Sqlscript.
- Merged Patch Details Sqlscript.
- SQL script to troubleshoot long running concurrent request.
- Identifying APPS front-end username for a given sid.
- Identifying SID for a given front-end username.
- Tracing Wait Events.
- Tracing Optimizer.
- Identify blocking locks.
- Identify indexes which requires rebuild.
- PL/SQL wrapper API to send email from database.
- PL/SQL API for proactive database monitoring.
- Script to purge old trace,core files.
- Script for database heartbeat healthcheck
- Script to monitor alert log and page dba.
- Script to monitor disk usage and page dba.
- Script to rotate alert & log files.
- Backgroupd Processes Health Check Script.
- External Tables Example
- DR & Rsync Seeded Scripts
- os-utilities-commands.
- Auditing-through-server-side-triggers
- Monitor-all-ora-errors-with-server side triggers.
- Transportable tablespaces.
10g RAC, Streams, Logical Standby, SOX Procedures
- Automate Cloning/Sox Requirements.
- Backup & Recovery Using NetApp.
- Replication Using Logical Standby.
- Replication Using Streams.
- 10gRAC Installation Checks/Concepts.
- step-by-step-1158-11510-apps-upgrade.
- step-by-step-8174-9203-upgrade.
- step-by-step-8174-9205-db-upgrade.
- step-by-step-8i-physical-standby.
- step-by-step-10g-physical-standby.
- step-by-step-RAC-ASM-How-to-Procedures
- Duplicate DB using RMAN
- Standby using RMAN Duplicate DB
