Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to prove that separating schemas increases performance

YockeeFeb 17 2022

Hi,
I have this schema that contains a lot of tables (some 8000 tables which 7700 of them are generated automatically by the apps inner system).
I want to separate the system tables from the user tables by using different schemas, one schema for system, another one for user (storing just user data).
How do I prove that the action I take really increase performance ? What variables / parameters do I have to check ? I need to serve the before-and-after value on to a report.

Thanks

Comments

Post Details

Added on Feb 17 2022
5 comments
378 views