Re: AWR in OCI ATP

From: kris rice <kris.rice_at_jokr.net>
Date: Sun, 26 Jan 2020 10:31:02 -0500
Message-ID: <CAPVZWiP4dNsa3Ufh8CbkKNcopZGatRrf_1gWr-8adCQXyGf3Mg_at_mail.gmail.com>



Here's another option:
https://twitter.com/krisrice/status/1221455049097908224

I can do a full blog post on it this week ( well add to the queue of things to blog anyway )

-kris

On Sat, Jan 25, 2020 at 1:03 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Yes, and? DBD::Oracle (Perl) or oci8_12c can connect to Oracle 19c, which
> is what "ATP" is, and query system tables or generate AWR reports. Your
> Perl of PHP script can run locally.
>
> Regards
> On 1/25/20 10:46 AM, Arpit Aggarwal wrote:
>
> It all has to be done in ATP, no host access,no sys access, only admin
> access .
>
> On Sat 25 Jan, 2020, 9:15 PM Mladen Gogala, <gogala.mladen_at_gmail.com>
> wrote:
>
>> It can be scheduled through Perl, PHP or Python and crontab.
>> On 1/25/20 10:38 AM, Arpit Aggarwal wrote:
>>
>> But i believe it cannot be scheduled to send in email on fixed intervals
>> via sql developer...!!
>>
>>
>>>
>>>
>>>
>>>
>>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217
>>
>> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jan 26 2020 - 16:31:02 CET

Original text of this message