Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long - running queries
The paremeter _SQLEXEC_PROGRESSION_COST controls the optimizer cost
used as the threshold for cutting off progression monitoring.
Progression monitoring involves extra function calls and row sources,
so this parameter is used to avoid the overhead for all SQL's. The
value defaults to 1000, but if set to zero, progression monitoring
will be turned off. If nonzero, then any statement with a costs less
than the value will not be monitored.
This parameter is turned off (set to 0) in some instances to avoid or
workaround certain bugs. Just check if thats the case in your instance
regards
Srivenu
Received on Wed Aug 04 2004 - 06:01:54 CDT
![]() |
![]() |