Re: Problem - V$BUFFER_POOL

From: Edward Shevtsov <ed_at_mb.ru>
Date: Sat, 20 Oct 2001 04:09:48 -0700
Message-ID: <F001.003B0B7D.20011020035518@fatcity.com>

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_at_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_at_yahoo.com            : <A
  href="">saurabh00pc_at_hotmail.comContact     : saurabh00pc @ MSN / Yahoo Received on Sat Oct 20 2001 - 06:09:48 CDT

Re: Problem - V$BUFFER_POOL_STATISTICS