Tracing: How to Troubleshoot and Identify Database Issues that Can Affect Forms (Doc ID 1489712.1)

Last updated on OCTOBER 18, 2024

Applies to:

Oracle Forms - Version 10.1.2.3.0 and later
Oracle Forms for OCI - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Purpose

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

Tnsping
SQL*net trace

II. How to troubleshoot possible issues on DB side :

Dynamic views
SGA Memory
Invalid and unusable objects
Database errors
Blocking sessions ( locks )

III. Parametes tuning

Connection timeout
SESSION_CACHED_CURSORS

Troubleshooting Steps

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Tracing: How to Troubleshoot and Identify Database Issues that Can Affect Forms (Doc ID 1489712.1)

Applies to:

Purpose

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!