Re: Oracle ATP : ASH

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 25 Sep 2019 07:51:14 +0000
Message-ID: <CWXP265MB1750219519052FFC95BD015BA5870_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>

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




image/png attachment: image.png

Received on Wed Sep 25 2019 - 09:51:14 CEST

This message: [ Message body ]
Next message: GG: "How to avoid gc current block busy"
Previous message: Hemant K Chitale: "Oracle ATP : ASH"
Maybe in reply to: Hemant K Chitale: "Oracle ATP : ASH"
Next in thread: Hemant K Chitale: "Re: Oracle ATP : ASH"
Reply: Hemant K Chitale: "Re: Oracle ATP : ASH"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message