Thanks a lot for you view, Please provide your valuable suggestion and comments.
Introduction
The database is a very important component of any software and needs to maintain and monitor properly.
The main job of a database administrator is to monitor the database SQL, he can monitor the activities of the database and its users. You can use this information for tuning, troubleshooting, and more. The administrator has to keep an eye on SQL and its performance as it is very critical and reason to slow down the application. Also, the hacker used to hack the application data through the SQL. Here, We will explain to monitor the SQL query using the SQL developer. Please find the steps below –
Monitor SQL Query
The user can Monitor the SQL query information by using the SQL developer. Please find the steps below –
- Launch the SQL Developer
- Configure the Database for which the user want to monitor the session
- Navigate to Tools, then Monitor SQL.
- Once click on the Monitor SQL, It navigate to Monitor SQL window.
Once clicked on Monitor SQL option. it navigate to Real Time SQL Monitoring window.
The Real Time SQL Monitoring window helps to monitor the SQL. The user will be able to see below information –
- STATUS
- DURATION
- SQL_ID
- SESSION_ID
- SESSION_SERIAL
- INSTANCE_DOP
- CPU_TIME
- IO_TIME
- START_TIME
- END_TIME
- SQL_FULLTEXT
The user can view the records as Single Record View. Right click on the row which user want to view as Single Record and click on Single Record view option.
Thanks a lot for you view, Please provide your valuable suggestion and comments.