| 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?
Actually, it will even work on 8.0 if you want to tweak it. :)
Jared
DEEDSD_at_Nationwide.com
Sent by: root_at_fatcity.com
05/08/2003 02:37 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?
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 - 19:11:42 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).The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification. --=_mixed 007F8B9288256D20_=-- -- 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).
- application/octet-stream attachment: yapp_rep_8.1.6.sql
- application/octet-stream attachment: yapp_run_8.1.6.sql
 |
 |