Fired SQL Statments Logging

Fired SQL Statments Logging

Postby rolfz » Fri 21 Aug 2015 13:54

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?
Posts: 1
Joined: Fri 21 Aug 2015 13:45

Re: Fired SQL Statments Logging

Postby alexa » Fri 21 Aug 2015 14:29

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\'.
Devart Team
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

Return to dbForge for Oracle