Resource Center
Resource Center is a list of Articles/ Metalink Documents/ White Papers/ Frequently Encountered Issues useful for a DBA on a day to day basis Categorized based on content. Please feel free to add more resources
Oracle Documentation
11g – http://www.oracle.com/pls/db111/homepage
10g – http://www.oracle.com/pls/db102/homepage
9i – http://www.oracle.com/pls/db92/db92.homepage
10G Database Limits- http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm#REFRN004
Architecture
Note 153961.1 – Semaphores and Shared Memory – An Overview
Note.412264.1- How to Backup Partition of Range Partitioned Table with Local Indexes
Note 263599.1 – Understanding and Troubleshooting Instance Load Balancing
Administration
Note 262066.1 – How To Size UNDO Tablespace For Automatic Undo Management
Note 268870.1 – How to Shrink the datafile of Undo Tablespace
Note 206007.1 – How To Automate Cleanup Of Dead Connections And INACTIVE
Note 1029252.6 – How to Resize a Datafile
Note 199298.1 – Diagnosing excessive redo generation
Automatic Storage Management (ASM)
Note 359266.1 – FAQ ASMLIB CONFIGURE,VERIFY, TROUBLESHOOT
Note 266028.1 – ASM Using Files Instead of Real Devices on Linux
Note.443835.1- ASM Fast Mirror Resync – Example To Simulate Transient Disk Failure And Restore Disk
Note.438580.1 – How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
Note.445037.1 – ASM Fast Rebalance
Note.429098.1- 11g ASM New Feature
Note.451900.1 – ASMCMD – New commands in 11g
Note.431143.1 – ‘WARNING- allocation failure on disk ‘ Messages In Asm Alert Log
Note.419014.1 – ORA-15041 V$ASM_DISK Shows HUNG State for Dropped Disks
NOTE.345180.1 – How to duplicate a controlfile when ASM is involved
Globalization Support
Note 158577.1 – NLS_LANG explained
Note 179133.1 – Windows NLS_LANG
Unix NLS_LANG – Metalink doc: 264157.1
Note 340512.1 – Timestamps and time zones – Frequently Asked Questions
Note 227338.1- Character Set Scanner – Frequently Asked Questions
Note 119164.1 – Changing Database Character Set – Valid Superset Definitions
Note 226692.1- Finding out your NLS Setup
Note 264157.1- The correct NLS_LANG setting in Unix Environments
Note 227338.1 – Character Set Scanner – Frequently Asked Questions
Internal Error – ORA-600/ORA -7445
Note 403747.1 – FAQ Physical Corruption
Note: 260459.1 – How to Analyze Problems Related to Internal Errors (ORA-600) and Core Dumps (ORA-7445) using Metalink
Performance
Note 41634.1 – Tkprof Simplistic Overview
Note 46234.1- Interpreting Explain planNote 22908.1 – What are Latches and What Causes Latch Contention
NOTE.228913.1- Systemwide Tuning using STATSPACK Reports
NOTE.164504.1- How to Check Why Shutdown Immediate Hangs?
Note 375935.1 – What To Do and Not To Do When ‘shutdown immediate’ Hangs
NOTE.35934.1- Cost Based Optimizer – Common Misconceptions and Issues
Note 62365.1 – What to do with “ORA-60 Deadlock Detected” Errors
Note 203238.1- Using Parallel Execution
Note 377847.1- Unsafe Peeked Bind Variables and Histograms
Note 462072.1- File System’s Buffer Cache versus Direct I/O
Note 147468.1 – Checkpoint Tuning and Troubleshooting Guide
Myths and Folklore About Oracle 8i Performance Tuning
Note.458881.1 -Killed Session Hung Consuming 100% CPU
Note.468740.1 – “Pmon Failed To Acquire Latch” Messages in Alert Log -Database Hung
Note.430555.1 – Database Hung With “kksfbc child completion” and “Cursor- Pin X” Waits
NOTE.215858.1- Interpreting HANGANALYZE trace files to diagnose hanging
“Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer“
Memory
Note 396940.1- FAQ: ORA-4031
Note.443746.1- Automatic Memory Management(AMM) on 11g
Note 223730.1- Automatic PGA Memory Managment in 9i
RAC
Note 220970.1- RAC: Frequently Asked Questions
Note 374540.1 - Quick Guide: How To Set Up Load Balancing
Note 244241.1 – Rolling Patch – OPatch Support for RAC
Unix
Note 262004.1 – Configuring RHEL 3 and Oracle 9iR2 32-bit with Hugetlb
Note 260152.1 – Summary About the Large SGA & Address Space on RH Linux
Note 226209.1 – Linux: How to Check Current Shared Memory, Semaphore Values
Note 37914.1 – Raw Devices and Oracle – 20 Common Questions and Answers
Note 110888.1 – How to Trace Unix System Calls
Note 293561.1 – Unix Commands on Different OS’s
Note 18089.1 – UNIX: Connect AS SYSBDA / SYSOPER Privilege on Oracle RDBMS
Miscellaneous
White Paper on Space Mgmt
http://www.oracle.com/technology/products/manageability/database/pdf/OOW2002SpaceMgmtEXT.pdf
Note 291686.1 – White Paper on Logminer
Note 157250.1:Freelist Management with Oracle 8i
Note 291686.1 – LogMiner Utility Release 8.1.x – 10g
Note 161549.1 – Oracle Database Server and Networking Patches for Microsoft Platforms
Security
Note 1020945.6 – How to Setup Auditing
Note 70679.1 – How to Audit Logon/Logoff Events with Triggers
Note 222807.1 -How To Audit GRANT ANY PRIVILEGE Or GRANT ANY ROLE
Note 340240.1 – “An Assessment of the Oracle Password Hashing Algorithm”
Upgrade
Note 316889.1 – Complete Checklist for Manual Upgrades to 10gR2
