<div>
No problem.<br />
<br />
Just remember: &nbsp;The online docs are always your friend.
</div>


No problem.

Just remember:  The online docs are always your friend.

<div>
yes, i read the '.........between 1 and 25', then filled in 6 from a very old habit.<br />
thanks again
</div>


yes, i read the '.........between 1 and 25', then filled in 6 from a very old habit.
thanks again

<div>
<div class="content wysiwyg-content">
Trying to run schema stats and get histogram.<br />
If i run :<br />
DBMS_STATS.GATHER_SCHEMA_S<wbr />TATS(ownna<wbr />me=&gt;'SYS',<wbr /> cascade=&gt;TRUE, &nbsp;method_opt=&gt;'FOR ALL &nbsp;COLUMNS SIZE 1');<br />
it completes successfully. &nbsp;If i change SIZE to 256<br />
<br />
ORA-20000: Cannot parse for clause: FOR ALL COLUMNS SIZE 256 ORA-06512: at &quot;SYS.DBMS_STATS&quot;, line 25335 ORA-06512: at &quot;SYS.DBMS_STATS&quot;, line 25414 ORA-06512: at &quot;SYS.DBMS_STATS&quot;, line 25367 ORA-06512: at line 3<br />
<br />
How do i get stats with histogram for sys?
</div>
</div>


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?

Stats With Histogram

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.