Hi,
when looking at Oracle EM activity, I am seeing the following as a top consumer
every hour:
SELECT MIN(time_stamp) FROM RHQ_MEASUREMENT_DATA_NUM_1H
That minimum value only changes after a data purge, so it should be possible to
take the (theoretical) minimum from after the purge, store it e.g. in the systems table
and retrieve it with a single select.
Of course this once per hour thing is no real big deal, but nicely shows where we
have potential for optimization - especially as the above select adds to the duration
of the hourly purge job, which stresses the database job anyway.
Heiko
--
Reg. Adresse: Red Hat GmbH, Otto-Hahn-Strasse 20, 85609 Dornach bei München
Handelsregister: Amtsgericht München HRB 153243
Geschaeftsführer: Brendan Lane, Charlie Peters, Michael Cunningham, Charles Cachera
Show replies by date