Re: AWR in OCI ATP

Hi Jeff,

I was actually looking for scheduling an email to get AWR report periodically from ATP database.

This won't solve the purpose.

Thanks,
Arpit

On Fri, 24 Jan 2020 at 18:31, Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> Use the DBA Panel in SQL Dev, there’s a UI for selecting snapshots and
> generating the HTML. It renders for me just like it would in EM/browser.
>
>
>
> Jeff
>
>
>
>
>
> *From:* Arpit Aggarwal <arpitdba2019_at_gmail.com>
> *Sent:* Friday, January 24, 2020 2:09 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* AWR in OCI ATP
>
>
>
> Hi Friends,
>
>
>
> Has anyone tried generating a AWR report in OCI ATP database , considering
> we don't have physical host access.
>
> I tried 2 options but had hit a blocker for both, if anyone else came
> across same, kindly assist.
>
>
>
> Option#1 ,
>
> I logged in to ATP sql developer as ADMIN user and executed below query to
> get a list of available snapshots,
>
> select SNAP_ID,DBID,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from
> dba_hist_snapshot where INSTANCE_NUMBER=1 order by SNAP_ID ;
>
> And further executed below query to generate AWR in html format,
>
> SELECT output FROM TABLE
> (dbms_workload_repository.awr_report_html(&dbid,&instnum,&beginsnap,&endsnap
> ));
>
> The only problem with above was that the resulted AWR html report when
> exported from sql developer does not converts into an easy readable format.
>
> Option#2,
>
> The other approach that I tried is by connecting to ATP database from my
> local machine but for some reasons the ATP host is not resolvable from my
> local machine though I have modified sqlnet.ora and tnsnames.ora
> accordingly.
>
> The benefit of this approach would be that we can just spool the html o/p
> of above query of AWR repository and can view it easily on our local
> machine.
>
> Reference -
> https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-preparing.html#GUID-6F118C83-5BD2-4C10-88F2-B7A6280D1EE1
>
> https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
>
> My tnsnames.ora and sqlnet.ora has been modified based on oracle doc.
>
>
>
>
>
> Thanks,
>
> Arpit
>

--
http://www.freelists.org/webpage/oracle-l