R12 GSS hangs

GSS for ALL got struck. ( Reason: Gather Schema Statistics concurrent program hung on an external tables. GSS can't collect stats on external tables)

SOL: This problem is a known bug and Oracle has given patch 5876047( This patch modifies FND_STATS package to exclude gathering statistics on external tables) for it.

Gather Schema Stats Failed With Ora-1 Errors After Applying Patch 5876047


Take a backup of the FND_STATS_HIST table
Truncate table FND_STATS_HIST
Re-submit Gather Schema Statistics program.

You do NOT need to truncate this table after each run of Gather Schema Statistics. Doing it once
will be enough, because each run of GSS will use a new request_id

No comments:

Post a Comment