Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Global AWR report from laptop using dbms_workload_repository

user11319873Jun 6 2012 — edited Jun 6 2012

Oracle Version 11.2.0.3 on AIX.

Can anybody help what I should be passing for l_inst_num if I want to get global (consolidated) AWR report in a RAC environment. I am trying generate this report on my laptop so can't use awrgrpt.sql.

DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML(
l_dbid IN NUMBER,
l_inst_num IN NUMBER,
l_bid IN NUMBER,
l_eid IN NUMBER,
l_options IN NUMBER DEFAULT 0)

I did study awrgrpt.sql and all the SQLs it is callling but couldn't figure out what it is using for the l_inst_num parameter. I tried passing 0 and 'ALL' and few other things. None of them working.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2012

Added on Jun 6 2012

#general-database-discussions

3 comments

903 views