What are the benifits of Pscbo stats over the standard automatic stats collection in 11.2?
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
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
0