PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

What are the benifits of Pscbo stats over the standard automatic stats collection in 11.2?

edited May 29, 2012 3:15AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
Hi
I am looking at gathering stats in our database, where we currently gather schema stats every day. Clearly we can improve on that.

Can you explain why I would use pscbo rather than the oracle supplied automatic stats collection, which seems similar, but gives slightly more flexibility? I can see I would need to get jobs using the %Updatestats metasql to call pscbo_stats.gather_table_stats to avoid generating an exception, but what are the benefits for the main stats gathering job?

Thanks

Paul Houghton

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