Skip to main content

Kill sessions which Locking Table 

Find the locking sessions from following 

select s1.username || '@' || s1.machine
|| ' ( SID=' || s1.sid || ' ) is blocking '
|| s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status
from v$lock l1, v$session s1, v$lock l2, v$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and l2.id2 = l2.id2 ;

Get Session details from this sql  
example : if session id = 421select * from V$Session where sid = 421; 

Kill Sessions from following
alter system kill session '421,7951';



Temporary Tables

Get the out put from following sql and run the out put.

SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';' FROM V$SESSION WHERE SID IN (
SELECT SID FROM V$LOCK
WHERE id1 = (SELECT object_id FROM all_objects WHERE owner ='CMDC' AND object_name ='TMP_EQUIPSTATUS'));









































Comments











Post a Comment




















Popular posts from this blog



















Scraping HTML Content using Python




























 To Scrape Data using python we are using BeautifulSoup python Package    !pip install beautifulsoup4    As a first step we have to import the packages and html page that we need to scrape.  In here I have used some static HTML content which was customized to scrape the data.    #imports  import requests  from bs4 import BeautifulSoup     #html  HTML Sample    Doing Data Science with Python    Doing Data Science with Python  Author: Eranda Kodagoda  This will help to perform various data science activitied using python   Modules    Title  Duration in minutes    Getting Started  20    Setting Up Environment  40    Extracting Data  30    Exploring and Processing Data  45    Building Productive Model  45        To View the HTML using beautifulsoup we can use below code-lines and execute on python executor    from IPython.core.display import display, HTML  display(HTML(html_string))    To Print the HTML using beautifulsoup we can use below code-lines and execute on python executor    ps=Be...




















Post a Comment









Read more




























Basics of Data Science with Python




























 About Data Science with Python    From this module I will post some interesting posts about Data science and how to gather information and process them using Python and for that I will be using below softwares      Python 3.6   Anaconda   Jupyter Notebook   PyCharm by JetBrains     In the posts I will include fundamentals of Python  programming techniques such as lambdas, reading and manipulating csv files, and the numpy library.     And In the posts I will be doing a simple Data Challange which is available on Kaggle and I will provide the URL's to the github repo which I will be posting the whole module once it finished.     In Future I will be post some articles related to Applied Data Science with Python: Applied Plotting, Charting & Data Representation in Python, Applied Machine Learning in Python, Applied Text Mining in Python, Applied Social Network Analysis in Python   




















1 comment









Read more




























Selenium WebDriver Cheat Sheet




























 Below are some important code samples for those who are willing to learn Selenium automation.   Driver Initialization     WebDriver driver ;   driver = new ChromeDriver() ;  driver = new FirefoxDriver() ;  driver = new SafariDriver() ;  driver = new InternetExplorerDriver() ;  driver = new EdgeDriver() ;     // Driver Profiling  //Firefox  //Load Firefox  System. setProperty ( "webdriver.firefox.bin" , "path/to/driver" ) ;  FirefoxProfile profile = new FirefoxProfile() ;  //load with add-on  File file = new File( "path/to/add-on" ) ;  profile.addExtension(file) ;  //profile settings (setting up desired capabilities)  DesiredCapabilities capabilities= new DesiredCapabilities() ;  capabilities.setCapability(FirefoxDriver. PROFILE , profile) ;  WebDriver driver = new RemoteWebDriver(capabilities) ;     //Chrome Options  System. setProperty ( "webdriver.chrome.driver" , "/path/to/chrome/driver" ) ;  ChromeOptions options = new ChromeOption...




















Post a Comment









Read more