My Oracle Support Banner

R12.2: PJI_PA_PROJ_EVENTS_LOG_N1 Index Goes Into Unusable State Frequently (Doc ID 2408719.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Project Planning and Control - Version 12.2.6 and later
Information 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.

Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.