D
Dapeng Wu
Guest
Mostly likely, the reason for the slow tenant creation is related to the number of objects to be allocated by adding this new tenant.In a MT database, each tenant owns its unique subset of the multi-tenant objects, and it takes time to create all of them. In your example with 255 tables, let's say they are all multi-tenant tables and assume there are also multi-tenant 750 indexes and lobs associated with these tables. So there will be around 1000 multi-tenant objects to be created for this new tenant. Each object create requires a database cluster to store the basic information. Assume your db cluster size is 64 and block size is 8k, then the space to be allocated and formatted is 1000 * 64 * 8k = 512 MB. You may not see the database size grow physically, but if you ran dbanalys, you'll see lots of new objects get created internally, and the total database blocks may grow significantly. Note that similar "slowness" can also happen when adding a multi-tenant table to a database with many tenants. Say there are 100 tenants in the database, and you're adding a multi-tenant table with 9 indexes and lobs. The schema for these 10 new objects need to be materialized for each tenant. So with cluster size of 64 and block size of 8K, you'll need to format 100 * 10 * 64 * 8K = 512 MB space as well. Dapeng
Continue reading...
Continue reading...