No partitions on WRI$_OPTSTAT_HISTGRM_HISTORY and _HISTHEAD_HISTORY

Jul 10, 2017 2:11PM

In 11.2.0.4 database, two tables are 37 and 7GB respectively (after TABLE MOVE and INDEX REBUILD execution). I reclaimed some space in SYSAUX with the help of steps available in 454678.1 and also by rebuilding two most space occupying indexes i_wri$_optstat_h_obj#_icol#_st and i_wri$_optstat_h_st. As Oracle support suggested, I also applied Oct 2017 PSU to resolve a known bug Bug 14373728.

SQL> select dbms_stats.get_stats_history_availability from dual;

GET_STATS_HISTORY_AVAILABILITY

---------------------------------------------------------------------------

09-JUN-17 12.00.37.491360000 AM -04:00

There are no partitions on both the tables. I do see partitions on two tables in a database of smaller size. Are there any Oracle suggested methods to manually create partitions so that daily maintenance will manage and resume working normally?

SQL Performance (MOSC)

No partitions on WRI$_OPTSTAT_HISTGRM_HISTORY and _HISTHEAD_HISTORY

Howdy, Stranger!

Category Leaderboard

Top contributors this month