Re: Oracle ATP : ASH

From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 25 Sep 2019 07:51:14 +0000

So what interesting SQL was SH running ? Any clues from the optimizer plan
lines ?

Regards
Jonathan Lewis

________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Hemant K Chitale <hemantkchitale@xxxxxxxxx>
Sent: 25 September 2019 08:13
To: ORACLE-L
Subject: Oracle ATP : ASH

I created by first ATP in the Free Oracle Cloud and added a username='HEMANT'
with some data.
However, ASH for my database at some point showed a user called "SH"

V$SESSION doesn't show sessions other than my session.
DBA_USERS does show all the seeded accounts (and HEMANT).

ASH shows some other session from SH ?

[image.png]

Hemant K Chitale

Follow-Ups:
- Re: Oracle ATP : ASH
  - From: Hemant K Chitale

References:
- Oracle ATP : ASH
  - From: Hemant K Chitale

Re: Oracle ATP : ASH

Other related posts: