Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Oracle DBA Tutorial 11 - How to find and Kill the session in Oracle Database using SQL Developer. That video is uploaded by Chirags Tutorial at 2022-06-05T08:56:53-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [xKuhdaQow7w]
| Name | Oracle DBA Tutorial 11 - How to find and Kill the session in Oracle Database using SQL Developer |
| Video Uploader | Video From Chirags Tutorial |
| Upload Date | This Video Uploaded At 05-06-2022 15:56:53 |
| Video Discription | inchirags@gmail.com Chirag's Oracle DBA Tutorial https://www.chirags.in ***************************************************************************************** * How to find and Kill the session in Oracle Database using SQL Developer * ***************************************************************************************** A session consists of every connection to the Oracle database by a user from a specific process. kill those inactive sessions without clients approval because as their status says they are 'INACTIVE'? Safe yes - from a database instance perspective. Oracle is very robust. It does not choke when a user session suddenly disappear. Download SQL Developer: https://www.oracle.com/tools/downloads/sqldev-downloads-2141.html Steps: --- 1. Login to your Oracle Database. (sqlplus / as sysdba) from command line. 2. run the below commands. ## Flow the tutorial 3 and 4 for creating user, tablespace and creating datafile. SQL⇒ select username from dba_users; ## lets take the user chirag. ##Open SQL Developer.. and connect the database. Get the SID details from below command. SQL⇒ Select name from v$database; ORCL ## using user details create the connection in SQL Developer. ## Now run the below command for getting session count. SQL⇒ select count(*) from v$session; ## now run the below command for get the session list and adding line for running the kill command for session. Follow the video for killing the session process. SQL⇒ select 'alter system kill session '''||sid||','||serial#||''' immediate;' ,username, seconds_in_wait/60 as mint from v$session where username not in ('SYS','SYSTEM') and status='INACTIVE' and state='WAITING' and seconds_in_wait⇒900; ## we can kill the session in command line or SQL Developer. Note : Flow the Process shown in video. 😉Subscribe and like for more videos: https://www.youtube.com/channel/UCLdaO4-i_gxQMi87JwjKOwA 💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment Tutorial Link : https://www.chirags.in/tutorials/oracle_database Thanks & Regards, Chitt Ranjan Mahto "Chirag" _________________________________________________________________________________________ Note: All scripts used in this demo will be avilable in our website. Link will be available in description. #oracle #oracletutorial #chiragstutorial #chiragsdatabasetutorial #oracledatabase #chiragsdbatutorial #databasetutorial #bestDatabaseTutorial #oracletutorialchirags xKuhdaQow7w |
| Category | Education |
| Tags | Oracle 11g R2 | Chirag's Tutorials | Chirag's DBA Tutorials | Chirag's Oracle DBA Tutorials | Oracle 11g R2 Tutorial | Oracle 11g R2 Installation | Oracle 11g R2 Installation Process | Oracle 11g R2 Installation Process Step by Step | Oracle 11g R2 in Windows | Oracle 11g R2 Tutorial in Windows | Oracle 11g R2 Installation in Windows | Oracle 11g R2 Installation Process in Windows | Oracle 11g R2 Installation Process Step by Step in Windows |
