Hi!
1.For 800+ tables,what is the recommended Temporary Tablespace nos+sizes,Permanent Tablespace nos+sizes,no of Rollback Segments,Index Block sizes,types of Indexes,etc.,
Regards,
Amitstora.
Hi!
1.For 800+ tables,what is the recommended Temporary Tablespace nos+sizes,Permanent Tablespace nos+sizes,no of Rollback Segments,Index Block sizes,types of Indexes,etc.,
Regards,
Amitstora.
That's my favorite answer: It Depends.
Is your database OLTP or DSS?
How much data is in the 800 tables?
How many devices do you have?
How many concurrent transactions?