Tracing the entire database is not the best way to analyze an issue in Oracle Applications but it could be the only means in
particular cases.
Principle steps to enable database level tracing are :
=====================================================
- Edit init<SID>.ora file
- Add 'SQL_TRACE=TRUE' or 'EVENT=...' parameters
- Verify presence of 'TIMED_STATISTICS=TRUE' parameter to track and analyze performance issues
- Stop concurrent managers and shutdown database
- Restart database and concurrent managers