ORA-00909: invalid number of arguments
ORA-06512: at "SYS.DBMS_STATS", line 13437
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 2
The error appears when try to execute ( the size should be defined ) :
BEGIN
DBMS_STATS.GATHER_TABLE_STATS('X',
'XXX',
NULL,
DBMS_STATS.AUTO_SAMPLE_SIZE,
FALSE,
'FOR ALL INDEXED COLUMNS SIZE ',
DBMS_STATS.DEFAULT_DEGREE,
'ALL',
TRUE,
NULL,
NULL,
NULL,
FALSE);
END;
Solution(with bold):
BEGIN
DBMS_STATS.GATHER_TABLE_STATS('X',
'XXX',
NULL,
DBMS_STATS.AUTO_SAMPLE_SIZE,
FALSE,
'FOR ALL INDEXED COLUMNS SIZE 1',
DBMS_STATS.DEFAULT_DEGREE,
'ALL',
TRUE,
NULL,
NULL,
NULL,
FALSE);
END;
New Tool: xstack - Completely Passive eBPF Linux Stack Profiling Without
Any Tracepoints
-
I just added another tool into my 0x.tools toolset: xstack is a
lightweight, completely passive stack profiler for Linux that uses eBPF
task iterators to s...
Acum 3 zile
Niciun comentariu:
Trimiteți un comentariu