4

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.

Code Hungry
  • 3,930
  • 22
  • 67
  • 95

1 Answers1

5
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

enter image description here

Nancy Guruswamy
  • 267
  • 1
  • 3
  • 14