The System DB-Idle event monitors activity between the Oracle Forms Runtime and the database to which it is connected. This event will monitor any interaction with the database executed by the associated application. This event can be enabled in one of two ways. The first way is to set the environment variable FORMS_DB_IDLE_TIME to a whole number, which represents the number of seconds to wait before raising this event.

This event can also be enabled/disabled programmatically using a new argument added to SET_APPLICATION_PROPERTY, DB_IDLE_TIME. The value for DB_IDLE_TIME will be a whole number, in seconds. Refer to the Form Builder Help for more details on how to use this in PL/SQL.

Following are some limitations:

• The internal timer for the DB-Idle event begins immediately after completing a database action. This does not include the Forms default login action that occurs during application startup.

• By default, this event will only be raised one time. For example if a COMMIT is executed then activity against the db no longer occurs and the preset time is reached, this event will be raised. If after that raising of the event, the idle condition remains, the event will not be raised again. To cause this event to continue monitoring, it must be set programmatically by setting the Application property DB_IDLE_REPEAT to TRUE.