R
Rob Fitzpatrick
Guest
Hi Jim, The size of your database, with application schema and no data, depends on database block size, database structure, and schema contents (both number of storage objects and assignment of objects to areas). In Type II storage areas (cluster size > 1), each storage object (table, index, or LOB column) consumes a minimum of one cluster of storage, even when empty. Given a block size of 8 KB and a cluster size of 64 blocks, each object consumes 64 * 8192 = 512 KB, or half a megabyte. Given your post-schema-load extent sizes, I'd guess you have about 168 tables and 352 indexes, give or take.
Continue reading...
Continue reading...