[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