Sybase database is about 25 gig. What will it be after the conversion?
A. (i) Our experiences vary. In general, the space requirements between Sybase and Oracle are similar. You might notice a 10% variance in space usage. Oracle has the PCTFREE and PCTUSED space parameters through which we can control some of the space requirements. I would add 15-20% extra space usage for Oracle and after the conversion, during the tuning phase, we can optimize for space. We have also encountered various Sybase implementations, that when converted occupy up to 1/6th less space after the conversion. Typically, when a Sybase customer takes undue advantage of the unique row level locking features of Sybase (essentially stores one row every page), after conversion, the space utilization reduces drastically. (ii) Sybase do not have the concept of variable size EXTENTS. Meaning, when a database object is created on a Sybase device, the system does not preallocate any space; it grows dynamically. In Oracle, one needs to plan and manage the space efficiently by setting optimum v
