Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Well.. that's a good question haha.. ok.. lets see...winthin SAP you can find
several tablespaces which are used for several things from storing user data
to store indexes (you can check SAP note: Note 355771 - Oracle: Explanation
of the new tablespace
layout<https://service.sap.com/sap/support/notes/355771> in
an Oracle scenario) and so on.. so.. if I were you I would analyze the
growth of my database through the last months as per tablespaces.. this
would tell me which tablespaces increase in size the most monthly (from my
experience in old layout PSAPTABD --> transactional one is the most
increasing one) from there you would be able to consider the datafile size
and distribution on your target DISK arrange ~ SAN or whatever its you are
using....so recap..this is configuring most increasing thus biggest
tablespace (some cases) in the most available free space DISK
arrange...using advanced configuration within SAPINST of course... What
advantages from taking into account what I just shared with you? I believe
having the confidence that if you estimate the growth size of your database
well, you will be getting less to worried about in your migration.. unless
of course you set autoextend automattically which also can save you lots of
trouble at the time of the migration.
Hope this is useful to you..
Regards,
| | | ---------------Original Message---------------
From: João Miguel Dimas
Sent: Wednesday, October 27, 2010 6:50 PM
Subject: Oracle SAPDATA - number of sapdata files - 4 files
Hum Jerry C.,
You touch on an important point, and sincerely for me, I still have difficulties to understand it... you said "the key thing here is to distribute all datafiles as per your needs". My question is only one: How you make that distribution, this is, what criteria you use in this analysis and decision/choice?
Thank you,
Joao Dimas - Portugal |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
