[Orca-users] problem obtaining correct plots from oracle database data
Nicholas Penney
nicholas at the-front.co.uk
Sun Jan 13 05:41:53 PST 2002
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
}
More information about the Orca-users
mailing list