with t as (
SELECT /*+materialize no_merge*/sample_id,event,count(1) cnt,ash.blocking_session
FROM   dba_hist_active_sess_history ash
where  ash.BLOCKING_SESSION is not null
and    event like 'enq: TX - contention' 
and    ash.sample_time between to_date('17.04.2019 22:00:00','dd.mm.yyyy hh24:mi:ss') and to_date('17.04.2019 23:30:00','dd.mm.yyyy hh24:mi:ss') 
group by sample_id,event,ash.blocking_session
having count(1)>100
order by 3 desc)
SELECT cnt,ash.session_id,ash.sample_id,ash.blocking_session,ash.sql_id,ash.sql_opname,ash.event,p1,p2,p3 
FROM dba_hist_active_sess_history ash,t 
where ash.session_id = t.blocking_session and ash.sample_id = t.sample_id 

CNT	SID	SAMP	BL_SID	SQL_ID          SQL_OPNAME	EVENT	        P1	P2	        P3
118	863	296839	526	8aka3hasux4gd	CALL METHOD	log file sync	21058	4043504339	0
103	843	296829	526	8aka3hasux4gd	CALL METHOD	log file sync	41507	4043382554	0
123	1518	296739	526	8aka3hasux4gd	CALL METHOD	log file sync	24046	4042219908	0
108	405	296629	526	8aka3hasux4gd	CALL METHOD	log file sync	21522	4040833824	0
102	2001	296599	526	8aka3hasux4gd	CALL METHOD	log file sync	40055	4040494515	0
102	8	297379	526	8aka3hasux4gd	CALL METHOD	log file sync	8590	4050472267	0
121	1287	297319	526	8aka3hasux4gd	CALL METHOD	log file sync	47657	4049694040	0
102	844	297199	526	8aka3hasux4gd	CALL METHOD	log file sync	56417	4048153707	0
124	1244	297119	526	8aka3hasux4gd	CALL METHOD	log file sync	4595	4047110754	0
137	661	297049		8aka3hasux4gd	CALL METHOD	SQL*Net message from dblink	0	1	0
114	1515	297039	526	8aka3hasux4gd	CALL METHOD	log file sync	35745	4046076653	0
104	1583	297869	526	8aka3hasux4gd	CALL METHOD	log file sync	22331	4056908967	0
113	157	297789	526	8aka3hasux4gd	CALL METHOD	log file sync	29340	4055881093	0
116	23	297639	526	8aka3hasux4gd	CALL METHOD	log file sync	29479	4053901768	0
120	1306	297569	526	8aka3hasux4gd	CALL METHOD	log file sync	7765	4053003260	0
101	1102	298409		8aka3hasux4gd	CALL METHOD	SQL*Net message from dblink	0	1	0
110	850	298399	526	8aka3hasux4gd	CALL METHOD	log file sync	13426	4063318543	0
131	1412	298279		8aka3hasux4gd	CALL METHOD	SQL*Net message from dblink	0	1	0
127	763	297989		8aka3hasux4gd	CALL METHOD	SQL*Net message from dblink	0	1	0
114	1709	297949		8aka3hasux4gd	CALL METHOD	SQL*Net message from dblink	0	1	0
101	1563	298779	526	8aka3hasux4gd	CALL METHOD	log file sync	19615	4067668255	0
103	1222	298589	526	8aka3hasux4gd	CALL METHOD	log file sync	38974	4065394736	0

SELECT * FROM v$version
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE	11.2.0.4.0	Production"
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SELECT
        A.VALUE
    FROM
        table1 M
        ,table2 A
    WHERE
        M.DEP_ID = A.DEP_ID
        AND M.ORD_ID = A.PAY_ID
        AND M.MAINFL = '1'
        AND M.ID = : B2
        AND A.ATTR = TO_NUMBER (
            : B1
        )

SELECT
        ID
        ,NJRN
    FROM
        table3
    WHERE
        TRA_ID = : B1

SELECT
        COUNT (*)
    FROM
        table4 T
    WHERE
        T.ID = : B2
        AND T.NORD = : B1
        AND T.SDOK <> 0
        AND package.fucntion (
            T.DEP_ID
            ,T.ACC_ID
        ) = 1