<FONT face=Arial color=#0000ff
size=2>Statspack was created in v.8.1.6, but it is supposed to be compatible
with v.8.0.x and above.
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<FONT face="Times New Roman"
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Rajesh DayalSent:
Saturday, October 20, 2001 7:10 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Problem -
V$BUFFER_POOL_STATISTICS
<FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Wasn’t
statspack started with 8.1.6?
<FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Check
the docs…..
<FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Rajesh
<FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Tahoma color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original
Message-----From:
root_at_fatcity.com [mailto:root_at_fatcity.com]<SPAN
style="FONT-WEIGHT: bold">On Behalf Of Saurabh Sharma<SPAN
style="FONT-WEIGHT: bold">Sent: Saturday, October 20, 2001 3:05
PMTo: Multiple recipients of
list ORACLE-LSubject:
Problem - V$BUFFER_POOL_STATISTICS
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Hi
all,<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Is anyone
using Oracle Statspack for performance monitoring.<FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">I want to use
it, i ran the required scripts for creating the PERFSTAT schema, tables,
synonyms and STATSPACK package.<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">but the
package creation is giving problem with Dictionary table
V$BUFFER_POOL_STATISTICS( as it is not found in the database
dictionary)<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">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 face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">can anybody
explain me why it happened.<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">I'm using
Oracle 8.1.5 on NT.<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">thanks in
adv<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Saurabh
Sharma<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Mail
to : <A
href="">saurabh00pc_at_yahoo.com
: <A
href="">saurabh00pc_at_hotmail.comContact
: saurabh00pc @ MSN / Yahoo<SPAN
style="COLOR: black; mso-color-alt: windowtext">
Received on Sat Oct 20 2001 - 08:04:21 CDT
