The cost of running dbanalys

pinne65

Member
Hello,

I'm curious to know if there is any significant performance cost to running proutil -C dbanalys against a database that's otherwise busy running mostly reports off hours.

TIA for any input.
 

TomBascom

Curmudgeon
Other than the IO that will occur as the db gets read there is no cost.

I try to avoid running it during busy periods if the system in question has IO constraints. But running in off hours when nothing much is happening is not a problem.
 
Top