Tracing: How to Troubleshoot and Identify Database Issues that Can Affect Forms
(Doc ID 1489712.1)
Last updated on SEPTEMBER 19, 2017
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:
- SQL*net trace
- SQL trace
- 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!