[Orca-users] FW: problem obtaining correct plots from oracledatabase data
Nicholas Penney
nicholas at the-front.co.uk
Thu Jan 10 13:56:27 PST 2002
Here you go. Please note that the scripts are pretty basic - they were
written by a DBA :)
-----Original Message-----
From: Erik Melander [mailto:emelander at wyndham.com]
Sent: 09 January 2002 17:34
To: orca-discuss at yahoogroups.com
Cc: nicholas at the-front.co.uk
Subject: Re: [orca-discuss] problem obtaining correct plots from
oracledatabase data
Any chance you could share the scripts used to generate the Oracle
stats? Orca would be a great way to unify our performance monitoring
(and unfortunately I don't know enough about databases to show what Orca
can do). Thanks! nicholas at the-front.co.uk On Wed, 2002-01-09 at 11:17,
nicholas at the-front.co.uk wrote: Hi,
I am running the latest versions of the se toolkit and orca on a Sun
E4800 server. I am receiving a data file from the DBA's containing
database stats as listed below. I want to plot, for instance, the
HR*/db_rbsNN_wait_ratio so that I get a separate plot for each database
(HR11A and HR12A) with each plot containing all of the
db_rbsNN_wait_ratio values for the database.
I
have enclosed the code I am using to generate the plot (below the
datafile extract).
Until today I have only been receiving data for a single database
instance, and the plots have been fine. Now that I am receiving 2
databases data I do not see a separate plot for each database, nor do I
see both databases listed on a single plot.
Can you please help by pointing me in the right direction of the code
required to obtain the plots I am after?
Thanks in advance.
Extract from data file orca_ora_stats-2002-01-09-000:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
timestamp locltime HR11A/db_buff_cache_ratio
HR11A/db_lib_cache_ratio HR11A/db_dict_cache_ratio
HR11A/db_sort_ratio
HR11A/db_free_buffer_wait
HR11A/db_buffer_busy_wait HR11A/db_enq_wait_ratio
HR11A/db_phys_reads
HR11A/db_phys_writes HR11A/db_sga_free_memory HR11A/db_trans_per_sec
HR11A/db
_sessions HR11A/db_active_sessions HR11A/db_redo_log_space_reqs
HR11A/db_fetch_cont_rows HR11A/db_rbs01_wait_ratio
HR11A/db_rbs02_wait_ratio HR11A/d
b_rbs03_wait_ratio HR11A/db_rbs04_wait_ratio
HR11A/db_rbs05_wait_ratio
HR11A/db_rbs06_wait_ratio HR11A/db_rbs07_wait_ratio
HR11A/db_rbs08_wait_ratio
HR11A/db_rbs09_wait_ratio HR11A/db_rbs10_wait_ratio
HR11A/db_rbs01_gets
HR11A/db_rbs02_gets HR11A/db_rbs03_gets HR11A/db_rbs04_gets
HR11A/db_rbs05_
gets HR11A/db_rbs06_gets HR11A/db_rbs07_gets HR11A/db_rbs08_gets
HR11A/db_rbs09_gets HR11A/db_rbs10_gets HR12A/db_buff_cache_ratio
HR12A/db_lib_cach
e_ratio HR12A/db_dict_cache_ratio HR12A/db_sort_ratio
HR12A/db_free_buffer_wait HR12A/db_buffer_busy_wait
HR12A/db_enq_wait_ratio HR12A/db_phys_read
s HR12A/db_phys_writes HR12A/db_sga_free_memory
HR12A/db_trans_per_sec
HR12A/db_sessions HR12A/db_active_sessions
HR12A/db_redo_log_space_reqs
HR1
2A/db_fetch_cont_rows HR12A/db_rbs01_wait_ratio
HR12A/db_rbs02_wait_ratio HR12A/db_rbs03_wait_ratio
HR12A/db_rbs04_wait_ratio HR12A/db_rbs05_wait_rati
o HR12A/db_rbs06_wait_ratio HR12A/db_rbs07_wait_ratio
HR12A/db_rbs08_wait_ratio HR12A/db_rbs09_wait_ratio
HR12A/db_rbs10_wait_ratio HR12A/db_rbs01_g
ets HR12A/db_rbs02_gets HR12A/db_rbs03_gets HR12A/db_rbs04_gets
HR12A/db_rbs05_gets HR12A/db_rbs06_gets HR12A/db_rbs07_gets
HR12A/db_rbs08_gets
HR12A/db_rbs09_gets HR12A/db_rbs10_gets
1010534458 00:00:58 99.32
99.95 99.22 .041474159
0
5 6.4749E-06
269958
18489 79 0
28 10 11
2 .00062101 .0006617
0 .000925326
.000238127
.00092967 .000304077 0
.000897513 0
3043
3051 3077 3056
3050 3038 80145 3106
3039 3027 99.64
99.96 99.23 .099729581
0 0 2.3006E-06
230
0 185
9 0
17 10 1
32 .001969512
0 0 0
0 0 0
0 0 0
29 25 25 25
25 89 25 25
100 44
1010538024 01:00:24 99.32
99.95 99.22 .041527065
0
0 6.4636E-06
34
177 77 0
27 9 0
0 .000619867 .000660428
0 .000922816
.000238113
.000927162 .000246415 0
.000895143 0
297
291 368 294
291 291 76955 296
295 291 99.63
99.96 99.25 .098468543
0 0 2.2943E-06
32425
9 5315
11 0
15 9 5
4 .001907196
0 0 0
0 0 0
0 0
0 1
659 1654 1656 1655
1664 1744 1669 1649
1645 1728
Extract from orcallator.cfg:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
group oracle {
find_files
/var/orca/data/(.*)/(?:orca_ora_stats)-\d{4}-\d{2}-\d{2}(?:-\d{3,})?(?:\
.(?:
Z|gz|bz2))?
column_description first_line
date_source column_name timestamp
interval 3600
filename_compare sub {
my ($ay, $am, $ad) = $a =~
/-(\d{4})-(\d\d)-(\d\d)/;
my ($by, $bm, $bd) = $b =~
/-(\d{4})-(\d\d)-(\d\d)/;
if (my $c = (( $ay <=> $by) ||
( $am <=> $bm) ||
(($ad >> 3) <=> ($bd >> 3)))) {
return 2*$c;
}
$ad <=> $bd;
}
}
...
plot {
title %g Rollback Segment Wait Percent
source oracle
data (.*)(?:/)(db_rbs\d\d_wait_ratio)
line_type line2
legend $2
y_legend Percent
data_max 100
data_min 0
}
--
Nicholas Penney, UNIX Support
ING Barings
Tel: +44 (0)20 7767 6608
Email: nicholas.penney at ing-barings.com
------------------------------------------------------------------------
------
The information in this Internet email is confidential and may be
legally privileged. It is intended solely for the addressee. Access
to this Internet email by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on
it, is prohibited and may be unlawful. When addressed to our clients any
opinions or advice contained in this Internet email are subject to the
terms and conditions expressed in any applicable governing ING Barings'
terms of business or client engagement letter.
Visit us at www.ingbarings.com
------------------------------------------------------------------------
------
Yahoo! Groups Sponsor
ADVERTISEMENT
-------------- next part --------------
A non-text attachment was scrubbed...
Name: orca_oracle_scripts.tar
Type: application/x-tar
Size: 9728 bytes
Desc: not available
URL: </pipermail/orca-users/attachments/20020110/6e1b19f2/attachment.tar>
More information about the Orca-users
mailing list