Skip to Content
avatar image
Former Member

I_WRI$_OPTSTAT_H

HI Team ,

We have tables lik,e I_WRI$_OPTSTAT_H & WRI$_OPTSTAT_HISTGRM_HISTORY with top size . We would like to archive the data of these 2 table . Is the data contains in those tables are vital for report ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 06, 2017 at 07:33 AM

    Hi,

    Please check whether SAP note 1783696 can help us here.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2017 at 09:15 AM

    Thanks James Zhang ,

    My Still unclear query is that , is these tables are useful or its been used in any manage system . As these tables are from solution manager

    vishnu

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2017 at 12:25 AM

    Hi Vishnu,

    They not for solution manager, they are oracle tables.
    There tables are used by oracle awr, so these tables are necessary in database, but you can pure the content or do some clean up.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2017 at 06:35 AM

    yes James ,

    As per SAP note 1783696 , after 11 G we can truncate the data from the said tables .

    Add comment
    10|10000 characters needed characters exceeded