Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Anyone using YAPP? Possible bug in yapp_rep?

Anyone using YAPP? Possible bug in yapp_rep?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US