ERD

[Roshan]

Hi Erman,

I have imported a dump file on a 12.1.0.2 DB. I have generated the ERD.

Could you please advise what information I can gather from an ERD?

 Relational_1.pdf

What tunings can be done as per this ERD?

Do we need to know the number of rows which are loaded in each tables for capacity planning?

Thanks,

Roshan

[ErmanArslansOracleBlog]

ER diagram is a well known thing.

Basically, it may help you to see the logical structure of your db/schema, its tables and the relation between them. You may use that info from ER diagram to have a more efficient logical db design by reducing columns and achieve normalization. I mean to clear the database from unused data and to reduce the data redundancy and inconsistency.
It also may be used while tuning the complex query.. (because you need to see the general logical structure to tune or rewrite a complex query)