Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Alam.

Asked: February 28, 2018 - 12:18 pm UTC

Last updated: March 06, 2018 - 2:21 am UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

i am getting this error everyday at 10 AM everyday kindly help me on this ,thanks in advance

Errors in file /u01/TBCCDDB/diag/rdbms/tbccd/TBCCD/trace/TBCCD_j003_19550.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_3196"
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 44417

TRACE FILE LAST LINES :

ChildNode: ChildNumber=4 ID=34 reason=Rolling Invalidate Window Exceeded(2) size=0x0 details=already_processed
ChildNode: ChildNumber=2 ID=40 reason=Bind mismatch(22) size=4x4 bind_position=12 original_oacflg=16 original_oacmxl=128 upgradeable_new_oacmxl=32
ChildNode: ChildNumber=0 ID=40 reason=Bind mismatch(22) size=4x4 bind_position=11 original_oacflg=16 original_oacmxl=32 upgradeable_new_oacmxl=128
ChildNode: ChildNumber=1 ID=40 reason=Bind mismatch(22) size=4x4 bind_position=12 original_oacflg=16 original_oacmxl=128 upgradeable_new_oacmxl=32
ChildNode: ChildNumber=1 ID=34 reason=Rolling Invalidate Window Exceeded(3) size=2x4 invalidation_window=1514112110 ksugctm=1514121094
ChildNode: ChildNumber=1 ID=34 reason=Rolling Invalidate Window Exceeded(2) size=0x0 details=already_processed
ChildNode: ChildNumber=0 ID=40 reason=Bind mismatch(22) size=4x4 bind_position=12 original_oacflg=16 original_oacmxl=32 upgradeable_new_oacmxl=128 DBMS_STATS: Subpartition : SYS_SUBP25506 Estimated size : 7450086 Segment Size : 19922944

*** 2018-02-27 22:07:18.514
DBMS_STATS: Subpartition : SYS_SUBP25225 Estimated size : 5409161 Segment Size : 14680064

*** 2018-02-27 22:07:20.212
DBMS_STATS: Subpartition : SYS_SUBP29126 Estimated size : 5702582 Segment Size : 13631488

*** 2018-02-27 22:07:21.906
DBMS_STATS: Subpartition : SYS_SUBP25498 Estimated size : 5150052 Segment Size : 11534336

*** 2018-02-27 22:07:22.252
ORA-12012: error on auto execute of job "SYS"."GATHER_STATS_JOB"
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 44417

and Connor said...

Take a look here

https://asktom.oracle.com/pls/asktom/asktom.search?tag=ora-08103object-no-longer-exists

Essentially whilst dbms_stats was running, some other process has performed a DDL on one of your partitions that meant the data in the partition either moved or was no longer accessible.

As a footnote, "GATHER_STATS_JOB" is a remnant from an older mechanism for gathering stats that was replaced in 11g wit auto tasks. Perhaps see if that job should be removed.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Alam Saad, March 05, 2018 - 10:58 am UTC

well actually this same job is running fine in my production system and is not throwing any error so i cant drop the job ,my boss wants me to fix this issue , also tell me the meaning of this thing ("Rolling Invalidate Window Exceeded" from the trace file i uploaded) also if you would like me to run any query on prod as well as test i will be more than happy to send its output
Connor McDonald
March 06, 2018 - 2:21 am UTC

From MOS Note 1229793.1

"Messages are informational only.Ignore the messages"


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.