Re: Oracle ATP : ASH

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