SQL Performance (MOSC)

MOSC Banner

Mistake in DBMS_STATS documentation

edited Nov 25, 2014 10:00AM in SQL Performance (MOSC) 4 commentsAnswered

Hi,

I wanted to check back from the documentation the filtering facility on the GATHER_SCHEMA_STATS procedure of the DBMS_STATS package but I was surprised by the example given regarding the obj_filter_list parameter. Here is the link:

Applying an Object Filter List

https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_stats.htm#BABJDJBB

It says:

The following example specifies that any table with a "T" prefix in the SAMPLE schema and any table in the SYS schema, if stale, will have statistics gathered upon it.

But the PL/SQL block given does not at all show that!

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