RE: Staspack Grapher/Viewer ?
Ah, that makes much more sense to me. That's more the idea I had in mind when I installed STATSPACK. That, and the ability to be able to look back in time to potentially see why our nightly jobs are still running at 8:00 AM. (insert system-stats-vs-session-stats argument here) :) Thanks, Dennis! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Staspack Grapher/Viewer ? Sent: Thursday, September 19, 2002 2:55 PM To: '[EMAIL PROTECTED]' Rich - I think the original poster mentioned Don Burleson's book. Don suggests you take multiple STATSPACK snapshots over time, say every hour for a week, then query the STATSPACK tables directly to, say graph database transactions over time. From this you can identify the peak times your database is being used, either day of week, or time of day. Once you identify the peak usage times, you can drill in deeper to identify the problems in that area, like maybe the waits. You may perform some small-interval STATSPACK snapshots in that time area. Don presents a simple idea of doing a simple query and then cutting an pasting that into MS Excel. I've done this and you can create some pretty impressive-looking charts very quickly. The drawback is that method is pretty labor-intensive and it is easy to make an error and produce an erroneous chart. I would highly recommend it as a prototype method, or if you are a consultant that needs to quickly produce some impressive charts for your clients. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
http://www.statsviewer.narod.ru fantastic product. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Sent: 19 September 2002 15:39 PM To: Multiple recipients of list ORACLE-L Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
We use MRTG to produce graphs for data from different sources network stats, hardware stats, database stats. Maybe you could use it for statspack. -Original Message- Sent: Thursday, September 19, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
This one isn't free, it's charged on a per instance basis, looks quite nice though: http://www.geocities.com/alexdabr/ === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Sent: 19 September 2002 14:39 To: Multiple recipients of list ORACLE-L Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
Here is something I am playing around with. The idea came from Burleson's Statspack
book. It requires Active Perl with DBD/DBI installed. Also MS Graph is used. This
is still a work in progress.
#!C:\Perl\bin\perl.exe -w
#
# rpt_avg_bbw_dy.pl
# Report Average Buffer Busy Wait by Day
# This perl script will produce a graphical
# Signature of information.
# This information is obtained from statspack tables
# and takes advantage of perl's Win32 OLE interface
# to Microsoft Graph.
#
use DBI;
use Win32::OLE qw( with in );
use Win32::OLE::Const Microsoft Graph;
#
# Set Oracle User and Password Information
#
$name= perfstat;
$passwd = x;
$ora_sid = PROD;
# 1 makes creation process visible. 0 is faster.
my $VISIBLE = 1;
my $iIndex = 0;
#
# Make connection to Database
#
$dbh = DBI-connect(dbi:Oracle:$ora_sid, $name, $passwd)
or die Cannot connect : $DBI::errstr;
#
# Prepare Statement to query database
#
$sth = $dbh-prepare(select to_char(snap_time,'day') day,
avg(new.buffer_busy_wait-old.buffer_busy_wait) bbw from
perfstat.stats\$buffer_pool_statistics old,
perfstat.stats\$buffer_pool_statistics new,
perfstat.stats\$snapshot sn
where
new.snap_id = sn.snap_id
and
old.snap_id = sn.snap_id-1
group by
to_char(snap_time,'day') )
||die Can't prepare statement: $DBI::errstr;
$sth-execute ()
||die Can't execute statement: $DBI::errstr;
while (($day, $bbw) = $sth-fetchrow_array)
{ # loop thru, retrieving data
$Data[$iIndex] = [$day, $bbw];
$iIndex = $iIndex + 1;
}
my %ChartOptions = (
width = 640,
height = 400,
haslegend = 0,
type = xl3DLine,
perspective = 30,
rotation = 20,
autoscaling = 1,
rightangleaxes = 1,
title = Buffer Busy Wait Signature by Day,
);
my( @CELLS ) = ( 'a'..'zz' );
my $File = C:\\temp\\bbw_day.gif;
# BEGIN CALLOUT A
# new() method creates an instance of MS Graph's Application object.
# To have a remote machine create the chart (DCOM) then change MSGraph.Application
# parameter to an anonymous array [appserver.mydomain.com,MSGraph.Application]
my $ChartApp = new Win32::OLE( MSGraph.Application, Quit ) ||
die Cannot create object\n;
# END CALLOUT A
$ChartApp-{Visible} = $VISIBLE;
# BEGIN CALLOUT B
my $DataSheet = $ChartApp-DataSheet();
my $Chart = $ChartApp-Chart();
# END CALLOUT B
foreach my $Option ( keys( %ChartOptions ) )
{
$Chart-{$Option} = $ChartOptions{$Option};
}
# BEGIN CALLOUT C
my $iTotal = $#Data;
foreach my $iIndex ( 0 .. $iTotal)
{
my $iday = $Data[$iIndex][0];
my $ibbw = $Data[$iIndex][1];
$DataSheet-Range( $CELLS[$iIndex]0 )-{Value} = $iday;
$DataSheet-Range( $CELLS[$iIndex]1 )-{Value} = $ibbw;
}
# END CALLOUT C
print \n;
# Configure the X axis.
if( my $Axis = $Chart-Axes( xlCategory ) )
{
$Axis-{HasMajorGridlines} = 0;
$Axis-{TickLabels}-{orientation} = xlUpward;
with( $Axis-{TickLabels}-{Font},
Name = Tahoma,
Bold = 0,
Italic = 0
);
}
# Configure the Y axis.
if( my $Axis = $Chart-Axes( xlValue ) )
{
$Axis-{HasMajorGridlines} = 1;
$Axis-{MajorGridlines}-{Border}-{Weight} = 1;
$Axis-{MajorGridlines}-{Border}-{ColorIndex} = 48;
$Axis-{MajorGridlines}-{Border}-{LineStyle} = xlContinuous;
with( $Chart-Axes( xlValue )-{TickLabels}-{Font},
Name = Tahoma,
Bold = 0,
Italic = 0
);
}
# BEGIN CALLOUT D
# Configure data-point labels.
$Chart-SeriesCollection( 1 )-{HasDataLabels} = 1;
if( my $Labels = $Chart-SeriesCollection(1)-DataLabels() )
{
with( $Labels,
NumberFormat = #.0,
Type = xlDataLabelsShowValue
);
with( $Labels-{Font},
Name = Tahoma,
Bold = 0,
Italic = 0,
);
}
if( defined $ChartOptions{title} )
{
$Chart-{HasTitle} = 1;
$Chart-{ChartTitle}-{Text} = $ChartOptions{title};
$Chart-{ChartTitle}-{Font}-{Name} = Tahoma;
$Chart-{ChartTitle}-{Font}-{Size} = 18;
}
# Remove consecutive redundant data-point labels.
$iTotal = $Chart-SeriesCollection( 1 )-Points()-{Count};
$iIndex = 0;
my $PrevText = ;
foreach my $Point (in( $Chart-SeriesCollection( 1 )-Points()))
{
my $Percent = int( ++$iIndex * 100 / $iTotal );
my $Text = $Point-{DataLabel}-{Text};
$Point-{MarkerStyle} = xlMarkerStyleDot;
$Point-{DataLabel}-{Font}-{Background} = xlBackgroundOpaque;
$Point-{DataLabel}-{Top} -= 12;
$Point-{HasDataLabel} = 0 if( $Text eq $PrevText );
$PrevText = $Text;
print \rFormatting: $Percent%;
}
# END CALLOUT D
print \n;
print Exporting to GIF file: $File\n;
# BEGIN CALLOUT E
$Chart-Export( $File, GIF, 0 );
# END CALLOUT E
`start $File`;
# print Press Enter to continue...;
# STDIN;
-Original
RE: Staspack Grapher/Viewer ?
This product seems to use the now infamous CHR which has been banned from this list :) Has anyone figured out how to use MRTG (or Cricket) to get this done? [Why buy when you can use Open Source!] John -Original Message- From: George Leonard (ZA) [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 7:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Staspack Grapher/Viewer ? http://www.statsviewer.narod.ru fantastic product. George George Leonard Oracle Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
MRTG is good stuff but doesn't it use RRDTool. We have used RRDTool with great success. -Original Message- Sent: Thursday, September 19, 2002 8:58 AM To: Multiple recipients of list ORACLE-L We use MRTG to produce graphs for data from different sources network stats, hardware stats, database stats. Maybe you could use it for statspack. -Original Message- Sent: Thursday, September 19, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
And if you don't want to use MS Graph, you can use
Perl's built-in graphing facility (see Programming
Perl) or gnuplot.
I had developed something similar at a previous gig
but I used gnuplot.
mkb
--- Gesler, Rich [EMAIL PROTECTED] wrote:
Here is something I am playing around with. The
idea came from Burleson's Statspack book. It
requires Active Perl with DBD/DBI installed. Also
MS Graph is used. This is still a work in progress.
#!C:\Perl\bin\perl.exe -w
#
# rpt_avg_bbw_dy.pl
# Report Average Buffer Busy Wait by Day
# This perl script will produce a graphical
# Signature of information.
# This information is obtained from statspack tables
# and takes advantage of perl's Win32 OLE interface
# to Microsoft Graph.
#
use DBI;
use Win32::OLE qw( with in );
use Win32::OLE::Const Microsoft Graph;
#
# Set Oracle User and Password Information
#
$name= perfstat;
$passwd = x;
$ora_sid = PROD;
# 1 makes creation process visible. 0 is faster.
my $VISIBLE = 1;
my $iIndex = 0;
#
# Make connection to Database
#
$dbh = DBI-connect(dbi:Oracle:$ora_sid, $name,
$passwd)
or die Cannot connect : $DBI::errstr;
#
# Prepare Statement to query database
#
$sth = $dbh-prepare(select
to_char(snap_time,'day') day,
avg(new.buffer_busy_wait-old.buffer_busy_wait) bbw
from
perfstat.stats\$buffer_pool_statistics old,
perfstat.stats\$buffer_pool_statistics new,
perfstat.stats\$snapshot sn
where
new.snap_id = sn.snap_id
and
old.snap_id = sn.snap_id-1
group by
to_char(snap_time,'day') )
||die Can't prepare statement: $DBI::errstr;
$sth-execute ()
||die Can't execute statement: $DBI::errstr;
while (($day, $bbw) = $sth-fetchrow_array)
{ # loop thru, retrieving data
$Data[$iIndex] = [$day, $bbw];
$iIndex = $iIndex + 1;
}
my %ChartOptions = (
width = 640,
height = 400,
haslegend = 0,
type = xl3DLine,
perspective = 30,
rotation = 20,
autoscaling = 1,
rightangleaxes = 1,
title = Buffer Busy Wait Signature by Day,
);
my( @CELLS ) = ( 'a'..'zz' );
my $File = C:\\temp\\bbw_day.gif;
# BEGIN CALLOUT A
# new() method creates an instance of MS Graph's
Application object.
# To have a remote machine create the chart (DCOM)
then change MSGraph.Application
# parameter to an anonymous array
[appserver.mydomain.com,MSGraph.Application]
my $ChartApp = new Win32::OLE(
MSGraph.Application, Quit ) ||
die Cannot create object\n;
# END CALLOUT A
$ChartApp-{Visible} = $VISIBLE;
# BEGIN CALLOUT B
my $DataSheet = $ChartApp-DataSheet();
my $Chart = $ChartApp-Chart();
# END CALLOUT B
foreach my $Option ( keys( %ChartOptions ) )
{
$Chart-{$Option} = $ChartOptions{$Option};
}
# BEGIN CALLOUT C
my $iTotal = $#Data;
foreach my $iIndex ( 0 .. $iTotal)
{
my $iday = $Data[$iIndex][0];
my $ibbw = $Data[$iIndex][1];
$DataSheet-Range( $CELLS[$iIndex]0 )-{Value} =
$iday;
$DataSheet-Range( $CELLS[$iIndex]1 )-{Value} =
$ibbw;
}
# END CALLOUT C
print \n;
# Configure the X axis.
if( my $Axis = $Chart-Axes( xlCategory ) )
{
$Axis-{HasMajorGridlines} = 0;
$Axis-{TickLabels}-{orientation} = xlUpward;
with( $Axis-{TickLabels}-{Font},
Name = Tahoma,
Bold = 0,
Italic = 0
);
}
# Configure the Y axis.
if( my $Axis = $Chart-Axes( xlValue ) )
{
$Axis-{HasMajorGridlines} = 1;
$Axis-{MajorGridlines}-{Border}-{Weight} = 1;
$Axis-{MajorGridlines}-{Border}-{ColorIndex} =
48;
$Axis-{MajorGridlines}-{Border}-{LineStyle} =
xlContinuous;
with( $Chart-Axes( xlValue
)-{TickLabels}-{Font},
Name = Tahoma,
Bold = 0,
Italic = 0
);
}
# BEGIN CALLOUT D
# Configure data-point labels.
$Chart-SeriesCollection( 1 )-{HasDataLabels} = 1;
if( my $Labels =
$Chart-SeriesCollection(1)-DataLabels() )
{
with( $Labels,
NumberFormat = #.0,
Type = xlDataLabelsShowValue
);
with( $Labels-{Font},
Name = Tahoma,
Bold = 0,
Italic = 0,
);
}
if( defined $ChartOptions{title} )
{
$Chart-{HasTitle} = 1;
$Chart-{ChartTitle}-{Text} =
$ChartOptions{title};
$Chart-{ChartTitle}-{Font}-{Name} = Tahoma;
$Chart-{ChartTitle}-{Font}-{Size} = 18;
}
# Remove consecutive redundant data-point labels.
$iTotal = $Chart-SeriesCollection( 1
)-Points()-{Count};
$iIndex = 0;
my $PrevText = ;
foreach my $Point (in( $Chart-SeriesCollection( 1
)-Points()))
{
my $Percent = int( ++$iIndex * 100 / $iTotal );
my $Text = $Point-{DataLabel}-{Text};
$Point-{MarkerStyle} = xlMarkerStyleDot;
$Point-{DataLabel}-{Font}-{Background} =
xlBackgroundOpaque;
$Point-{DataLabel}-{Top} -= 12;
RE: Staspack Grapher/Viewer ?
I have a 1.5 MB zip file containing my old web site for called gnumetrics which uses a PL/SQL package and MRTG to chart performance data. If someone has a webserver I can load this to I will. It is old but it works. At the very least you will get some ideas on how to do this. I store all my data internally now using the same aggregation policy as MRTG to get up to one year of data in very small size. I chart it using ODBC an Access with Microsoft Graph. Works very well and I get very useful reports. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, September 19, 2002 12:10 PM To: Multiple recipients of list ORACLE-L This product seems to use the now infamous CHR which has been banned from this list :) Has anyone figured out how to use MRTG (or Cricket) to get this done? [Why buy when you can use Open Source!] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
This has me thinking. What exactly do you want to graph? I guess I'm just trying to see some value in graphing data from a single SP report. Graph waits as a pie chart? Or would it be for several reports combined? Also, after looking again at the layout of an SP report, a home-rolled query would do much better at feeding MRTG or GNUPLOT. Just wondering if I can get myself into yet another project... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Staspack Grapher/Viewer ? This product seems to use the now infamous CHR which has been banned from this list :) Has anyone figured out how to use MRTG (or Cricket) to get this done? [Why buy when you can use Open Source!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Staspack Grapher/Viewer ?
Sent: Thursday, September 19, 2002 2:55 PM To: '[EMAIL PROTECTED]' Rich - I think the original poster mentioned Don Burleson's book. Don suggests you take multiple STATSPACK snapshots over time, say every hour for a week, then query the STATSPACK tables directly to, say graph database transactions over time. From this you can identify the peak times your database is being used, either day of week, or time of day. Once you identify the peak usage times, you can drill in deeper to identify the problems in that area, like maybe the waits. You may perform some small-interval STATSPACK snapshots in that time area. Don presents a simple idea of doing a simple query and then cutting an pasting that into MS Excel. I've done this and you can create some pretty impressive-looking charts very quickly. The drawback is that method is pretty labor-intensive and it is easy to make an error and produce an erroneous chart. I would highly recommend it as a prototype method, or if you are a consultant that needs to quickly produce some impressive charts for your clients. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 3:03 PM To: Multiple recipients of list ORACLE-L This has me thinking. What exactly do you want to graph? I guess I'm just trying to see some value in graphing data from a single SP report. Graph waits as a pie chart? Or would it be for several reports combined? Also, after looking again at the layout of an SP report, a home-rolled query would do much better at feeding MRTG or GNUPLOT. Just wondering if I can get myself into yet another project... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Staspack Grapher/Viewer ? This product seems to use the now infamous CHR which has been banned from this list :) Has anyone figured out how to use MRTG (or Cricket) to get this done? [Why buy when you can use Open Source!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
