Database Tuning (MOSC)

MOSC Banner

I upgrade my database from 10.1.0.5 To 11.2.0.3 the I had got problem with statistics stale

edited Oct 8, 2012 6:31AM in Database Tuning (MOSC) 14 commentsAnswered

hello guru,

    I explain my Problem Description
---------------------------------------------------
for upgrade my database from 10.1.0.5 to 11.2.0.3

I read the note 881505.1 and I have question "before ugrade and dbua".

I have executed @utlu112i. 5 I can not delete the "stale statitics"
I execute next :

@checkStaleStatis.sql
-- There are no stale statistics in CTXSYS schema.

-- There are no stale statistics in DMSYS schema.

-- There are no stale statistics in MDSYS schema.

-- There are no stale statistics in OLAPSYS schema.

-- There are no stale statistics in ORDSYS schema.


-------------------------------------------------------------------------------------------------------
-- SYS schema contains stale statistics use the following to gather the statistics --

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