Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Gather Schema statistics failed with error

edited Aug 20, 2021 10:17AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Hi Team,

I am facing error while running Gather Schema Statistic as ORA-0000: normal, successful completion.

And the message in log file is as

+---------------------------------------------------------------------------+

Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDGSCST: Gather Schema Statistics

+---------------------------------------------------------------------------+

Current system time is 19-MAR-2018 18:57:49

+---------------------------------------------------------------------------+

**Starts**19-MAR-2018 18:57:49

**Ends**19-MAR-2018 22:12:18

ORA-0000: normal, successful completion

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 30 degree = 10 internal_flag= NOBACKUP

Error #1: ERROR: While GATHER_TABLE_STATS:

object_name=APPLSYS.WF_ITEM_ATTRIBUTE_VALUES***ORA-12801: error signaled in parallel query server P005

Tagged:

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