RE: Problem - V$BUFFER_POOL_STATISTICS

Hi Saurabh,

Try running $ORACLE_HOME/rdbms/admin/catperf.sql first.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au/ - For all

-----Original Message-----
Sent: Saturday, 20 October 2001 21:05
To: Multiple recipients of list ORACLE-L

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   : saurabh00pc_at_yahoo.com
          : saurabh00pc_at_hotmail.com
Contact   : saurabh00pc @ MSN / Yahoo

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).