Re: AWR in OCI ATP

Just an idea, but instead of generating it as HTML, generate it with report type as text and email as an attachment?

Kellyn

On Sat, Jan 25, 2020 at 6:13 AM Arpit Aggarwal <arpitdba2019_at_gmail.com> wrote:

> 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
>>
> --

*Kellyn Pot'Vin-Gorman*
DBAKevlar Blog <http://dbakevlar.com>
about.me/dbakevlar

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