This discussion is archived
1 Reply Latest reply: Oct 20, 2012 10:04 PM by Walashkar RSS

Gather Stats-Upgrade

Walashkar Newbie
Currently Being Moderated
Dear All,

R11.5.10.2 upgrade to R 12.3

As per the upgrade guide, it is necesarry to run GATHER SCHEMA STATS (for all schemas) . our DB is 2.8 TB and runing the same for all schemas is tedious and will consume more time and will not be a feasible option during productiokn upgrade.

Please advise
  • 1. Re: Gather Stats-Upgrade
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    As per the upgrade guide, it is necesarry to run GATHER SCHEMA STATS (for all schemas) . our DB is 2.8 TB and runing the same for all schemas is tedious and will consume more time and will not be a feasible option during productiokn upgrade.
    You need to run Gather Schema Stats before you start the upgrade (before your actual downtime starts) and this should not impact the upgrade downtime.

    Oracle E-Business Suite Upgrade Guide Release 11i to 12.1.1 [ID 1082375.1]
    11i and R12: Are there any recommended/ideal Percentages for running Gather Schema Statistics across e-Business Suite? [ID 1184276.1]

    https://forums.oracle.com/forums/search.jspa?threadID=&q=GATHER+AND+SCHEMA+AND+Upgrade&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points