From hamcdc@yahoo.co.uk Sat, 20 Oct 2001 08:04:32 -0700 From: =?iso-8859-1?q?Connor=20McDonald?= Date: Sat, 20 Oct 2001 08:04:32 -0700 Subject: RE: Problem - V$BUFFER_POOL_STATISTICS Message-ID: MIME-Version: 1.0 Content-Type: text/plain Saurabh, Also note that you want to DROP this before you upgrade to 8.1.6 (I think?) where this becomes a fixed view. If you don't, you can end up with a view that is invalid and cannot be dropped. Also, in 8.1.7(?), there is a bug in the view where some of the fields are incorrectly zero - its fixed in a patch set. hth connor --- Steve Adams wrote: > 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@yahoo.com > : saurabh00pc@hotmail.com > Contact : saurabh00pc @ MSN / Yahoo > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Steve Adams > INET: steve.adams@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@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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc@yahoo.co.uk 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@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).