--GenernalTradeoffs when increasing DB_BLOCK_SIZE [ID 65984.1]
--TNS & Listener
TroubleShooting Guide For ORA - 12502 TNS:listener received no CONNECT_DATA from client [ID 453505.1]
--SQL*PLUSHow To Connect Using A Sqlplus Preliminary Connection [ID 986640.1]
--Log fileWAITEVENT: "log file sync" Reference Note [ID 34592.1]
How to Tune Log File Sync? [ID 857576.1]
-- Performance Diagnostic & Health Check
How to Perform a Health Check on the Database [ID 122669.1]
Oracle Performance Diagnostic Guide (OPDG) [ID 390374.1]
| Database Instance Tuning Knowledge Browser Product Page [ID 267886.1] |
Full Table Scans On A Table Is Reading 1 Block At A Time. (Due To Chained / Migrated Rows) [ID 554366.1]
WAITEVENT: "db file sequential read" Reference Note [ID 34559.1]
--Backup & Recovery
How to Resolve ORA-03297 When Resizing a Datafile by Finding the Table Highwatermark [ID 130866.1] |
Fractured blocks found during crash or instance recovery when using EMC Symmetrix storage [ID 758055.1]How to resolve ORA-00600 [13013], [5001] [ID 816784.1] --corrupted block
Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g [ID 28814.1]
Extracting Data from a Corrupt Table using DBMS_REPAIR or Event 10231 [ID 33405.1]
--Standby & replicationCascaded Standby Databases [ID 409013.1]
--Query tuning
Master Note: TROUBLESHOOTING: Advanced Query Tuning [ID 163563.1]
| START HERE> Diagnosing Query Tuning Problems [ID 233112.1] |
Master Note: Diagnosing Why a Query is Not Using an Index [ID 67522.1]QREF: SQL Statement HINTS [ID 29236.1]
--CBO & Statistics |
| Cost Based Optimizer - Common Misconceptions and Issues - 10g and Above [ID 754931.1] |
Master Note: Restoring table statistics in 10G onwards [ID 452011.1]
--Upgrade & Downgrade |
|
TROUBLESHOOTING: Server Upgrade Results in Slow Query Performance [ID 160089.1]
--OS, Solaris
| How To Display Information About Processes on SUN Solaris [ID 70609.1] |
--LockHOW TO FIND BLOCKING SESSION FOR MUTEX WAIT EVENT cursor: pin S wait on X [ID 786507.1] |
SCRIPT: FULLY DECODED LOCKING [ID 1020008.6]
| How to Determine The Lock Type and Mode from an Enqueue Wait [ID 413934.1] |
TX Transaction locks - Example wait scenarios [ID 62354.1]-good explain on TX lock
| REFERENTIAL INTEGRITY AND LOCKING [ID 33453.1] --good explain on v$lock, TM lockVIEW: "V$LOCK" Reference Note [ID 29787.1]--good explain on v$lock, |
WAITEVENT: "enqueue" Reference Note [ID 34566.1]FAQ about Detecting and Resolving Locking Conflicts [ID 15476.1]
--Memory
| Init.ora Parameter "CURSOR_SHARING" Reference Note [ID 94036.1] |
| Fundamentals of the Large Pool [ID 62140.1] |
How to Calculate Your Shared Pool Size [ID 1012046.6]
WAIT SCENARIOS REGARDING LIBRARY CACHE PIN AND LIBRARY CACHE LOAD LOCK [ID 115656.1]Understanding and Tuning the Shared Pool [ID 62143.1]
Which Views Can Be Used to Monitor PGA Usage in Oracle 10g and Higher? [ID 469521.1]
| Automatic PGA Memory Management [ID 223730.1] |
--Parallel
Using Parallel Execution [ID 203238.1]Checklist for Performance Problems with Parallel Execution [ID 280939.1]
PARALLEL_EXECUTION_MESSAGE_SIZE Usage [ID 756242.1]
Why didn't my parallel query use the expected number of slaves? [ID 199272.1]
Parallel Query Wait Events [ID 191103.1]
--CPU |
|
Diagnosing High CPU Utilization [ID 164768.1] |
*TBR*Database Performance - FAQ [ID 402983.1]
Master Note: Why is a Particular Query Slower on One Machine than Another? [ID 604256.1] |
Extent Sizes for Sort, Direct Load and Parallel Operations (PCTAS & PDML) [ID 50592.1]--Partition
Top Partition Performance Issues [ID 166215.1]
| How to Split Partition of Heavily Used Table [ID 76769.1] |
| Fast Split partitioning in 9iR2 [ID 232628.1] |
"Update Global Indexes" Allows Automatic Global Index Maintenance During DDL [ID 139707.1]Exchange Partition Having Global Index with Non - Partitioned Table [ID 419505.1]
| How to Partition a Non-partitioned Table [ID 1070693.6] |
How To Partition Existing Table Using DBMS_Redefinition [ID 472449.1]
|
--Space
| 10g and above SEGMENT ADVISOR [ID 242736.1] |
--Index
| Index Rebuild, the Need vs the Implications [ID 989093.1] |
|
How Does the Index Block Splitting Mechanism Work for B*tree Indexes? [ID 183612.1]
| How Btree Indexes Are Maintained [ID 30405.1] |
How to Find Out How Much Space an Index is Using [ID 33343.1]
| Script: To Report Information on Indexes [ID 1019722.6] |
--flashback
Flashback Database Best Practices & Performance [ID 565535.1]
Flash Recovery area - Space management Warning & Alerts [ID 305812.1]
Flashback Logs-Space management [ID 369755.1]
How To Disable Flashback Database Without A Bounce [ID 833584.1]
How To Recover From A Drop/Truncate/Delete Table Done On Primary Using Flashback On A Standby Database [ID 958557.1]
--Security Password
All
About Security: User, Privilege, Role, SYSDBA, O/S Authentication,
Audit, Encryption, OLS, Database Vault, Audit Vault [ID 207959.1]
Script to Check for Default Passwords Being Used for Common Usernames [ID 227010.1]
Patch 4926128 Oracle Default Password Scanner
Oracle Created Database Users: Password, Usage and Files References [ID 160861.1]
--WWW documents
--ORA-06512 executing utlu112i.sql
http://davidalejomarcos.wordpress.com/2010/05/07/ora-06512-executing-utlu112i-sql/
--oracle convert between row and column
http://www.itpub.net/viewthread.php?tid=1017026&extra=page%3D1%26amp%3Bfilter%3Ddigest
--How to escapte special characters
http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_escape_special_characters_when_writing_SQL_queries.3F
--oracle default account and password
http://www.petefinnigan.com/default/oracle_default_passwords.htm |
|
|
|
|
|
E-Business Suite
Autoconfig
165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
218089.1 Autoconfig FAQ
270519.1 Customizing an AutoConfig Environment
Application Object Library
177183.1 Succesfully Installing NLS/MLS in 11i
Application Server
230688.1 Basic ApacheJServ Troubleshooting with IsItWorking.class With Applications 11i
146468.1 Installing Oracle9i Application Server 1.0.2.2.2 with
Oracle Applications 11i
146468.1 Installing Oracle9i Application Server 1.0.2.2.2 with
Oracle Applications 11i
237988.1 How to Enable Rotatelog for 9iAS V2 HTTP Server (Log file rotation)
Cloning
135792.1 Cloning Oracle Applications Release 11i
230672.1 Cloning
Oracle Applications
Release 11i with Rapid Clone
Concurrent Manager
105133.1 Concurrent Manager Questions and Answers Relating to Generic Platform
213021.1 Concurrent Processing (CP) / APPS Reporting Scripts
185489.1 Setting Up Parallel Concurrent Processing On Unix Server
241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment
No comments:
Post a Comment