| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Anyone using YAPP? Possible bug in yapp_rep?
It doesn't run on 8.1.6 - the statspack tables for that version don't include certain columns - notably stats$database_instance.version & stats$database_instance.parallel. You'll have to change the sql in yapp_rep.sql and yapp_run.sql (change the vstr to a varchar2 & default it to 8 and comment out the select later on in the code.
Here's what I wound up with after changing it:
(See attached file: yapp_rep_8.1.6.sql)(See attached file:
yapp_run_8.1.6.sql)
Jared.Still_at_radisys.com
T
Sent by: To: Multiple recipients of list ORACLE-L
root_at_fatcity.com <ORACLE-L_at_fatcity.com>
cc:
bcc:
05/08/03 04:45 PM Subject: Re: Anyone
Please respond to using YAPP? Possible bug in yapp_rep?
ORACLE-L
Which database version is it?
Could be that YAPP requires 8.1.7, and you're on 8.1.6.
Or, you upgraded your database, but didn't upgrade statspack?
Jared
"Bob Metelsky" <bmetelsky_at_cps92.com>
Sent by: root_at_fatcity.com
05/08/2003 01:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Re: Anyone using YAPP? Possible bug in yapp_rep?
Works for me.
Make sure you are logged into the statspack account ( perfstat ) when you run the report. Assuming that you created yappack in the same account as statspack of course.
Jared
The old
"works on my machine..."
;-)
Unless yapp modifies the statspack columns... I don't have the startup_time that yap_rep is referring to.
I followed the readme and
Logged on as perfstat
Ran @yapp_prepare
Then @yapp_rep
LOCDB SQL> show user;
USER is "PERFSTAT"
LOCDB SQL> select table_name from cat;
TABLE_NAME
STATS$BG_EVENT_SUMMARY STATS$BUFFER_POOL STATS$BUFFER_POOL_STATISTICS STATS$DATABASE_INSTANCE STATS$ENQUEUESTAT STATS$FILESTATXS STATS$IDLE_EVENT STATS$LATCH STATS$LATCH_CHILDREN STATS$LATCH_MISSES_SUMMARY STATS$LEVEL_DESCRIPTION STATS$LIBRARYCACHE STATS$PARAMETER STATS$ROLLSTAT STATS$ROWCACHE_SUMMARY STATS$SESSION_EVENT STATS$SESSTAT STATS$SGASTAT_SUMMARY STATS$SGAXS STATS$SNAPSHOT STATS$SNAPSHOT_ID STATS$SQL_SUMMARY STATS$STATSPACK_PARAMETER STATS$SYSSTAT STATS$SYSTEM_EVENT STATS$WAITSTAT YAPP_CSV YAPP_EVENT YAPP_IDLE_EVENT
stats$database_instance.startup time
Which is not in my statspack table.
SQL>desc STATS$DATABASE_INSTANCE;
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
DB_NAME NOT NULL VARCHAR2(9)
INSTANCE_NAME NOT NULL VARCHAR2(16)
HOST_NAME VARCHAR2(64)
, stats$database_instance di
and di.startup_time = s.startup_time
Possibly I have a old version of statspack?
Thanks
bob
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: bmetelsky_at_cps92.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu May 08 2003 - 16:37:28 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: DEEDSD_at_Nationwide.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
- application/octet-stream attachment: yapp_rep_8.1.6.sql
- application/octet-stream attachment: yapp_run_8.1.6.sql
 |
 |