Home » RDBMS Server » Performance Tuning » regarding AWK in oracle (oracle10g, 10.2.0.2.0, AIX52)
regarding AWK in oracle [message #425518] Fri, 09 October 2009 06:59
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi ALL,

I am getting with the following error when I am running the AWK report.

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_19198_19199.html. To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrrpt_1_19198_19199.html
select output from table(dbms_workload_repository.awr_report_html( :dbid,
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SWRF_REPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SWRF_REPORT_INTERNAL"
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 309
ORA-06512: at line 1

Please help me in this regard. Thanks in Advance!

Regards,
Chandu

Previous Topic: Hints within a query that reads from view
Next Topic: Slow queries, configuration problem ?
Goto Forum:
  


Current Time: Sat May 18 04:00:11 CDT 2024