Hi ,
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
I have posted few issues with my problems with performance *earlier, got lots of inputs and analysis goes in direction of studying ASH reports.
My DB got some issues yesterday, I took a dump of ASH and trying to study what was going on there ...
I find couple of cases here , many times SQL_ID is null, and amoung those there is one which got Parent_SQL_ID but again there is a big count with out that!
Can someone hlep me here with what should I look into further?
Appriciate your help!
select
session\_type,
top\_level\_sql\_id,
in\_connection\_mgmt,
session\_state,
wait\_class,
event,
blocking\_session,count(\*)
from tmp\_msh\_ash\_10june19 A
where sql\_id is null
group by
session\_type,
top\_level\_sql\_id,
in\_connection\_mgmt,
session\_state,
wait\_class,
event,
blocking\_session
order by count(\*) desc
Regards
Hesh
PS : * eariler : Inactive sessions