[Orca-users] Re: Oracle Stats

[Sean O'Neill]

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