Database Administration (MOSC)

MOSC Banner

Corruption on histgrm$ table

edited Aug 17, 2017 12:26PM in Database Administration (MOSC) 12 commentsAnswered ✓

I need help to remove corruption on histgrm$ table.

The corruption is not visible with dbv or rman but I can see it because:

i)There is daily an incident created with:

*** 2017-07-31 22:00:52.978

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

----- Current SQL Statement for this session (sql_id=43ruajmwv9fus) -----

insert into histgrm$(obj#,intcol#,row#,bucket,endpoint,col#,epvalue)values(:1,:2,:3,:4,:5,:6,:7)

----- PL/SQL Stack -----

----- PL/SQL Call Stack -----

.........................................................................................................................................................

ii) select count(*) from histgrm$=52360

select * from histgrm$

..................................................

52375 rows selected.

Although there is something corrupted on the table all rows can be selected. I tried everything to fix it but I can't.

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