From ed@mb.ru Sat, 20 Oct 2001 04:09:48 -0700
From: "Edward Shevtsov" <ed@mb.ru>
Date: Sat, 20 Oct 2001 04:09:48 -0700
Subject: Re: Problem - V$BUFFER_POOL_STATISTICS
Message-ID: <F001.003B0B7D.20011020035518@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Hi <FONT face="ARIAL CYR" 
size=2>Saurabh,
 
have a look at 
$ORACLE_HOME/rdbms/admin/catperf.sql
It seems you didn't run it
 
Regards,
Ed
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Saurabh 
  Sharma 
  To: <A title=ORACLE-L@fatcity.com 
  href="">Multiple recipients of list ORACLE-L 
  
  Sent: Saturday, October 20, 2001 3:05 
  PM
  Subject: Problem - 
  V$BUFFER_POOL_STATISTICS
  
  Hi all,
  Is anyone using Oracle 
  Statspack for performance monitoring.
   
  I want to use it, i ran the 
  required scripts for creating the PERFSTAT schema, tables, synonyms and 
  STATSPACK package.
  but the package creation is 
  giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not 
  found in the database dictionary)
  The schema script created 
  the stat$buffer_pool_statistics table to use data from above dict table but 
  package could not be compiled successfully as dictionary table is not 
  found.
   
  can anybody explain me why 
  it happened.
   
  I'm using Oracle 8.1.5 on 
  NT.
  thanks in adv
   
  Saurabh Sharma
   
  Mail to   : <A 
  href="">saurabh00pc@yahoo.com          
  : <A 
  href="">saurabh00pc@hotmail.comContact   
  : saurabh00pc @ MSN / Yahoo