SQL Performance (MOSC)

MOSC Banner

OUTLINE

edited May 23, 2013 3:59AM in SQL Performance (MOSC) 11 commentsAnswered
After we upgrade 10g into 11g database, how can we check if the old outline is still using, I run the sql plan for this update statement, there is ouline used.

SQL>  select * from dba_outlines where name='CHECKBOX_PTJ';

NAME                           OWNER                          CATEGORY                       USED   TIMESTAMP           VERSION                                                          SQL_TEXT                                                                         SIGNATURE
------------------------------ ------------------------------ ------------------------------ ------ ------------------- ---------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------
COMPATIBLE   ENABLED  FORMAT MIGRATED
------------ -------- ------ ------------
CHECKBOX_PTJ                   SYS                            DEFAULT                        USED   2010-09-15:17:18:01 10.2.0.4.0                                                       update xxx set workqueue_id = :1 where workqueue_id = -:"SYS_B_0"  7BA3FA2C67F8E2C9F50B74ABD53771D7
COMPATIBLE   ENABLED  NORMAL NOT-MIGRATED

If it is not working, how can I fix this?

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