Re: AWR in OCI ATP

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Arpit Aggarwal <arpitdba2019@xxxxxxxxx>
  • Date: Sat, 25 Jan 2020 13:02:46 -0500

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@xxxxxxxxx <mailto:gogala.mladen@xxxxxxxxx>> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2020