Skip to Content
avatar image
Former Member

Database size in oracle

hi

i want to know our datasize volume and growth on day to day basis. we have oracle 10g and sap is ecc5.0.

thanks

Rajesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 24, 2009 at 07:19 AM

    Hello Rajesh,

    use transaction DB02 or DB02n for that.

    Documentation: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c4/3a7160505211d189550000e829fbbd/content.htm

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      sorry, but is your keyboard OK?

      It seems that you began to lose the vowels in the middle of your paragraph.

      Remember, This is a Forum, where

      1) people volunteer to help

      2) there is no restriction in the number of characters you can write

      3) it is supposed to be in English

      4) There are NOT native English speakers that WILL have problems to BAD written english

      5) you are suppose to have read the [Rules of Engagement|https://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement]

      All those things will make the experience better for ALL (including you)

  • Sep 24, 2009 at 07:21 AM

    And we want you to check the documentation before posting standard how-to questions.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24, 2009 at 06:40 PM

    Hello Rajesh,

    We can estimate the size daily ocupied, just see how much perccentage of SYSTEM tablespace is

    used daily,.After all we get idea only by the usage and percentage of space daily consumed daily.Also

    check for temp tablespace.We can have one or more temporary and undo tablespaces.

    So If you could take seniors help then try to take backup of SYSTEM tablespace by making it offline

    if full .,till then you make available TEMP tablespace for storage of data.Also check for the undo segments

    is it full . If yes try to clear the undo data.Just check the above -- It may help you.

    regards,

    Manjula.

    Add comment
    10|10000 characters needed characters exceeded