Database Administration (MOSC)

MOSC Banner

dbms_stats.gather_table_stats fails for SYS.WRH$_SQLTEXT with ORA-01422

Oracle Exadata X8-2 / Oracle Database Version 19.15

begin

dbms_stats.gather_table_stats(

ownname=> 'SYS',

tabname=> 'WRH$_SQLTEXT' ,

estimate_percent=> DBMS_STATS.AUTO_SAMPLE_SIZE,

cascade=> DBMS_STATS.AUTO_CASCADE,

degree=> DBMS_STATS.AUTO_DEGREE,

no_invalidate=> DBMS_STATS.AUTO_INVALIDATE,

granularity=> 'AUTO',

method_opt=> 'FOR ALL COLUMNS SIZE AUTO');

end;

Fehlerbericht -

ORA-01422: Exakter Abruf gibt mehr als die angeforderte Zeilenzahl zurück

ORA-06512: in "SYS.DBMS_STATS", Zeile 40799

ORA-06512: in "SYS.DBMS_STATS", Zeile 40083

ORA-06512: in "SYS.DBMS_STATS", Zeile 38960

ORA-06512: in "SYS.DBMS_STATS", Zeile 38069

ORA-06512: in "SYS.DBMS_STATS_INTERNAL", Zeile 24646

ORA-06512: in "SYS.DBMS_STATS_INTERNAL", Zeile 24633

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