Turn on Event logs in SQLplus

If you want to turn on the Event log in SQLplus for troubleshooting, do this:

1. Turn on the event

alter system set events '1017 trace name errorstack level 10';

2. Run the query your want to trace

3. Turn off the event

alter system set events '1017 trace name errorstack off';

4. Check trace file in bdump folder.