R
Rob Fitzpatrick
Guest
I don't see why you would want a 1 GB fixed extent for the schema area. It shouldn't need anywhere near that much space if it only contains system tables. Mine are typically 4-10 MB with over 1000 application objects in the schema. I would keep the code separate from the database. You mention source and object code so I assume compiles are happening on this machine. If you have to recompile the application that will be a lot of I/O on your database volume. Version 10.2B is over five years old and will never receive another service pack. It isn't retired yet, but that could change at any time. I recommend against moving to such an old release.
Continue reading...
Continue reading...