Has anybody a work-around for statistics values being too large to display on the AWR report? In statspack you can hack the SQL to change format masks etc but in AWR the whole report (via awrrpt1.sql) uses a single (wrapped) package call - this one:
-- call the table function to generate the report
select output from table(dbms_workload_repository.&fn_name( :dbid,
:inst_num,
:bid, :eid,
:rpt_options ));
I am seeing things like:
Physical
Logical
Service Name DB Time (s) DB CPU (s) Reads
Reads
-------------------------------- ------------ ------------ ----------
----------
pt1d4tpw 26,058.3 25,313.3 109
##########
pt1d4tpf 10,585.6 4,654.2 1,717
##########
There is bug 5213488 in metalink specifically for "rows per sort" ("Rows per Sort" in AWR report overflows and only shows ########) but all this says it will be fixed in 11.1 (and shows that the format mask is hard coded) - if AWR can't show all the numbers then it is not exactly useful (to me).
Failing that anybody know how to get at the source (it is wrapped of course) so I can at least produce my own personal copy that returns the data I need. I don't really feel like re-writing the whole thing myself using the AWR views (and yes this this database can legally use the diagnostic pack!) - last resort I suppose is to redo the bits that are causing problems.
Google, metalink and the FMs have not helped that much. Many thanks Tim Onions _________________________________________________________________Get Hotmail, News, Sport and Entertainment from MSN on your mobile. http://www.msn.txt4content.com/
-- //www.freelists.org/webpage/oracle-l
