Primavera (MOSC)

MOSC Banner

Gather Stats on P6 Reporting Database Star Schema Tables

edited Apr 2, 2012 2:52AM in Primavera (MOSC) 1 commentAnswered
Hi,

I have installed the P6 reporting database (3.0) and loaded it with our P6 data using the staretl.bat script. However, a lot of our queries and charts in OBIEE running against the star schema tables are now running very slowly. I have tried to gather stats on the star schema tables but they are locked. Does anyone know (i) if I am supposed to gather the table stats to improve query performance ?, or (ii) how do I do this ?.

Many thanks

Nik

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