I have 18.104.22.168 SAPdb installed in a sandbox environment and have been playing around trying to do a few different things.
1)I'd like to change either or both the data and log volume sizes.
a. Id like to be able to shrink a log down from, say 10gig to 1 gig.
b.Also can I increase individual data file sizes (as well as decrease) versus adding more or is it stuck with its original configured values.
2)The TEST db Im playing with has 10 named volumes, 2 look like theyre being used. If those 2 fill up will it automatically create a 3rd, or do I need to do that before it fills up?
3) Weve got a development db that is at 66% currently using 5 of the 10 volumes. If I have to add volumes manually when is a good time to do so? 75%? 90%? I know itll probably depend on how fast its filling up, but is there a good rule of thumb to follow?
Thanks for your time.