Re: How to calculate size of table including size of its indexes too.

From: Ian Cary <Ian.Cary_at_ons.gsi.gov.uk>
Date: Wed, 30 Jan 2008 14:59:46 +0000
Message-ID: <OF1D4D5374.4278C13D-ON802573E0.0050D37E-802573E0.00526689@ons.gsi.gov.uk>

VGhpcyBpcyBzb21ldGhpbmcgSSB3cm90ZSBzZXZlcmFsIHllYXJzIGFnbyB0aGF0IGdpdmVzIGJv dGggdGhlIGFsbG9jYXRlZAphbmQgdXNlZCBzcGFjZSBvZiB0YWJsZXMgYW5kIGluZGV4ZXMgd2hp Y2ggeW91IG1heSBmaW5kIHVzZWZ1bC4KCkNoZWVycywKCklhbgoKZGVjbGFyZQpieXRlc19hbGxv Y2F0ZWQgICAgICAgICAgICBudW1iZXIgOj0gMDsKYnl0ZXNfdXNlZCAgICAgICAgICAgICAgICAg bnVtYmVyIDo9IDA7CnVzZXJfYnl0ZXNfYWxsb2NhdGVkICAgICAgIG51bWJlciA6PSAwOwp1c2Vy X2J5dGVzX3VzZWQgICAgICAgICAgICBudW1iZXIgOj0gMDsKdG90X2J5dGVzX2FsbG9jYXRlZCAg ICAgICAgbnVtYmVyIDo9IDA7CnRvdF9ieXRlc191c2VkICAgICAgICAgICAgIG51bWJlciA6PSAw OwpjdXJvd25lciAgICAgICAgICAgICAgICAgICB2YXJjaGFyMigzMCkgOj0gJ3h4eCc7CmNoYWlu X3BjdCAgICAgICAgICAgIG51bWJlcjsKCmJlZ2luCiAgZm9yIHRhYnJlYyBpbiAoc2VsZWN0IG93 bmVyLAogICAgICAgICAgICAgICAgICAgICAgc2VnbWVudF9uYW1lLAogICAgICAgICAgICAgICAg ICBzZWdtZW50X3R5cGUsCiAgICAgICAgICAgICAgICAgIGV4dGVudHMsCiAgICAgICAgICAgICAg ICAgIHBhcnRpdGlvbl9uYW1lCiAgICAgICAgICAgICAgICAgZnJvbSAgIGRiYV9zZWdtZW50cwog ICAgICAgICAgICAgICAgIHdoZXJlICBvd25lciBsaWtlIHVwcGVyKCcmb2Jqb3duZXInKQogICAg ICAgICAgICAgICAgIGFuZCAgICBzZWdtZW50X25hbWUgbGlrZSB1cHBlcignJm9iam5hbWUnKQog ICAgICAgICAgICAgICAgIGFuZCAgICAoc2VnbWVudF90eXBlIGxpa2UgJ1RBQkxFJScgb3IKICAg ICAgICAgICAgICAgICAgICAgICAgIHNlZ21lbnRfdHlwZSBsaWtlCmRlY29kZSh1cHBlcignJmlu ZGV4ZXMnKSwnWScsJ0lOREVYJScsJ05PTkUnKSkKICAgICAgICAgICAgICAgICBvcmRlciBieSBv d25lcixzZWdtZW50X25hbWUscGFydGl0aW9uX25hbWUpIGxvb3AKICAgICAgaWYgY3Vyb3duZXIg IT0gdGFicmVjLm93bmVyIHRoZW4KICAgICAgICAgaWYgY3Vyb3duZXIgIT0gJ3h4eCcgdGhlbgog ICAgICAgICAgICBkYm1zX291dHB1dC5wdXRfbGluZSgnICcpOwogICAgICAgICAgICBkYm1zX291 dHB1dC5wdXRfbGluZShycGFkKCctLS0tLS0tLS0tLScsMjUpfHwKICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgbHBhZCgnLS0tLS0tLS0tLS0tLS0tLScsMTYpfHwKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgbHBhZCgnLS0tLS0tLS0tLS0nLDE0KXx8CiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIGxwYWQoJy0tLS0tLS0tLS0tJywxNCkpOwogICAgICAgICAg ICBkYm1zX291dHB1dC5wdXRfbGluZShycGFkKCdVc2VyIFRvdGFsJywyNSl8fAogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBscGFkKHVzZXJfYnl0ZXNfYWxsb2NhdGVkLzEwMjQsMTYp fHwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbHBhZChyb3VuZCh1c2VyX2J5dGVz X3VzZWQvMTAyNCksMTQpfHwKCmxwYWQocm91bmQoKHVzZXJfYnl0ZXNfYWxsb2NhdGVkLXVzZXJf Ynl0ZXNfdXNlZCkvMTAyNCksMTQpKTsKICAgICAgICAgICAgdXNlcl9ieXRlc19hbGxvY2F0ZWQg Oj0gMDsKICAgICAgICAgICAgdXNlcl9ieXRlc191c2VkIDo9IDA7CiAgICAgICAgIGVuZCBpZjsK ICAgICAgICAgZGJtc19vdXRwdXQucHV0X2xpbmUoJyAnKTsKICAgICAgICAgZGJtc19vdXRwdXQu cHV0X2xpbmUoJ1NwYWNlIFVzZWQgYnk6ICd8fHRhYnJlYy5vd25lcik7CiAgICAgICAgIGRibXNf b3V0cHV0LnB1dF9saW5lKCcgJyk7CiAgICAgICAgIGRibXNfb3V0cHV0LnB1dF9saW5lKHJwYWQo J09iamVjdCBOYW1lJywyNSl8fAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBscGFkKCdL Qnl0ZXMgQWxsb2NhdGVkJywxNil8fAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBscGFk KCdLQnl0ZXMgVXNlZCcsMTQpfHwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbHBhZCgn S0J5dGVzIEZyZWUnLDE0KXx8CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGxwYWQoJ0V4 dGVudHMnLDkpKTsKICAgICAgICAgZGJtc19vdXRwdXQucHV0X2xpbmUocnBhZCgnLS0tLS0tLS0t LS0nLDI1KXx8CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGxwYWQoJy0tLS0tLS0tLS0t LS0tLS0nLDE2KXx8CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGxwYWQoJy0tLS0tLS0t LS0tJywxNCl8fAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBscGFkKCctLS0tLS0tLS0t LScsMTQpfHwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbHBhZCgnLS0tLS0tLScsOSkp OwogICAgICAgICBjdXJvd25lciA6PSB0YWJyZWMub3duZXI7CiAgICAgIGVuZCBpZjsKICAgICAg ZGJtc19zcGFjZS5vYmplY3Rfc3BhY2VfdXNhZ2UodGFicmVjLm93bmVyLAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICB0YWJyZWMuc2VnbWVudF9uYW1lLAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICB0YWJyZWMuc2VnbWVudF90eXBlLAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBudWxsLAogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBieXRlc191c2VkLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBi eXRlc19hbGxvY2F0ZWQsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNoYWlu X3BjdCwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdGFicmVjLnBhcnRpdGlvbl9uYW1l KTsKICAgICAgZGJtc19vdXRwdXQucHV0X2xpbmUocnBhZChsdHJpbSh0YWJyZWMucGFydGl0aW9u X25hbWV8fCcKJ3x8dGFicmVjLnNlZ21lbnRfbmFtZSksMzApfHwKICAgICAgICAgICAgICAgICAg ICAgICAgICAgbHBhZChieXRlc19hbGxvY2F0ZWQvMTAyNCwxMSl8fAogICAgICAgICAgICAgICAg ICAgICAgICAgICBscGFkKHJvdW5kKGJ5dGVzX3VzZWQvMTAyNCksMTQpfHwKCmxwYWQocm91bmQo KGJ5dGVzX2FsbG9jYXRlZC1ieXRlc191c2VkKS8xMDI0KSwxNCl8fAogICAgICAgICAgICAgICAg ICAgICAgICAgICBscGFkKHRhYnJlYy5leHRlbnRzLDkpKTsKICAgICAgdXNlcl9ieXRlc19hbGxv Y2F0ZWQgOj0gdXNlcl9ieXRlc19hbGxvY2F0ZWQgKyBieXRlc19hbGxvY2F0ZWQ7CiAgICAgIHVz ZXJfYnl0ZXNfdXNlZCA6PSB1c2VyX2J5dGVzX3VzZWQgKyBieXRlc191c2VkOwogICAgICB0b3Rf Ynl0ZXNfYWxsb2NhdGVkIDo9IHRvdF9ieXRlc19hbGxvY2F0ZWQgKyBieXRlc19hbGxvY2F0ZWQ7 CiAgICAgIHRvdF9ieXRlc191c2VkIDo9IHRvdF9ieXRlc191c2VkICsgYnl0ZXNfdXNlZDsKICBl bmQgbG9vcDsKICBkYm1zX291dHB1dC5wdXRfbGluZSgnICcpOwogIGRibXNfb3V0cHV0LnB1dF9s aW5lKHJwYWQoJy0tLS0tLS0tLS0tJywyNSl8fAogICAgICAgICAgICAgICAgICAgICAgIGxwYWQo Jy0tLS0tLS0tLS0tLS0tLS0nLDE2KXx8CiAgICAgICAgICAgICAgICAgICAgICAgbHBhZCgnLS0t LS0tLS0tLS0nLDE0KXx8CiAgICAgICAgICAgICAgICAgICAgICAgbHBhZCgnLS0tLS0tLS0tLS0n LDE0KSk7CiAgZGJtc19vdXRwdXQucHV0X2xpbmUocnBhZCgnVXNlciBUb3RhbCcsMjUpfHwKICAg ICAgICAgICAgICAgICAgICAgICBscGFkKHVzZXJfYnl0ZXNfYWxsb2NhdGVkLzEwMjQsMTYpfHwK ICAgICAgICAgICAgICAgICAgICAgICBscGFkKHJvdW5kKHVzZXJfYnl0ZXNfdXNlZC8xMDI0KSwx NCl8fAoKbHBhZChyb3VuZCgodXNlcl9ieXRlc19hbGxvY2F0ZWQtdXNlcl9ieXRlc191c2VkKS8x MDI0KSwxNCkpOwogIGRibXNfb3V0cHV0LnB1dF9saW5lKCcgJyk7CiAgZGJtc19vdXRwdXQucHV0 X2xpbmUoJyAnKTsKICBkYm1zX291dHB1dC5wdXRfbGluZShycGFkKCctLS0tLS0tLS0tLScsMjUp fHwKICAgICAgICAgICAgICAgICAgICAgICBscGFkKCctLS0tLS0tLS0tLS0tLS0tJywxNil8fAog ICAgICAgICAgICAgICAgICAgICAgIGxwYWQoJy0tLS0tLS0tLS0tJywxNCl8fAogICAgICAgICAg ICAgICAgICAgICAgIGxwYWQoJy0tLS0tLS0tLS0tJywxNCkpOwogIGRibXNfb3V0cHV0LnB1dF9s aW5lKHJwYWQoJ092ZXJhbGwgVG90YWwnLDI1KXx8CiAgICAgICAgICAgICAgICAgICAgICAgbHBh ZCh0b3RfYnl0ZXNfYWxsb2NhdGVkLzEwMjQsMTYpfHwKICAgICAgICAgICAgICAgICAgICAgICBs cGFkKHJvdW5kKHRvdF9ieXRlc191c2VkLzEwMjQpLDE0KXx8CgpscGFkKHJvdW5kKCh0b3RfYnl0 ZXNfYWxsb2NhdGVkLXRvdF9ieXRlc191c2VkKS8xMDI0KSwxNCkpOwplbmQ7Ci8KCgoKfC0tLS0t LS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLT4KfCAgICAgICAgIHwgICAgICAgICAg IGprc3RpbGxAZ21haWwuY29tIHwKfCAgICAgICAgIHwgICAgICAgICAgIFNlbnQgYnk6ICAgICAg ICAgIHwKfCAgICAgICAgIHwgICAgICAgICAgIG9yYWNsZS1sLWJvdW5jZUBmcnwKfCAgICAgICAg IHwgICAgICAgICAgIGVlbGlzdHMub3JnICAgICAgIHwKfCAgICAgICAgIHwgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIHwKfCAgICAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAg IHwKfCAgICAgICAgIHwgICAgICAgICAgIDI5LzAxLzIwMDggMTk6NDEgIHwKfCAgICAgICAgIHwg ICAgICAgICAgIFBsZWFzZSByZXNwb25kIHRvIHwKfCAgICAgICAgIHwgICAgICAgICAgIGprc3Rp bGwgICAgICAgICAgIHwKfCAgICAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwK fC0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLT4KICA+LS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS18CiAgfCAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfAogIHwgICAgICAgVG86 ICAgICAgIGhhbnNyYWpzYW9AZ21haWwuY29tICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwKICB8ICAgICAgIGNj OiAgICAgICBvcmFjbGUtbEBmcmVlbGlzdHMub3JnICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8CiAgfCAgICAgICBT dWJqZWN0OiAgUmU6IEhvdyB0byBjYWxjdWxhdGUgc2l6ZSBvZiB0YWJsZSBpbmNsdWRpbmcgc2l6 ZSBvZiBpdHMgaW5kZXhlcyB0b28uICAgICAgICAgICAgICAgICAgICAgICAgfAogID4tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLXwKCgoKCk9uIEph biAyMiwgMjAwOCA5OjMxIEFNLCBoYW5zcmFqIHNhbyA8aGFuc3JhanNhb0BnbWFpbC5jb20+IHdy b3RlOgp5ZWFoLCBidXQgdGhpcyB0aGF0IGNhc2UgaSB3aWxsIG9ubHkgZ2V0IHNpemUgb2YgcGFy dGljdWxhciBpbmRleC4KCkkgd2FudGVkIGtub3cgaWYgdGhlcmUgaXMgYW55IHdheSBiZSBnZXQg dGFibGUgc2l6ZSsgaXRzIGluZGV4ZXogc2l6ZSBpbiBvbgpzY3JpcHRzLgoKaXRzIHNlZW1zIGkg bmVlZCB0byB3cml0ZSBzbWFsbCBwcm9jZWR1cmUuLgoKCldyaXRpbmcgYSBwcm9jZWR1cmUgaXMg YSBsYXN0IHJlc29ydC4KRG9pbmcgdGhpcyBpbiBTUUwgbm90IHRvbyBkaWZmaWN1bHQgdG8gZG8s IGFuZCBEYW4gRmluayBoYXMgYWxyZWFkeSBwb3N0ZWQKYSBzb2x1dGlvbi4KCkV2ZW4gd2hlbiBk aWZmaWN1bHQsIFNRTCBpcyBhIGEgYmV0dGVyIHNvbHV0aW9uIGlmIHBvc3NpYmxlLgoKUGxlYXNl IHNlZSBodHRwOi8vd3d3LnlvdXR1YmUuY29tL3dhdGNoP3Y9NDBMbm95di1zWGcgaWYgeW91IGFy ZSBub3QKY29udmluY2VkIG9mCnRoZSBuZWVkIHRvIGF2b2lkIHVubmVjZXNzYXJ5IHByb2NlZHVy ZXMuCgoKLS0KSmFyZWQgU3RpbGwKQ2VydGlmaWFibGUgT3JhY2xlIERCQSBhbmQgUGFydCBUaW1l IFBlcmwgRXZhbmdlbGlzdAoKVGhpcyBlbWFpbCB3YXMgcmVjZWl2ZWQgZnJvbSB0aGUgSU5URVJO RVQgYW5kIHNjYW5uZWQgYnkgdGhlIEdvdmVybm1lbnQKU2VjdXJlIEludHJhbmV0IGFudGktdmly dXMgc2VydmljZSBzdXBwbGllZCBieSBDYWJsZSZXaXJlbGVzcyBpbgpwYXJ0bmVyc2hpcCB3aXRo IE1lc3NhZ2VMYWJzLiAoQ0NUTSBDZXJ0aWZpY2F0ZSBOdW1iZXIgMjAwNy8xMS8wMDMyLikgSW4K Y2FzZSBvZiBwcm9ibGVtcywgcGxlYXNlIGNhbGwgeW91ciBvcmdhbmlzYXRpb27igJlzIElUIEhl bHBkZXNrLgpDb21tdW5pY2F0aW9ucyB2aWEgdGhlIEdTaSBtYXkgYmUgYXV0b21hdGljYWxseSBs b2dnZWQsIG1vbml0b3JlZCBhbmQvb3IKcmVjb3JkZWQgZm9yIGxlZ2FsIHB1cnBvc2VzLgoKRm9y IHRoZSBsYXRlc3QgZGF0YSBvbiB0aGUgZWNvbm9teSBhbmQgc29jaWV0eSBjb25zdWx0IE5hdGlv bmFsIFN0YXRpc3RpY3MgYXQgaHR0cDovL3d3dy5zdGF0aXN0aWNzLmdvdi51awoKKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqCgoKUGxlYXNlIE5vdGU6ICBJbmNvbWluZyBhbmQgb3V0Z29pbmcgZW1h aWwgbWVzc2FnZXMgYXJlIHJvdXRpbmVseSBtb25pdG9yZWQgZm9yIGNvbXBsaWFuY2Ugd2l0aCBv dXIgcG9saWN5IG9uIHRoZSB1c2Ugb2YgZWxlY3Ryb25pYyBjb21tdW5pY2F0aW9ucwoqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioKCgpMZWdhbCBEaXNjbGFpbWVyICA6ICBBbnkgdmlld3MgZXhwcmVz c2VkIGJ5IHRoZSBzZW5kZXIgb2YgdGhpcyBtZXNzYWdlIGFyZSBub3QgbmVjZXNzYXJpbHkgdGhv c2Ugb2YgdGhlIE9mZmljZSBmb3IgTmF0aW9uYWwgU3RhdGlzdGljcwoqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioKCgpUaGUgb3JpZ2luYWwgb2YgdGhpcyBlbWFpbCB3YXMgc2Nhbm5lZCBmb3Igdmly dXNlcyBieSB0aGUgR292ZXJubWVudCBTZWN1cmUgSW50cmFuZXQgdmlydXMgc2Nhbm5pbmcgc2Vy dmljZSBzdXBwbGllZCBieSBDYWJsZSZXaXJlbGVzcyBpbiBwYXJ0bmVyc2hpcCB3aXRoIE1lc3Nh Z2VMYWJzLiAoQ0NUTSBDZXJ0aWZpY2F0ZSBOdW1iZXIgMjAwNy8xMS8wMDMyLikgT24gbGVhdmlu ZyB0aGUgR1NpIHRoaXMgZW1haWwgd2FzIGNlcnRpZmllZCB2aXJ1cyBmcmVlLgpDb21tdW5pY2F0 aW9ucyB2aWEgdGhlIEdTaSBtYXkgYmUgYXV0b21hdGljYWxseSBsb2dnZWQsIG1vbml0b3JlZCBh bmQvb3IgcmVjb3JkZWQgZm9yIGxlZ2FsIHB1cnBvc2VzLgo=

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 30 2008 - 08:59:46 CST

This message: [ Message body ]
Next message: Hemant K Chitale: "Re: TAF and node failover non RAC oracle 10.2"
Previous message: Koivu, Lisa: "RE: ASM crash/question"
Maybe in reply to: hansraj sao: "How to calculate size of table including size of its indexes too."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message