No self-respecting Oracle DBA or Developer could live without the most content-rich Oracle resource ever, Oracle Metalink.
This is a list of Metalink notes which I personally find / have found extremely useful.
Note, you will need an Oracle Metalink account to access these documents
Database / OS / Application performance tuning
| Note | Description |
| 62172.1 | Understanding and Tuning Buffer Cache and DBWR. |
| 62143.1 | Understanding and Tuning the Shared Pool. |
| 208256.1 | How to Remove a Single ORACLE_HOME and Its Traces on Microsoft Windows Platforms. |
| 32895.1 | SQL Parsing Flow Diagram |
| 157250.1 | Freelist Management with Oracle 8i |
| 1029850.6 | Freelists and Freelist Groups |
| 22908.1 | What are Latches and What Causes Latch Contention? |
| 245645.1 | Using 10g Temporary Tablespace Groups |
| 146560.1 | FAQ for Database Performance |
| 236770.1 | Tuning Windows NT to Optimize Oracle9i |
| 147468.1 | Checkpoint Tuning and Troubleshooting Guide |
| 104377.1 | Investigation the performance of New PL/SQL Features using DBMS_PROFILER |
| 108377.1 | How Do You Read the Output from the Dump Function? |
| 1031826.6 | Histograms: An Overview |
| 62294.1 | The DBMS_SUPPORT Package |
| 62005.1 | Creating, Optimizing, and Understanding Rollback Segments |
| 40689.1 | ORA-01555 "Snapshot too old" - Detailed Explanation |
| 32951.1 | Interpreting TKPROF output |
| 131272.1 | How using synonyms may affect database performance and scalability |
| 223299.1 | Top Oracle 9i init.ora Parameters Affecting Performance |
| 100709.1 | Top Oracle8/8i init.ora Parameters Affecting Performance |
| 228913.1 | Systemwide Tuning using STATSPACK Reports |
| 69882.1 | Windows NT: Killing an Oracle thread using OraKill |
| 76438.1 | Monitoring Oracle Threads using Qslice |
| 104981.1 | NT: Threads and Background Process |
| 164768.1 | Diagnosing High CPU Utilization under Windows and Unix |
| 224176.1 | How to use UNIX OS commands to diagnose Database Performance issues |
| 223117.1 | Tuning I/O-related Wait Events (Buffer Cache / Redo / Controlfile / Datafile etc.) |
| 102926.1 | Performance Tuning Advanced Queuing in 8i and 9i |
| 102906.1 | Performance Tuning Advanced Queuing in 8.0 |
XML, Web Services etc.
| Note | Description |
| 303875.1 | Extract Function Causes Xml Data To Be Stored With Pretty Printing On By Default |
| 301262.1 | Sample Script Generating (Pretty Printed = Indented) XML From Relational Tables Using SQL/XML |
| 253082.1 | ExistsNode Query Returns No Rows When XML Doc Uses Multiple Namespaces |
| 137044.1 | Example Of Storing/Accessing Uri-refs In/From The Database |
| 221854.1 | How To Call A WebService From a PL/SQL function |
| 280749.1 | How to Provide Proxy Information when Indexing a Uritype Column |
| 137022.1 | New Database XML Features Introduced In 9i |
SQL & PL/SQL
| Note | Description |
| 119451.1 | Storing Boolean values, and bitwise operators in PL/SQL |
| 206272.1 | New Method of Using UTL_FILE in Oracle9i 9.2 |
| 74123.1 | Bulk Binding - What it is, Advantages, and How to use it |
| 119152.1 | Introducing PL/SQL Server Pages |
| 146398.1 | Inheritance, Substitutability and Polymorphism in Oracle9i |
| 62592.1 | Dynamic SQL |
| 1008453.6 | Using DBMS_SQL Package to Execute DDL Statements and Dynamic SQL from PL/SQL |
| 1005663.6 | Debugging PL/SQL Programs Using DBMS_OUTPUT |
| 61730.1 | Using the DBMS_JOB Package |
Oracle Developer Tools
| Note | Description |
| 66887.1 | Basing a Block on a Stored Procedure - Sample Code |
| 104771.1 | How to Implement a Dynamic From Clause Query with Forms Variables |
| 105289.1 | Basing a Block on a Table Containing a Nested Table or Varray |
| 220629.1 | Hosting Both SSO and Non-SSO Applications With Forms 9i |
| 199072.1 | How to Implement Single Sign-On (SSO) Using Forms 9i? |
| 237301.1 | Logging and Tracing in Reports 9.0.2 |
| 62664.1 | Forms Server (6i) Logging and Forms Runtime Diagnostics (FRD) Explained |
| 118632.1 | Webforms Static HTML File Parameter Overview |
| 219471.1 | Forms Servlet (9i) Logging Explained |
| Forms 6i Diagnostics | How to log / diagnose Forms 6i problems |
| 9iAS Forms Services | Tracing and Diagnostics |
| 189867.1 | Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102 in Oracle Forms 6i and 9i |
Oracle Application Server
| Note | Description |
| 118360.1 | How To Configure MS Internet Explorer To Use Jinitiator with Discoverer Plus |
| 184826.1 | Configuring mod_oc4j for Accessing an Application Deployed in OC4J |
| 200475.1 | 9iAS Release 2 (9.0.2) Start/Stop Instructions on Unix/Linux |
Misc features
| Note | Description |
| 39836.1 | Clustering Factor |
| 68790.1 | RDBMS Support for the Euro Currency Symbol |
| 119441.1 | How to get the Time within an one-hundredth of a Second Accuracy |
| 69028.1 | How does Oracle store the DATE datatype internally? |
| 1031902.6 | How Does Oracle Store Internal Numeric Data? |
| 1068369.6 | Example: Using DBMS_JOB.SUBMIT to Execute Jobs at Regular Intervals |
| 70067.1 | All about Bitmap Indexes |
| 1070627.6 | What Are Reverse Key Indexes? |
| 109725.1 | Different Data from DBA_JOBS and DBA_JOBS_RUNNING |
發表文章
沒有留言:
張貼留言