Useful Metalink Articles

출처 :  http://askdba.org/weblog/resource-center/useful-metalink-articles/

 

 

 

Oracle Documentation

11g - http://www.oracle.com/pls/db112/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

 

 

Documents

11gR1/R2 Installation and Upgrade steps by Suhas D. 11gR2_Upgrade_Steps