Database Tuning (MOSC)

MOSC Banner

error while executing ASH report

edited Nov 29, 2013 4:30AM in Database Tuning (MOSC) 4 commentsAnswered
hi,

We are getting below error during executing ashrpt.sql

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is ashrpt_1_1116_1100.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: ashrpt_1_1116_1100.txt

Using the report name ashrpt_1_1116_1100.txt

Summary of All User Input
-------------------------
Format         : TEXT
DB Id          : 2559204448
Inst num       : 1
Begin time     : 16-Nov-13 10:30:01
End time       : 16-Nov-13 11:00:01
Slot width     : Default
Report targets : 0
Report name    : ashrpt_1_1116_1100.txt

select output from table(dbms_workload_repository.ash_report_text( :dbid,
                         *
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 11407

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center