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

  • From: Ian Cary <Ian.Cary@xxxxxxxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Wed, 30 Jan 2008 14:59:46 +0000

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=

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


Other related posts: