[Orca-users] Re: Oracle Stats

[dominic_kailath at nylim.com]

 Sean,

   It is funny you came up this answer for my question on mktime. Because
"perl -e print time"
was exactly what I replaced mktime with.

Is this  " Great minds thinking alike ------- or  what "

Dominic
_______________________________________________________
Dominic Kailath
Unix Systems Administrator                      dominic_kailath at nylim.com
NYLIM - Parsippany, NJ


                                                                                                           
                      "Sean O'Neill"                                                                       
                      <sean at seanoneill         To:      orca-users at yahoogroups.com                         
                      .info>                   cc:                                                         
                                               Subject: Re: [orca-users] Oracle Stats                      
                      09/19/02 02:26                                                                       
                      PM                                                                                   
                      Please respond                                                                       
                      to orca-users                                                                        
                                                                                                           
                                                                                                           




One comment and a favor:

- Comment - I remember someone asking about the /usr/local/bin/mktime being

used in these scripts.  Well, I don't have it either but if I'm not
mistaken, the following will work just as well - assuming you have Perl
that is:

Change this:

SECONDS_TIME=`/usr/local/bin/mktime -F '%t' -D ${T_SECS}`

to this:

SECONDS_TIME=`perl -e 'print time'`

- Favor - I asked one of our DBAs about letting me poke at the DB with this

thing - every minute.  She and I got into a LONG debate concerning the
overhead this thing (she claims) produces.  She also says this is a
duplicate collection activity as the DBAs are already using the Oracle
Stats pack - which technically it is.  But only once a minute .. come on.

So my favor is can someone send me a timex or something related that shows
just how much clock time and CPU time the db_metrics.sql script when
executed uses.  Also, impressions on why /heavy/ this db_metrics.sql.  I
expect it to be fairly light.

Thanks.


--
........................................................
......... ..- -. .. -..- .-. ..- .-.. . ... ............
.-- .. -. -... .-.. --- .-- ... -.. .-. --- --- .-.. ...

Sean O'Neill