Printable View
Thanks for all that responded...
I'd still like to know if there is a way to predict possible growth of my SGA and Data Dictionary if a large amount of tables and indexes are added to the database. Is this possible to determine prior to implementing?
You can use the oracle capacity planner, (an OEM tool). But it doesn't matter how many tables and indexes that you add to the database, it would be a storage issue. As far as the SGA is concerened, it would be a usage issue, how many users would be using the application, how fast would you like to performance to be, etc and etc. In short, how much of information would you want to retain in the memory, to avoid the I/O
Sam