[Orca-users] problem obtaining correct plots from oracle database stats data
nicholaspenney
nicholas at the-front.co.uk
Tue Jan 15 04:21:01 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