Re: AWR in OCI ATP

Hi,
how about option1 and awr_report_text?
Does that work?
Regards
Lothar
----Ursprüngliche Nachricht----
Von : arpitdba2019_at_gmail.com
Datum : 24/01/2020 - 08:09 (MN)
An : oracle-l_at_freelists.org
Betreff : 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 Received on Fri Jan 24 2020 - 09:09:45 CET