Re: Oracle ATP : ASH

And, yes, I've sent all my findings to Oracle Cloud Support.

Hemant K Chitale

On Fri, Sep 27, 2019 at 2:47 PM Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:

>
> On 25-Sep, I was on Instance 1. Today I am on Instance 2.
>
> Nevertheless, querying V$ACTIVE_SESSION_HISTORY from Instance 2, I find
> that the user "SH" has been running modules "COLLECT_CUSTOMER_METRICS"
> and "DETAILED_PDB_HEALTHCHECK"
> while *also* owning Sales History objects (TIMES, PRODUCTS, COUNTRIES,
> COSTS, PROMOTIONS, SALES, CHANNELS, CUSTOMERS and
> SUPPLEMENTARY_DEMOGRAPHICS).
>
> I don't know module "COLLECT_CUSTOMER_METRICS" is but I can guess what
> "DETAILED_PDB_HEALTHCHECK" is.
> Why do they allow the "SH" user to run these modules, I wonder ?
>
>
>
> Hemant K Chitale
>
>
>
>
> On Wed, Sep 25, 2019 at 3:52 PM Jonathan Lewis <
> jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>>
>> So what interesting SQL was SH running ? Any clues from the optimizer
>> plan lines ?
>>
>>
>> Regards
>> Jonathan Lewis
>>
>> ________________________________________
>> From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
>> behalf of Hemant K Chitale <hemantkchitale_at_gmail.com>
>> 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
>>
>>
>>

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