Fired SQL Statments Logging

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Posts: 1
Joined: Fri 21 Aug 2015 13:45

Fired SQL Statments Logging

Post by 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?

Devart Team
Posts: 2229
Joined: Fri 24 Jun 2011 14:17

Re: Fired SQL Statments Logging

Post by 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\'.

Post Reply