statspack spreport.sql error
Statspack was installed in a newer 10g database on Solaris 10. Snapshots were gathered throughout the day for performance tuning information. When I try to execute the report via ?/rdbms/admin/spreport.sql I am prompted for start and end snap id's, then I get this error message:
Phys Memory (MB):
~~~~
, e.seg_cr_bks_rc_th ecrb
*
ERROR at line 48:
ORA-00904: "E"."SEG_CU_BKS_RC_TH": invalid identifier
Any clues? I've checked the stats$snapshot table (where the column resides) and everything looks good. I've removed a custom glogin.sql to make sure there were no problems with certain sqlplus parameters for executing the script, still no luck.