Code Hungry
Reputation: 4000
How to check activity log of Oracle SQL Developer
I want to monitor Activity Logs on Oracle SQL Developer Tool, using F8 key i am getting SQL history.
I want user session-wise data like who (user) have executed which query or any operation from GUI.
Upvotes: 5
Views: 34345
Answers (1)
Nancy Guruswamy
Reputation: 277
To view sessions:
In SQL Developer, click Tools, then Monitor Sessions.
In the Select Connection dialog box, select a connection to SYSTEM (or another account with full DBA privileges)
A Sessions tab is displayed
Upvotes: 6
Related Questions
- How do I view the Explain Plan in Oracle Sql developer?
- How to run .sql file in Oracle SQL developer tool to import database?
- Oracle SQL Developer and PostgreSQL
- How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
- Partition By using Oracle SQL Developer tool (GUI)
- Oracle SQL Developer multiple table views
- How to key in and display date with hours and minutes into Oracle SQL Developer?
- Oracle SQL Developer - Query results window with grid missing
- View table comment with Oracle SQL Developer