faruk's learning journey

I have a customer who is struggling with db issues for several months, we have 550 million composite instances which are waiting to be purged. these instances takes nearly 12TB tablespace. so we are making investigations on this database. I realized that if i wrote a script which finds the ratio related the holding space behind the individual composites which are part of customer's order management process, it would worth the time I will spend. first I wrote a function which takes only composite instance id then one small select is enough to see which composite instance is taking the most size of db. this result is related with all spaces which can the different from instance to instance. the result would be like that default/ProcessSalesOrderEBF!13.10.25-0954*soa_1c1526b7-19c6-4633-bca4-bc06f1f157ad 43.8553333333 default/InterfaceOrderToProvisionEBF!13.10.24-1057*soa_91f81f2c-9d9c-4ef6-aa8e-1403138e3e34 12.6453333333 default/ProcessOrderToOLOProvABCS!13.12.03-1410*soa_...