Out sick

Josue Pirir jpirir

Out sick

Working at @Zubale

jpirir / ORACLE 11g blocking session

Last active December 9, 2020 21:34

Identify blocked objects and users related, based at http://sushantadba.blogspot.com/2016/05/find-current-and-historical-blocking.html

	select distinct
	b.username user_
	,d.username blocked_by_user_
	,t1.time_
	,t1.sql_text
	,t1.*
	from (
	SELECT distinct a.sql_id, a.blocking_session,a.blocking_session_serial# blocking_session_serial,
	to_char(a.sample_time,'hh24:mi:ss') time_,
	a.user_id, s.sql_text,a.module

jpirir / kill_session.sql

Last active November 1, 2019 00:37

select to kill session oracle

	select 'alter system kill session '''\|\|sid\|\|','\|\|serial#\|\|''''\|\|' immediate'\|\|';'
	from v$session
	where username = '';