My Oracle Support Banner

How Does One Use End to End Application Tracing on an Agile Product Lifecycle Management (PLM) System? (Doc ID 1391432.1)

Last updated on MAY 19, 2023

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.
The features dicussed in the document are available on Oracle database versions 10gR2 ( and later.


The purpose of this document is to utilize the Oracle Database Trace Facility on an Agile PLM system. Although tracing capability is built into the Agile PLM system, it may not show all the SQL statements that occur on the database. This is because not all application components within the Agile PLM system have the debug facility (code) included to output the transactions to the console or log file. To capture everything that is happening on the database the Oracle Trace Facility must be utilized.

Note: Please review the attached document named EndtoEndApplicationTracingonAgilePLMSystem.doc for more details.


NOTE:  In the examples below and/or the attached document, user details (including login/password) / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


The following needs to be done by someone having SYSDBA credentials, This will most likely be your DBA.


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.