Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Optimizer stats Gathering

edited Mar 27, 2017 5:00AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center