| error in SPreport output [message #166253] |
Wed, 05 April 2006 07:11  |
vraman3
Messages: 7
Registered: January 2006
|
Junior Member |
|
|
hi i found the follwing error after running the SPREPORT.
after Instance Efficiency Percentages (Target 100%) i have proper values available.
the report
STATSPACK.STAT_CHANGES
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'STAT_CHANGES'
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
SMI 782365444 smi 1 9.2.0.7.0 NO chenhp01
Snap Id Snap Time Sessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 5 03-Apr-06 12:34:03
End Snap: 6 03-Apr-06 12:56:59
Elapsed: 22.93 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: M Std Block Size: K
Shared Pool Size: M Log Buffer: K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size:
Logical reads:
Block changes:
Physical reads:
Physical writes:
User calls:
Parses:
Hard parses:
Sorts:
Logons:
Executes:
Transactions:
% Blocks changed per Read: Recursive Call %:
Rollback per transaction %: Rows per Sort:
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: Redo NoWait %:
Buffer Hit %: In-memory Sort %:
Library Hit %: Soft Parse %:
Execute to Parse %: Latch Hit %:
Parse CPU to Parse Elapsd %: % Non-Parse CPU:
after this the report is ok.
thanks
venkat
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
