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

From: <Jared.Still_at_radisys.com>
Date: Thu, 08 May 2003 11:36:45 -0800
Message-ID: <F001.005944D4.20030508113645@fatcity.com>

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

"Bob Metelsky" <bmetelsky_at_cps92.com>
Sent by: root_at_fatcity.com
05/08/2003 10:51 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Anyone using YAPP? Possible bug in yapp_rep?

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




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

Received on Thu May 08 2003 - 14:36:45 CDT

Re: Anyone using YAPP? Possible bug in yapp_rep?