Re: AWR in OCI ATP

But i believe it cannot be scheduled to send in email on fixed intervals via sql developer...!!

On Sat 25 Jan, 2020, 9:06 PM Kellyn Pot'Vin-Gorman, <dbakevlar_at_gmail.com> wrote:

> 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