Tracing: How to Troubleshoot and Identify Database Issues that Can Affect Forms
(Doc ID 1489712.1)
Last updated on FEBRUARY 14, 2023
Applies to:Oracle Forms - Version 10.1.2.3.0 and later
Information in this document applies to any platform.
The note below will focus on the interaction between forms and a Database instance and how we can identify when forms is affected by a database issue.
Main focus areas in this note:
I. How to identify connectivity issues or delays between Forms and a DB instance
- SQL*net trace
- SQL trace
II. How to troubleshoot possible issues on DB side :
- Dynamic views
- SGA Memory
- Invalid and unusable objects
- Database errors
- Blocking sessions ( locks )
- Connection timeout
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!