on 09-24-2009 8:10 AM
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
Hello Rajesh,
use transaction DB02 or DB02n for that.
Documentation: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c4/3a7160505211d189550000e829fbbd/content.htm
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Markus
I have no clue about oracle thats why i send the mail in sdn.sap. to make my concept clear ...nd strong, and well i wlll take class bt i thought u ppl wll help me ..and question is nt for u personelly its a global 1 nd anyone can reply ....for this
Anywayz.... thnx for ur suggestion
thnx for ur hlp....
Rajesh,
I'm happy to help - that is not the point.
It's more like trying to drive a car when you don't know the different colors of a traffic light and what they mean.
You may try, as a good start, the "2 day DBA" course freely available at
http://www.oracle.com/pls/db102/homepage?remark=tahiti
especially section "6 Managing Database Storage Structures".
This will give you a rough overview on how Oracle is organized and which fields mean what in DB02.
Markus
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And we want you to check the documentation before posting standard how-to questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.