Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete/purge/truncate data in WRH$_LATCH_CHILDREN table?

801904Jun 27 2012 — edited Jun 27 2012

Hello

This is on Oracle 11g R2 (11.2.0.3) 64-bit

Searching of the Oracle 11.2 doc on-line turned up nothing, it's not even in the master index let alone being documented......

I have collected some performance data in SYSAUX tablespace in table WRH$_LATCH_CHILDREN for performance analysis and since changed statistics from 'ALL' to 'TYPICAL' and timed_os_statistics=0.

I have about 35 million rows in WRH$_LATCH_CHILDREN, ~2-3GB of space in SYSAUX for this one talble.

What is the recommended/supported way or removing this data? I don't need it any longer. Can I just use truncate table on it ?

thanks
YuriB

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2012

Added on Jun 27 2012

#general-database-discussions

4 comments

3,555 views