Re: Can this sql restarts by itself

From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 15 Oct 2021 10:18:36 -0400

On 10/15/21 04:34, l.flatz@xxxxxxxxxx wrote:

Hi,

dba_hist_active_session_history will hold a top_level_sql_id and a PLSQL_entry_id and some similar information.
Maybe that will help to shed some light on the case.

Regards

Lothar

dba_hist_active_session_history is so enormously useful that Oracle should make it available without the license.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
//www.freelists.org/webpage/oracle-l

References:
- Can this sql restarts by itself
  - From: Pap
- Re: Can this sql restarts by itself
  - From: Lok P
- Re: Can this sql restarts by itself
  - From: Andy Sayer
- Re: Can this sql restarts by itself
  - From: Pap
- RE: Can this sql restarts by itself
  - From: Mark W. Farnham
- Re: RE: Can this sql restarts by itself
  - From: l.flatz@xxxxxxxxxx

Other related posts:

» Can this sql restarts by itself- Pap
» Re: Can this sql restarts by itself- Lok P
» Re: Can this sql restarts by itself- Andy Sayer
» Re: Can this sql restarts by itself- Pap
» RE: Can this sql restarts by itself- Mark W. Farnham
» Re: Can this sql restarts by itself- Mladen Gogala
» Re: Can this sql restarts by itself- Maxim
» Re: Can this sql restarts by itself - Mladen Gogala
» Re: Can this sql restarts by itself- Pap