| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem - V$BUFFER_POOL_STATISTICS
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Wasn’t statspack
started with 8.1.6?
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Check the
docs…..
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Rajesh
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Saurabh
Sharma
Sent: Saturday, October 20, 2001
3:05 PM
To: Multiple recipients of list
ORACLE-L
Subject: Problem -
V$BUFFER_POOL_STATISTICS
<span
style='font-size:12.0pt'>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>Hi all,<span style='color:black;
mso-color-alt:windowtext'>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>Is anyone using Oracle Statspack for performance monitoring.<font
color=black>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>I want to use it, i ran the required scripts for creating the
PERFSTAT schema, tables, synonyms and STATSPACK package.<font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>but the package creation is giving problem with Dictionary table
V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary)<font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>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.<span
style='color:black;mso-color-alt:windowtext'>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>can anybody explain me why it happened.<font
color=black>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>I'm using Oracle 8.1.5 on NT.<span
style='color:black;mso-color-alt:windowtext'>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>thanks in adv<span
style='color:black;mso-color-alt:windowtext'>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>Saurabh Sharma<span
style='color:black;mso-color-alt:windowtext'>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>Mail to : saurabh00pc_at_yahoo.com
: <a
href="">saurabh00pc_at_hotmail.com
Contact : saurabh00pc @ MSN / Yahoo<span
style='color:black;mso-color-alt:windowtext'>
Received on Sat Oct 20 2001 - 06:16:53 CDT
 |
 |