Skip to content

My Oracle Notes and problems resolution

Tag: blocking sessions

Posted on 15 February 201929 May 2020

List blocking sessions

Below is a query that list all the blocking sessions in an oracle instance

Recent Posts

ORA-39097 ORA-39065 ORA-21780
ORA-07445 [kkqjpdpvpd()+656]
Shrink oracle tablespace
Q Processes take more and more memory
High PGA memory consumption and high CPU usage is observed during the automatic maintenance task execution

Tags

archivelogs
blocking sessions
ORA-00600
ORA-27300
ORA-27301
ORA-27302
oracle

Categories

Data Recovery Advisor
dbms_scheduler
DRA
Errors
Expression calendar
licensing
Non classé
Oracle Scheduler
RMAN
SQL

Search for:

Recent Posts

ORA-39097 ORA-39065 ORA-21780
ORA-07445 [kkqjpdpvpd()+656]
Shrink oracle tablespace
Q Processes take more and more memory
High PGA memory consumption and high CPU usage is observed during the automatic maintenance task execution

Archives

December 2024
September 2023
February 2023
October 2021
September 2021
May 2021
February 2021
May 2020
February 2019
September 2013
February 2012

Categories

Data Recovery Advisor
dbms_scheduler
DRA
Errors
Expression calendar
licensing
Non classé
Oracle Scheduler
RMAN
SQL

Proudly powered by WordPress