R12.2: PJI_PA_PROJ_EVENTS_LOG_N1 Index Goes Into Unusable State Frequently
(Doc ID 2408719.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Oracle Project Planning and Control - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On 12.2.6:
PJI_PA_PROJ_EVENTS_LOG_N1 index is going into Unusable state frequently.
Followed the steps below:
-----------------------------
1. Ran the "Gather Table Statistics" process for table PJI_PA_PROJ_EVENTS_LOG
with "Granularity" option as 'DEFAULT'. The process completed successfully.
2. Rebuilt the index. Index status was back as Valid.
But it goes back to Unusable status after sometimes.
WORKAROUNDS
===========
Rebuild the index every time.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |