cancel
Showing results for 
Search instead for 
Did you mean: 

Percentage of tables and indexes in a database

Former Member
0 Kudos

Hi,

I have a small doubt. What would be percentage of tables and indexes in a oracle database. For example, if my database is of 100 GB, then how much will be consumed by tables and what would be consumed by indexes?

Thanks in adv for help.

Abdul

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

nearly impossible to say.

on my R/3 4.7 system, it`s 70/30%

on BW nw2004s, it`s 60/40%

check DB02 to get an idea becasue each system is different, especially if you created loads of Z-TAbles.