dba_hist_active_sess_history

DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle

Mehmet Salih Deveci September 8, 2021 Oracle 1

I will explain DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle in this post.

How to Change AWR Snapshot Retention Period & Interval Settings ( dba_hist_snapshot ) in Oracle

Mehmet Salih Deveci May 21, 2019 Oracle, Performance Tuning 1

Hi, I will explain How to Change AWR Snapshot Retention & Interval Settings in Oracle in this Article.

Oracle Kill Session Scripts -4 and gv$lock view

Mehmet Salih Deveci March 30, 2019 Oracle, Oracle DBA Scripts 4

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.

Oracle Kill Session Scripts -3 and gv$session, gv$lock view

Mehmet Salih Deveci March 7, 2019 Oracle, Oracle DBA Scripts 0

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.

Oracle Database Wait Event Scripts -2

Mehmet Salih Deveci February 22, 2019 Oracle, Oracle DBA Scripts, Performance Tuning 4

Hi, When you take many complaints from customer about slowness of database, you should check Oracle database wait events.

Oracle Database Wait Event Scripts -1

Mehmet Salih Deveci February 22, 2019 Oracle, Oracle DBA Scripts, Performance Tuning 3

Hi, When you take many complaints from customer about slowness of database, you should check Oracle database wait events.

Kill Session Scripts in Oracle -2

Mehmet Salih Deveci March 1, 2018 Oracle, Oracle DBA Scripts 0

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions.

Oracle Kill Session Scripts -1

Mehmet Salih Deveci March 1, 2018 Oracle, Oracle DBA Scripts 0

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions.

Oracle Blocking Sessions and Lock Scripts -2

Mehmet Salih Deveci March 1, 2018 Oracle, Oracle DBA Scripts 1

Hi, While you are using your program which is connected to Oracle database, you can feel slowness on application related with Oracle database. This problem is probably related with blocking session …

Oracle Blocking Sessions and Lock Scripts -1

Mehmet Salih Deveci March 1, 2018 Oracle, Oracle DBA Scripts 0

Hi, While you are using your program which is connected to Oracle database, you can feel slowness on application related with Oracle database. This problem is probably related with blocking session …

IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: dba_hist_active_sess_history