Oracle-L: Anyone using YAPP? Possible bug in yapp

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 08 May 2003 09:51:47 -0800
Message-ID: <F001.005940D6.20030508095147@fatcity.com>

All, Im trying too use yapp to monitor statspack data http://miracleas.dk/en/tech.html

When I run
SQL> @yapp_rep
the script complains about a missing column, which turns out to be di.STARTUP_TIME

So the sql never finds a match and Im left with an empty.csv file

please see the sql and querries below
Is anyone using this? Or has suggestions for convienent viewing of the data?

thanks
Bob

#############################################
 16     and di.instance_number  = :inst_num
 17     and di.startup_time     = s.startup_time
 18   order by db_name, instance_name, snap_id;
   and di.startup_time     = s.startup_time
          *

ERROR at line 17:
ORA-00904: invalid column name

##############################################
select di.instance_name                                  inst_name


     , di.host_name                                      host_name

     , di.db_name                                        db_name

     , di.version                                        versn

     , di.parallel                                       para

     , to_char(s.startup_time,' dd Mon "at" HH24:mi:ss') instart_fmt

     , s.snap_id

     , to_char(s.snap_time,'dd Mon YYYY HH24:mi')       snapdat

     , s.snap_level                                      "level"

     , substr(s.ucomment, 1,60)                          "comment"

  from stats$snapshot s


     , stats$database_instance di

 where s.dbid              = :dbid
   and di.dbid             = :dbid
   and s.instance_number   = :inst_num
   and di.instance_number  = :inst_num
   and di.startup_time     = s.startup_time

order by db_name, instance_name, snap_id;

##############################################

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)

SQL>select table_name, column_name from user_tab_columns where column_name like 'START%';

STATS$SGAXS	STARTUP_TIME
STATS$SNAPSHOT	STARTUP_TIME

###############################################

-- 
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-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).

Received on Thu May 08 2003 - 12:51:47 CDT

Anyone using YAPP? Possible bug in yapp_rep?