[Orca-users] Re: FW: problem obtaining correct plots from oracledatabase data
Erik Melander
EMelander at wyndham.com
Thu Jan 10 14:05:01 PST 2002
Thank you much! :)
On Thu, 2002-01-10 at 15:56, Nicholas Penney wrote:
>
> 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
>
>
>
>
>
>
More information about the Orca-users
mailing list