RE: AWR in OCI ATP
Date: Fri, 24 Jan 2020 05:01:52 -0800 (PST)
Message-ID: <886e22b9-b15a-4f35-a189-e6234da56e78_at_default>
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
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.
To: oracle-l_at_freelists.org
Subject: AWR in OCI ATP
My tnsnames.ora and sqlnet.ora has been modified based on oracle doc.
Thanks,
Arpit
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 24 2020 - 14:01:52 CET