Database Trace Option
Oracle Order Entry provides the database trace option to trace and evaluate the database activity for the Order Entry transactions. You can use the database trace features to:
- get diagnostic information to debug errors.
The database trace files are located on the server in the directory specified in the init.ora file. Contact the Database Administrator at your site to determine the directory path for the file location. Oracle Order Entry creates two separate trace files:
- Client transactions. This file includes a log of operations such as queries, lists of values, etc.
- Transaction Manager activity. This file includes a log of the operations such as Validation, Updates, Inserts, and Deletes.
Methods for enabling Database Trace
From the client, you can enable and disable the trace using the menu Help->Tool->Trace. This will enable the database trace for the Client session as well for the Transaction Manager session.