SQL Performance (MOSC)

MOSC Banner

error while taking a copy of system statistics

edited Dec 16, 2015 10:10AM in SQL Performance (MOSC) 4 commentsAnswered

Hi ,

I am trying to make copy of current system statistics so I am trying to take current system statistics to a table but I am getting a following error. Please suggest how to execute these procedures.

SQL> declare

system_statistics varchar2(30000);

begin

DBMS_STATS.GATHER_SYSTEM_STATS (

   stattab => system_statistics,

   statid  =>1

   );

end;

/  2    3    4    5    6    7    8    9

declare

*

ERROR at line 1:

ORA-20001: 1 is an invalid identifier

ORA-06512: at "SYS.DBMS_STATS", line 1975

ORA-06512: at "SYS.DBMS_STATS", line 1991

ORA-06512: at "SYS.DBMS_STATS", line 20184

ORA-06512: at line 4

Thanks

Rakesh K

Tagged:

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