How to check activity log of Oracle SQL Developer

oracle11g oracle-sqldeveloper plsqldeveloper
Code Hungry picture Code Hungry · Jun 21, 2016 · Viewed 17.5k times · Source

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.

Answer

Nancy Guruswamy picture Nancy Guruswamy · Jun 21, 2016 
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

Related questions

Explicitly set column value to null SQL Developer

I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB. I wanted to explicitly set one column to null? How do I do that in the SQL Developer GUI? Previously in MSSQL, …

Read More
How to create a new database after initally installing oracle database 11g Express Edition?

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database to start with, maybe with one table or two and then use …

Read More
Where to get this Java.exe file for a SQL Developer installation

I just installed Oracle 11g, and tried to start Oracle SQL developer so as to start writing queries. It is asking me: Enter the full pathname for the java.exe file . Where do I find this? I did a global …

Read More