Page 1 of 1

Fired SQL Statments Logging

Posted: Fri 21 Aug 2015 13:54
by rolfz
Hi,
we use dbForge for Oracle Pro. A trigger suddenly disappeared. We try to find out what was recently happened by our clients. Does dbForge has a log file (history) of all SQL statements fired to the db?

Re: Fired SQL Statments Logging

Posted: Fri 21 Aug 2015 14:29
by alexa
You can turn on logging as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Restart dbForge Studio for Oracle.

A *.log file can be found in the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for Oracle\'.