Database Administration (MOSC)

MOSC Banner

statspack snap gethering

edited Dec 2, 2008 9:52AM in Database Administration (MOSC) 2 comments
 When I run the execute statspack.snap; I got the following error:

SQL> execute statspack.snap;
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-12899: value too large for column "PERFSTAT"."STATS$SGASTAT"."POOL"
(actual: 12, maximum: 11)
ORA-06512: at "PERFSTAT.STATSPACK", line 2036
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1

Should I go ahead increase the column length of this table? How else can I go approach fix this error? Thanks.

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