Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

DBMS_STATS.GATHER_SCHEMA_STATS before db upgrade question

edited Mar 6, 2018 10:41AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered ✓

We are upgrading (before we upgrade Oracle Receivables app in EBS from 11i to R12.1.3) Oracle db from 9.2.0.6.0 to 10.2.0.5.

Question: so, before we run Database Upgrade Assistant we are running gather_schema_stats  for 2 schemas SYS and MDSYS ...  should we run it for every schema in EBS? Would it improve the runtime for the upgrade or 2 schemas  to gather stats on is ok?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center