PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PSCBO_STATS and sqlhc diagnostics

edited Jan 23, 2016 10:07AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

Hello,

We've just installed the last pscbo_stats version.

I'm looking at some performance issue on our test database, for that I'm using sqlhc.

As we're using pscbo, I was confident about statistics collection, but when I take a look at the sqlhc health_check, it reports that stats collection should be different (estimate 100%).

I'll attach the sqlhc analyse.

Each sqlh analyze is showing that 100% estimate collection will be better.

Should we follow the sqlhc recommendation or let pscbo default ?

Thanks

Regards

Cyrille

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

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center