Re: AWR in OCI ATP

From: Arpit Aggarwal <arpitdba2019_at_gmail.com>
Date: Sun, 26 Jan 2020 22:47:04 +0530
Message-ID: <CAOrSwEoA6P1EwHrc6cnXJA39+N-r8R-3rfj-TsO5x7Gsp1pyUA_at_mail.gmail.com>



Great, will be looking forward for your blog.

Thanks,
Arpit

On Sun 26 Jan, 2020, 9:01 PM kris rice, <kris.rice_at_jokr.net> wrote:

> 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 - 18:17:04 CET

Original text of this message