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
