Oracle Database Documentation Reference
Last Updated May 11, 2026
| Doc ID |
KB ID |
Title |
| 33089.1 |
KB64479 |
TROUBLESHOOTING Possible Causes of Poor SQL Performance |
| 62143.1 |
KB147220 |
Troubleshooting Understanding and Tuning the Shared Pool |
| 149121.1 |
KB87588 |
Gathering a StatsPack Snapshot |
| 149560.1 |
KB152793 |
How to Collect and Display System Statistics CPU and IO for CBO use |
| 156968.1 |
KB718735 |
coe_stats.sql Automates CBO Stats Gathering using FND_STATS and Table sizes |
| 199083.1 |
FAQ1973 |
Primary Note SQL Query Performance Overview |
| 221970.1 |
KB85193 |
Forcing a Known Plan Using Hints |
| 232443.1 |
KB108933 |
How to Identify Resource Intensive SQL (TOP SQL) |
| 235146.1 |
KB142031 |
Example Top SQL Queries from V$SQLAREA |
| 235530.1 |
KB142135 |
How to Obtain a Formatted Explain Plan Recommended Methods |
| 465398.1 |
KB138926 |
How to Display All Loaded Execution Plan for a specific sql id |
| 550578.1 |
KB138155 |
How to Determine the Most Resource Intensive Executed SQL Statements Using Library Cache Views |
| 789888.1 |
KB82689 |
How to Load SQL Plans into SQL Plan Management (SPM) from the Automatic Workload Repository (AWR) |
| 1253696.1 |
KB125799 |
How To Use SQL Profiles for Queries Using Different Literals Using the Force Match Parameter |
| 1271343.1 |
KB137537 |
How to Load Queries into a SQL Tuning Set (STS) |
| 1359094.1 |
KB132897 |
How to Use AWR Reports to Diagnose Database Performance Issues |
| 1361401.1 |
KB141723 |
Primary Note Plan Stability Features (Including SQL Plan Management SPM) |
| 1380492.1 |
KB135307 |
Monitoring SQL Statements with Real Time SQL Monitoring |
| 1386802.1 |
KB143205 |
How To Use DBMS SQLDIAG To Diagnose Query Performance Issues |
| 1628089.1 |
KB151851 |
Interpreting Explain Plan (10g and Above) |
| 1630717.1 |
KB143304 |
AWR Report Interpretation Checklist for Diagnosing Database Performance Issues |
| 2516606.1 |
KB120649 |
How to Find Top sql id's That Consume PGA and Temporary Segments Most from ASH |
2. Table and Segment Management
| Doc ID |
KB ID |
Title |
| 118531.1 |
KB149847 |
How to Compute the Size of a Table containing Outline CLOBs and BLOBs |
| 149121.1 |
KB87588 |
How to Move Tables from One Tablespace to Another |
| 151588.1 |
KB152750 |
How to Reorganize a Table |
| 277124.1 |
FAQ2314 |
SEGMENT SHRINK and Details |
| 336014.1 |
KB140476 |
How To Cleanup Orphaned DataPump Jobs In DBA DATAPUMP JOBS |
| 336133.1 |
KB150053 |
How to Format Corrupted Block Not Part of Any Segment |
| 1200053.1 |
KB769174 |
Generate Script to Shrink Segment Advisor Recommendations |
| 1275596.1 |
KB152696 |
How to Tell if the IO of the Database is Slow |
| 1288149.1 |
KB791591 |
How To Manage Reduce and or Purged The FND LOBS Table |
| 1338193.1 |
KB148704 |
How to Move and Restore DB to New Host and File System using RMAN |
| 1359094.1 |
KB132897 |
How to Shrink a Table Using Online Redefinition |
| 1377458.1 |
KB153038 |
How to Display Storage Map for Database Tablespace Datafile Storage |
| 1396120.1 |
KB87096 |
How To Use ALTER TABLE MOVE To Shrink A Table |
| 1417697.1 |
KB142726 |
How to release unused space SHRINK occupied by a LOB segment |
| 1608166.1 |
KB151904 |
How to SHRINK or Reduce the datafile size by finding the HWM |
| 1918060.1 |
KB144410 |
How to calculate the proper value from processes sessions and transactions |
3. Database Backup and Recovery (RMAN)
| Doc ID |
KB ID |
Title |
| 372996.1 |
KB758611 |
Using RMAN to Restore and Recover a Database When Repository and Spfile Init.ora Files Are Lost |
| 874352.1 |
KB136046 |
RMAN 11GR2 DUPLICATE Without Target And Recovery Catalog Connection |
| 879677.1 |
KB753259 |
How to Determine When an Execution Plan was Produced Using DBA HIST SQLPLAN |
| 1338193.1 |
KB148704 |
How to Move and Restore DB to New Host and File System using RMAN |
| 216 |
KB627730 |
Using RMAN Effectively In A Dataguard Environment |
4. Data Guard and Replication
| Doc ID |
KB ID |
Title |
| 1101938.1 |
KB751668 |
Primary Note for Data Guard |
| 1320295.1 |
KB671565 |
Data Guard Physical Standby RMAN configure archivelog deletion policy reports RMAN 08591 |
| 1615836.1 |
KB300641 |
ORA 16826 apply service state is inconsistent with the DelayMins property |
| 2196935.1 |
KB134863 |
How to Remove One Standby Database from a Data Guard Configuration |
| 2464716.1 |
KB541169 |
DGMGRL Show Database Fails with DGM 17016 ORA 16525 ORA 16625 |
| 3086966.1 |
KB177229 |
DG PDB How To Check Standby Redo Logs Information |
5. Statistics and Optimizer
| Doc ID |
KB ID |
Title |
| 156968.1 |
KB718735 |
coe_stats.sql Automates CBO Stats Gathering |
| 457926.1 |
KB152684 |
How to Gather Statistics on Objects Owned by the SYS User and Fixed Objects |
| 1555451.1 |
FAQ2274 |
FAQ Gathering Concurrent Statistics Using DBMS STATS |
| 1559487.1 |
KB148856 |
Gathering Statistics with Preferences of Concurrent Runs Slowly |
| 1578590.1 |
KB862751 |
Best Practices for Gathering Statistics with Oracle E Business Suite |
| 709 |
FAQ1499 |
Global statistics An Explanation |
| Doc ID |
KB ID |
Title |
| 1275596.1 |
KB152696 |
How to Tell if the IO of the Database is Slow |
| 1277556.1 |
KB625498 |
How to Tell if the IO of the Database is Slow |
| 1342827.1 |
KB88928 |
Resolving Issues Where Application Queries are Waiting Too Frequently for db file sequential read |
| 1345027.1 |
KB165271 |
Resolving Issues Where Application Queries are Waiting Too Long for db file sequential read |
| 1423934.1 |
KB111315 |
Oracle Linux How to Measure IO Performance on Linux |
| 1616894.1 |
KB148731 |
Using truss pstack and DTrace to Debug High CPU Type Problems on Solaris |
7. Data Pump (Export and Import)
| Doc ID |
KB ID |
Title |
| 450150.1 |
FAQ2314 |
How to Monitor The Progress Of Datapump Jobs |
| 782162.1 |
KB609477 |
Understanding the ESTIMATE and ESTIMATE ONLY Parameters in Export DataPump |
| 786507.1 |
KB81395 |
How to Monitor The Progress Of Datapump Jobs |
| 1451471.1 |
KB149805 |
How To Monitor The Progress Of Datapump Jobs |
| 1515434.1 |
KB147057 |
DataPump Export Is Extremely Slow For Schema With Partitioned Tables |
| 1518749.1 |
KB152260 |
DataPump Export Is Extremely Slow For Schema With Partitioned Tables |
| 1561172.1 |
KB86403 |
EXPDP Hangs In 11.2.0.3 Processing The Procedural Objects |
| 1596645.1 |
KB144050 |
EXPDP and IMPDP Slow Performance Waits on Streams AQ |
| 2113967.1 |
KB151226 |
How To Validate A DataPump Export (EXPDP) Dump File |
8. Resource Manager
| Doc ID |
KB ID |
Title |
| 232443.1 |
KB108869 |
Why Resource Manager Is Not Distributing CPU As Per Resource Plan |
| 1338348.1 |
KB197184 |
How to Diagnose High CPU Usage Problems to the Module Level |
| 1338988.1 |
KB137827 |
Scripts and Tips for Monitoring CPU Resource Manager |
| 1348349.1 |
KB138155 |
How to Determine the Most Resource Intensive Executed SQL Statements |
| 1484302.1 |
KB165271 |
Primary Note Overview of Oracle Resource Manager and DBMS RESOURCE MANAGER |
| 1939637.1 |
KB157178 |
How To Automatic Kill Inactive Sessions using Resource Manager |
| 3054827.1 |
KB153481 |
How to disable Oracle Database Resource Manager |
9. Lock and Wait Events
| Doc ID |
KB ID |
Title |
| 413934.1 |
KB178048 |
How to Determine The Lock Type and Mode from an Enqueue Wait |
| 780514.1 |
KB139736 |
How to Find the Blocker of the library cache pin in a RAC environment |
| 789888.1 |
KB82689 |
How to Determine the Blocking Session for Event cursor pin S wait on X |
| 1360124.1 |
KB88538 |
How to Determine which Row is Locked by a Blocking Session |
| 2068558.1 |
KB118547 |
How to Select Historical Information Related to Wait Events for a Particular Time Frame |
10. E Business Suite Concurrent Processing
| Doc ID |
KB ID |
Title |
| 134035.1 |
KB627830 |
Concurrent Processing ANALYZEREQ.SQL Detailed Analysis of One Concurrent Request |
| 213021.1 |
KB233659 |
Concurrent Processing (CP) and APPS Reporting Scripts |
| 318 |
KB86210 |
E Business Suite Concurrent Processing Analyzer (CP Analyzer) |
| 308 |
KB627702 |
EBS Database Performance and Statistics Analyzer |
| 351 |
KB731183 |
Concurrent Processing CP Analyzer Sample SQL Statements |
| 372 |
KB214960 |
12.2 E Business Suite Applications DBA Online ADOP Utility Analyzer |
| 2678285.1 |
KB58414 |
How To Find The Concurrent Request Based On SQLID |
11. E Business Suite Workflow and Notifications
| Doc ID |
KB ID |
Title |
| 117 |
KB745118 |
Using Oracle Alert with Workflow Mailer |
| 332152.1 |
KB752793 |
E Business Suite Workflow Administration Diagnostics Solutions and General Information |
| 275 |
FAQ2314 |
FAQ on Purging Oracle Workflow Data |
| 393 |
KB752793 |
E Business Suite Workflow Administration Diagnostics Solutions and General Information |
| 2225 |
KB95086 |
Service Troubleshooting Workflow and Notification Rules |
| 2529449.1 |
KB722619 |
oacore server1 failed to startup with javax.naming.NameNotFoundException error |
| 2621631.1 |
KB116968 |
EBS Notifications Through Workflow Mailer Not Opening On Browser |
12. E Business Suite System Maintenance
| Doc ID |
KB ID |
Title |
| 1261 |
KB858234 |
Using AutoConfig to Manage System Configurations in Oracle E Business Suite Release 12 |
| 1262 |
KB678090 |
Using Oracle Alert with Workflow Mailer |
| 1408 |
KB779355 |
How to change hostname for E Business Suite Release 12 on single node |
| 1411723.1 |
KB627725 |
E Business Suite Concurrent Processing Analyzer (CP Analyzer) |
| 1582473.1 |
KB214960 |
Oracle E Business Suite Release 12.2 Information Center |
| 732713.1 |
KB783906 |
R12 E Business Suite Applications Manager Clone Script adcfgclone.pl appsTier Fails |
| 761566.1 |
KB858290 |
Oracle E Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86 64 |
| 2379649.1 |
KB210350 |
Adop apply fails with Do you wish to apply this patch now (No) |
| 2385153.1 |
KB116085 |
EBS Installation Configuration Management (ICM) Application DBA Online Patching (ADOP) Analyzer |
13. E Business Suite Applications Issues
| Doc ID |
KB ID |
Title |
| 90 |
KB745118 |
E Business Suite Steps To Remove and Disable Personalizations In OA Framework |
| 1245974.1 |
KB501960 |
R12 AP When Trying to Update an Invoice Getting Error |
| 2285559.1 |
KB111315 |
Access Requisition Details Error JBO 25058 |
| 2330129.1 |
KB740702 |
R12 AP Payables Process Results In Error oacore server1.log |
| 2379649.1 |
KB210350 |
Adop apply fails |
| 3050085.1 |
KB725953 |
NullPointerException from Oracore while creating the requisition |
14. Cloning and Migration
| Doc ID |
KB ID |
Title |
| 132 |
KB858212 |
Cloning Oracle Applications Release 12 with Rapid Clone |
| 1267 |
KB791591 |
How to Move and Restore DB to New Host and File System using RMAN |
| 1338193.1 |
KB148704 |
How to Move and Restore DB to New Host and File System using RMAN |
| 2379656.1 |
KB545833 |
EBS Cloning Analyzer |
| 2882174.1 |
KB120293 |
Example How to clone remote pdb from one cdb to another cdb using db link |
| 600 |
KB211819 |
Example How to clone remote pdb from one cdb to another cdb using db link |
15. Database Maintenance and Administration
| Doc ID |
KB ID |
Title |
| 147 |
KB95086 |
How To Purge DBA SCHEDULER JOB LOG and DBA SCHEDULER WINDOW LOG |
| 298 |
KB152750 |
Useful SQL Queries for TableSpace Management |
| 750497.1 |
KB699213 |
Purging Strategy for E Business Suite |
| 1377458.1 |
KB153038 |
How to Display Storage Map for Database Tablespace Datafile Storage |
| 2012221.1 |
KB148482 |
Script For Getting Complete Basic Information about configured CDB and PDB |
| 2695844.1 |
KB207761 |
How to Manage and Check Health of DBSystem and Related Services in OCI |
| 2757884.1 |
KB119235 |
How To Setup And Use DBMS CLOUD Package |
16. Troubleshooting and Diagnostics
| Doc ID |
KB ID |
Title |
| 352648.1 |
KB150265 |
How to Diagnose High CPU Usage Problems to the Module Level |
| 1378 |
KB197184 |
Data Collection Scripts for Cost Management |
| 1379200.1 |
KB66446 |
Troubleshooting Guide (TSG) Ksvcreate Process Creation Failed |
| 1380492.1 |
KB135307 |
Monitoring SQL Statements with Real Time SQL Monitoring |
| 1379 |
KB142230 |
Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp) |
17. Index Management
| Doc ID |
KB ID |
Title |
| 455924.1 |
KB748728 |
How to Check the Objects in Specific Datafile |
| 1228 |
KB355700 |
Script to investigate a b tree index structure |
| 1931009.1 |
KB71623 |
Drop Tablespace Failed with ORA 02429 cannot drop index used for enforcement of unique or primary key |
| 3051129.1 |
KB746953 |
How To Track Index Usage And DBLINK Usage Approximately Within A Specific Time Period By AWR Snapshots |
18. Monitoring and Alerts
| Doc ID |
KB ID |
Title |
| 180 |
KB738611 |
Using RMAN to Restore and Recover a Database |
| 392 |
KB148731 |
Using truss pstack and DTrace to Debug High CPU Type Problems |
| 2627 |
KB632101 |
EBS Enterprise Command Center (ECC) Analyzer |
| 2897610.1 |
KB748990 |
EBS Monitoring Analyzer |
19. RAC and Cluster
| Doc ID |
KB ID |
Title |
| 84 |
KB197216 |
How To Configure SSH for a RAC Installation |
| 780514.1 |
KB139736 |
How to Find the Blocker of the library cache pin in a RAC environment |
| 1330 |
KB819324 |
SCAN Registration Issue Services Fail to Register to SCAN Listeners |
| 2627 |
KB823902 |
12.2 E Business Suite Applications Manager Cloning Script Adcfgclone Changes Oacore |
| 3004436.1 |
KB619420 |
Oratop Lists Only 5 Instances of RAC Database |
20. Database Upgrade and Patches
| Doc ID |
KB ID |
Title |
| 123 |
KB678090 |
Oracle E Business Suite Release 12 Upgrade Sizing and Best Practices |
| 168 |
KB726992 |
Database Server Upgrade and Downgrade Compatibility Matrix |
| 483 |
KB1244 |
Database 11.2.0.4 Proactive Patch Information |
| 531 |
KB852791 |
Oracle 19c Complete Checklist for Upgrading to Oracle Database 19c (19.x) using DBUA |
| 2522 |
KB850150 |
Database 19 Release Updates and Revisions Bugs Fixed Lists |
21. Network and Connectivity
| Doc ID |
KB ID |
Title |
| 231 |
KB751668 |
Understanding DBMS NETWORK ACL ADMIN With Example |
| 387 |
KB143470 |
Valid Node Checking For Registration (VNCR) |
| 1381 |
KB144050 |
Oracle Net 12c Changes to the Functionality of Dead Connection Detection (DCD) |
| 438923.1 |
KB95086 |
How To Track Dead Connection Detection(DCD) Mechanism Without Enabling Any Client and Server Network Tracing |
22. Cost Management and Billing
| Doc ID |
KB ID |
Title |
| 87 |
KB197216 |
Understanding Cost Manager |
| 111 |
KB858234 |
Data Collection Scripts for Cost Management |
| 273 |
KB149321 |
Inventory Purging Programs Information |
| Doc ID |
KB ID |
Title |
| 2113967.1 |
KB151226 |
purgeLogs Archive and Cleanup traces logs in one command |
| 2456 |
KB118691 |
How To Purge ODI 12c Scenario Reports that Are No Longer Attached to a Parent Session |
24. Database Multitenant (CDB and PDB)
| Doc ID |
KB ID |
Title |
| 2012634.1 |
KB149161 |
Script For Getting Complete Basic Information about configured CDB and PDB in Oracle Database Multitenant 12c |
| 2197261.1 |
KB243087 |
TOTAL SIZE In V$PDBs Smaller Than Actual Size Of Pluggable Database |
| 2199585.1 |
KB727579 |
Values In Context File of Some Ports Must Remain Same on Both RUN and PATCH File Systems |
| 2529 |
KB211819 |
How to clone remote pdb from one cdb to another cdb using db link |
25. Linux and Operating System
| Doc ID |
KB ID |
Title |
| 589 |
KB134949 |
Oracle Linux How to Install xorg x11 apps Package on Oracle Linux 8 Server |
| 1435 |
KB127065 |
Oracle Linux How to Measure IO Performance on Linux |
Total Documents 600 plus
Categories 25
Last Updated May 11, 2026
No comments to display
No comments to display