Zakładki z serwisu Metalink

Zakładki z Metalink

–Wydajność
Note:301137.1 OS Watcher User Guide

–Strojenie
Note:215187.1 SQLTXPLAIN.SQL - Enhanced Explain Plan and related diagnostic info for one SQL statement
Note:224270.1 Trace Analyzer TRCANLZR - Interpreting Raw SQL Traces with Binds and/or Waits generated by EVENT 10046
Note:114671.1 Gathering Statistics for the Cost Based Optimizer

–RAC
Note:209914.1 RAC Survival Kit: High Availability and RAC
Note:203226.1 RAC Survival Kit: Real Application Clusters Troubleshooting and Information

–Deadlock/Enqueue
Note:285270.1 The Performance Impact of Deadlock Detection
Note:34566.1 WAITEVENT: “enqueue” Reference Note
Note:29787.1 VIEW: “V$LOCK” Reference Note
Note:15476.1 FAQ about Detecting and Resolving Locking Conflicts
Note:62354.1 TX Transaction locks - Example wait scenarios

–DBMS
Note:62160.1 Tracing Sessions in Oracle Using the DBMS_SUPPORT Package

-DataGuard
Note:225633.1 Implementing SSH port forwarding with Data Guard