[Webinar] Streamline your web hosting managementRegister Today


Fixing corruption in SYS.WRH$_SEG_STAT_OBJ

Posted on 2010-03-26
Medium Priority
Last Modified: 2013-12-18
I have a data block corruption on the above table:  
SQL> select distinct owner from sys.WRH$_SEG_STAT_OBJ;
select distinct owner from sys.WRH$_SEG_STAT_OBJ
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 3, block # 32164)

There are plenty of threads on here about how to fix the corruption so I think I can do it.  My question is whether anyone know what this table is storing.  Chances are I'm going to lose the row with the corruption and I'm not sure what this will do to my database.  My thinking is that seeing as the table can't be read at the moment and the database is still up it can't be *too* important (naive, me?).

I've only been asked to look into this today and have found the problem started in November!  We therefore no longer have a good backup to go back to :o(

We're using Oracle on Windows 2003 Server.

I'm 'feeling my way' with this at the moment so if there's a log or anything that will help please let me know.

Question by:it-dept
LVL 15

Accepted Solution

Devinder Singh Virdi earned 2000 total points
ID: 28696858
>>My question is whether anyone know what this table is storing
This table stores data used by AWR and ADDM. click the following to get more information

Author Closing Comment

ID: 31707578
Thanks for that.  After a bit more research I found that no-one uses these stats and they are now switched off.  After clearing out the data the data block corruption has gone.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question