Hi,
a procedure (among others ...) is executed - every 10 mins.
Sometimes (nothing special happens) - the performance decreases (usualy takes less than 1 minute -> 6 minutes).
If I recompile the procedure - it works fine again.
Does anyone has an idea what the problem can be ?
Thank you !
a procedure (among others ...) is executed - every 10 mins.
Sometimes (nothing special happens) - the performance decreases (usualy takes less than 1 minute -> 6 minutes).
If I recompile the procedure - it works fine again.
Does anyone has an idea what the problem can be ?
Thank you !