Stats With Histogram

Trying to run schema stats and get histogram.
If i run :
DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'SYS', cascade=>TRUE,  method_opt=>'FOR ALL  COLUMNS SIZE 1');
it completes successfully.  If i change SIZE to 256

ORA-20000: Cannot parse for clause: FOR ALL COLUMNS SIZE 256 ORA-06512: at "SYS.DBMS_STATS", line 25335 ORA-06512: at "SYS.DBMS_STATS", line 25414 ORA-06512: at "SYS.DBMS_STATS", line 25367 ORA-06512: at line 3

How do i get stats with histogram for sys?
xoxomosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
256 doesn't appear to be valid.

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_stats.htm#ARPLS059

METHOD_OPT - The value controls column statistics collection and histogram creation. It accepts either of the following options, or both in combination:

size_clause is defined as size_clause := SIZE {integer | REPEAT | AUTO | SKEWONLY}

- integer : Number of histogram buckets. Must be in the range [1,254].
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
xoxomosAuthor Commented:
Right!  256 INDEED:-(
0
xoxomosAuthor Commented:
Thanks again
0
slightwv (䄆 Netminder) Commented:
No problem.

Just remember:  The online docs are always your friend.
0
xoxomosAuthor Commented:
yes, i read the '.........between 1 and 25', then filled in 6 from a very old habit.
thanks again
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.