Optimizer stats Gathering
Hi,
Can someone gives clear idea regarding Stats Gather parameters
purpose of using
METHOD_OPT
ESTIMATE_PERCENT
and also when we give degree for parallelism, How to monitor parallelism is getting used or not ,
If its getting used what is degree it is using , Just like how we check DEGREE in DBA_DATAPUMP_JOBS view.
Thanks and regards
Srikanth Linga.