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, he can monitor the activities of the database and its users. You can use this information for tuning, troubleshooting, and more.
This section contains the following topics:
Monitoring Sessions
Monitoring the Top SQL Statements
Monitoring Long OperationsWe will talk about Monitoring Sessions here, The user can monitor the session by using the SQL developer and it will enable a user to determine the users who are currently logged in to the database and what applications they are running. The user can see the detailed information of a session and kill the session if it is no longer required.
View the Sessions
The user can view the session 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 Sessions.
- Once click on the Monitor Sessions, It navigate to Monitor Sessions window.
Clicked on the Monitor Sessions… Option.
The above screen Monitor sessions has a lot of column which provide information related to SID, Serial Number, User Name, XXXXXX
Please right on the single record to view Single record.
Clicked on the Single Records View then it navigate to Single Records View model window.
Kill the Sessions
You can use SQL Developer to kill (terminate) a database session. This logs off and disconnects the user running the session. If the user is processing a transaction when you kill the session, the transaction is rolled back.
Reasons to kill a session include the following:
- The session is not responding.
- You want to perform an administrative function that requires all users to log off first, but the user is not available to end his or her session.
The user can view the session 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 Sessions.
- Once click on the Monitor Sessions, It navigate to Monitor Sessions window.
Clicked on the Monitor Sessions… Option.
Once clicked on the Kill Sessions then it will allow user to Kill the session.
Click on the Apply button to Kill the Session.
Thanks a lot for you view, Please provide your valuable suggestion and comments.