Oracle Support documents by category
My Oracle Support notes grouped by topic. Search the Doc ID or KB ID on support.oracle.com to open the note.
| 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 |
26. Fusion Middleware and WebLogic Server
| Doc ID |
KB ID |
Title |
|
KB162170 |
Remote Diagnostic Agent (RDA) - Getting Started |
|
KA521 |
Resolve Problems Faster! Use Remote Diagnostic Agent (RDA) - Fusion Middleware and WebLogic Server |
|
KB552500 |
SRDC - Collect Fusion Middleware Diagnostic Data - for FMW 14.1.2 Upgrade Issues |
Glossary
| Term |
Meaning |
| CSI |
Customer Support Identifier. In My Oracle Support, the term "User Group" is used as a replacement. |
| CUA |
Customer User Administrator. In My Oracle Support, the term "Administrator" or "Admin" is used as a replacement. |
| PI/PHI |
Personal Information / Protected Health Information. Information that identifies, relates to, describes, is reasonably capable of being associated with, or could reasonably be linked, directly or indirectly, with a particular individual, even if the information on its own does not clearly identify an individual. |
| OCI |
Oracle Cloud Infrastructure |
| OCID |
Oracle Cloud Identifier. Every OCI resource has an Oracle-assigned unique ID called an OCID. This ID is included as part of the resource's information in both the Console and API. Oracle uses it to control the service resources, and the customer needs it to use the API and to contact support. OCIDs are used in policies and in the OCI API to reference specific cloud resources. |
| SaaS |
Software as a Service |
| SR |
Service Request |
| Tenancy |
A secure and isolated partition of Oracle Cloud Infrastructure to create, organize, and administer your cloud resources. This could include compute instances, networks, storage, databases, identity, analytics and more. A tenancy is equivalent to a Cloud account. If you forgot your cloud account or tenancy name, you can get help at cloud.oracle.com or contact your Cloud administrator. |
| User Group |
A new type of container the Admin uses to organize and segment users and SR privileges within the My Oracle Support portal. User Groups replace Customer Support Identifiers. Approved membership to a User Group drives the ability to create and view technical SRs. |
Total Documents 600 plus
Categories 26
Last Updated November 3, 2026
Revision #3
Created 2026-10-02 13:23:35 UTC by Josi
Updated 2026-10-02 13:26:16 UTC by Josi
