Re: dbms_stats.auto_sample_size or sample size 20

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Tue, 31 Jan 2006 17:18:25 +0000
Message-ID: <d6f0def50601310918m789bff12q1ddcb06ff6295995@mail.gmail.com>

SXQgaXMgaW50ZXJlc3RpbmcgZW5vdWdoIHdoYXQgb2Z0ZW4gcGVvcGxlIHRoaW5rIHRoZXkgYXJl IHJlZHVjaW5nCnN0YXRpc3RpY3MgZ2F0aGVyaW5nIHRpbWUgYnkgZGVjcmVhc2luZyB0aGUgZXN0 aW1hdGVfcGVyY2VudApwYXJhbWV0ZXIuClRha2UgYSBsb29rIG9uIHRoZSB0ZXN0IGJlbG93LiBB Y2NvcmRpbmcgdG8gdGhlIHRlc3QgcmVzdWx0cyB1c2luZwoxMDAlIGFzIHNhbXBsZSBzaXplIGZv ciB0aGUgcGFydGljdWxhciB0YWJsZSBpcyBxdWlja2VyIHRoZW4gMjAlLgoKSnVhbiCWIHVuZm9y dHVuYXRlbHkgdGhlcmUgaXMgbm8gYW4gdW5pdmVyc2FsIGFuc3dlciB0byB5b3VyIHF1ZXN0aW9u LgpTdGF0aXN0aWNzIGdhdGhlcmluZyBpcyB2ZXJ5IGNhc2Ugc3BlY2lmaWMgdGhpbmsuIFNhbXBs ZSBzaXplID0xMDAlCmRlbGl2ZXJzIDEwMCUgcHJlY2lzZSBzdGF0aXN0aWNzIGFuZCB0aGUgc3Rh dGlzdGljcyBnYXRoZXJpbmcgcHJvY2VzcwppcyBub3QgbmVjZXNzYXJ5IHNsb3dlciB0aGVuIHVz aW5nIDIwJSBvciAxMCUuIFNvbWUgdGltZXMgMSUgc2FtcGxlCnNpemUgaXMgZ29vZCBlbm91Z2gg dG8gZ2l2ZSB0aGUgb3B0aW1pemVyIGFsbCBuZWNlc3NhcnkgaW5mb3JtYXRpb24uClNvbWV0aW1l cyAxMDAlIHN0YXRpc3RpY3MgZG9lc24ndCBoZWxwIHRvIGltcHJvdmUgc2l0dWF0aW9uLgpUaGlz IGlzIHdoeSBzb21lIG9uZSBwYXlzIERCQS1zIGZvciB0aGUgd29yayB0aGV5IGFyZSBkb2luZyA7 KQoKSi4KCgpTWVM6dGVzdGoxMDI+IHNlbGVjdCAqIGZyb20gdiR2ZXJzaW9uClNZUzp0ZXN0ajEw Mj4gLwoKQkFOTkVSCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0KT3JhY2xlIERhdGFiYXNlIDEwZyBFbnRlcnByaXNlIEVkaXRp b24gUmVsZWFzZSAxMC4yLjAuMS4wIC0gUHJvZApQTC9TUUwgUmVsZWFzZSAxMC4yLjAuMS4wIC0g UHJvZHVjdGlvbgpDT1JFICAgIDEwLjIuMC4xLjAgICAgICBQcm9kdWN0aW9uClROUyBmb3IgMzIt Yml0IFdpbmRvd3M6IFZlcnNpb24gMTAuMi4wLjEuMCAtIFByb2R1Y3Rpb24KTkxTUlRMIFZlcnNp b24gMTAuMi4wLjEuMCAtIFByb2R1Y3Rpb24KClNZUzp0ZXN0ajEwMj4gZHJvcCB0YWJsZSB0ZXN0 X2dhdGhlcl9zdGF0ClNZUzp0ZXN0ajEwMj4gLwoKVGFibGUgZHJvcHBlZC4KClNZUzp0ZXN0ajEw Mj4gY3JlYXRlIHRhYmxlIHRlc3RfZ2F0aGVyX3N0YXQgdGFibGVzcGFjZSB1c2VycyBhcwpTWVM6 dGVzdGoxMDI+IHNlbGVjdCBscGFkKCdhJywxMDAwLCdhJykgdGV4dCBmcm9tIGRiYV9vYmplY3Rz IHdoZXJlCnJvd251bSA8PTQwMDAwClNZUzp0ZXN0ajEwMj4gLwoKVGFibGUgY3JlYXRlZC4KClNZ Uzp0ZXN0ajEwMj4gaW5zZXJ0IC0tKyBBUFBFTkQKU1lTOnRlc3RqMTAyPiBpbnRvIHRlc3RfZ2F0 aGVyX3N0YXQgYSBzZWxlY3QgKiBmcm9tIHRlc3RfZ2F0aGVyX3N0YXQKU1lTOnRlc3RqMTAyPiAv Cgo0MDAwMCByb3dzIGNyZWF0ZWQuCgpTWVM6dGVzdGoxMDI+IGNvbW1pdDsKCkNvbW1pdCBjb21w bGV0ZS4KClNZUzp0ZXN0ajEwMj4gaW5zZXJ0IC0tKyBBUFBFTkQKU1lTOnRlc3RqMTAyPiBpbnRv IHRlc3RfZ2F0aGVyX3N0YXQgYSBzZWxlY3QgKiBmcm9tIHRlc3RfZ2F0aGVyX3N0YXQKU1lTOnRl c3RqMTAyPiAvCgo4MDAwMCByb3dzIGNyZWF0ZWQuCgpTWVM6dGVzdGoxMDI+IGNvbW1pdDsKCkNv bW1pdCBjb21wbGV0ZS4KClNZUzp0ZXN0ajEwMj4gaW5zZXJ0IC0tKyBBUFBFTkQKU1lTOnRlc3Rq MTAyPiBpbnRvIHRlc3RfZ2F0aGVyX3N0YXQgYSBzZWxlY3QgKiBmcm9tIHRlc3RfZ2F0aGVyX3N0 YXQKU1lTOnRlc3RqMTAyPiAvCgoxNjAwMDAgcm93cyBjcmVhdGVkLgoKU1lTOnRlc3RqMTAyPiBj b21taXQ7CgpDb21taXQgY29tcGxldGUuCgpTWVM6dGVzdGoxMDI+IGluc2VydCAtLSsgQVBQRU5E ClNZUzp0ZXN0ajEwMj4gaW50byB0ZXN0X2dhdGhlcl9zdGF0IGEgc2VsZWN0ICogZnJvbSB0ZXN0 X2dhdGhlcl9zdGF0ClNZUzp0ZXN0ajEwMj4gLwoKMzIwMDAwIHJvd3MgY3JlYXRlZC4KClNZUzp0 ZXN0ajEwMj4gY29tbWl0OwoKQ29tbWl0IGNvbXBsZXRlLgoKU1lTOnRlc3RqMTAyPiBzZWxlY3Qg Y291bnQoKikgZnJvbSB0ZXN0X2dhdGhlcl9zdGF0OwoKICBDT1VOVCgqKQotLS0tLS0tLS0tCiAg ICA2NDAwMDAKClNZUzp0ZXN0ajEwMj4gc2VsZWN0IGJ5dGVzLzEwMjQvMTAyNCBmcm9tIGRiYV9z ZWdtZW50cyB3aGVyZQpzZWdtZW50X25hbWUgPSAnVEVTVF9HQVRIRVJfU1RBVCc7CgpCWVRFUy8x MDI0LzEwMjQKLS0tLS0tLS0tLS0tLS0tCiAgICAgICAgICAgIDcyNQoKU1lTOnRlc3RqMTAyPgpT WVM6dGVzdGoxMDI+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0KU1lTOnRlc3RqMTAyPgpTWVM6dGVzdGoxMDI+IGFsdGVyIHN5c3RlbSBmbHVzaCBC VUZGRVJfQ0FDSEU7CgpTeXN0ZW0gYWx0ZXJlZC4KClNZUzp0ZXN0ajEwMj4gc2V0IHRpbWluZyBv bgpTWVM6dGVzdGoxMDI+IGJlZ2luCnN5cy5kYm1zX3N0YXRzLmdhdGhlcl90YWJsZV9zdGF0cyhv d25uYW1lPT5udWxsLHRhYm5hbWU9PidURVNUX0dBVEhFUl9TVEFUJyxlc3RpCm1hdGVfcGVyY2Vu dD0+MjApOyBlbmQ7ClNZUzp0ZXN0ajEwMj4gLwoKUEwvU1FMIHByb2NlZHVyZSBzdWNjZXNzZnVs bHkgY29tcGxldGVkLgoKRWxhcHNlZDogMDA6MDA6MTkuMDUKU1lTOnRlc3RqMTAyPiBzZXQgdGlt aW5nIG9mZgpTWVM6dGVzdGoxMDI+IHNlbGVjdCBOVU1fUk9XUywgU0FNUExFX1NJWkUgZnJvbSBk YmFfdGFibGVzIHdoZXJlCnRhYmxlX25hbWUgPSAnVEVTVF9HQVRIRVJfU1RBVCc7CgogIE5VTV9S T1dTIFNBTVBMRV9TSVpFCi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0KICAgIDYzOTU3MCAgICAgIDEy NzkxNAoKU1lTOnRlc3RqMTAyPgpTWVM6dGVzdGoxMDI+ClNZUzp0ZXN0ajEwMj4gYWx0ZXIgc3lz dGVtIGZsdXNoIEJVRkZFUl9DQUNIRTsKClN5c3RlbSBhbHRlcmVkLgoKU1lTOnRlc3RqMTAyPiBz ZXQgdGltaW5nIG9uClNZUzp0ZXN0ajEwMj4gYmVnaW4Kc3lzLmRibXNfc3RhdHMuZ2F0aGVyX3Rh YmxlX3N0YXRzKG93bm5hbWU9Pm51bGwsdGFibmFtZT0+J1RFU1RfR0FUSEVSX1NUQVQnLGVzdGkK bWF0ZV9wZXJjZW50PT4xMDApOyBlbmQ7ClNZUzp0ZXN0ajEwMj4gLwoKUEwvU1FMIHByb2NlZHVy ZSBzdWNjZXNzZnVsbHkgY29tcGxldGVkLgoKRWxhcHNlZDogMDA6MDA6MTguMDIKU1lTOnRlc3Rq MTAyPiBzZXQgdGltaW5nIG9mZgpTWVM6dGVzdGoxMDI+IHNlbGVjdCBOVU1fUk9XUywgU0FNUExF X1NJWkUgZnJvbSBkYmFfdGFibGVzIHdoZXJlCnRhYmxlX25hbWUgPSAnVEVTVF9HQVRIRVJfU1RB VCc7CgogIE5VTV9ST1dTIFNBTVBMRV9TSVpFCi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0KICAgIDY0 MDAwMCAgICAgIDY0MDAwMAoKCk9uIDEvMjUvMDYsIEp1YW4gQ2FybG9zIFJleWVzIFBhY2hlY28g PGp1YW5jYXJsb3NyZXllc3BAZ21haWwuY29tPiB3cm90ZToKPiBIaSwgY291bGQgeW91IGdpdmUg YW4gYWR2aWNlIG9uIHRoaXMgcGxlYXNlPwo+Cj4gV2hhdCBpcyBiZXR0ZXIgdG8gc2Ugc2FtcGxl IHNpemUgdG8gMjAgb3IgdXNlIGRibXNfc3RhdHMuYXV0b19zYW1wbGVfc2l6ZQo+Cj4gUmVhZGlu ZyBvbiBhc2t0b20gSSBmb3VuZCB0aGF0IHNvbWUgdGltZXMgdXNlZCBhIDEwMCBzYW1wbGUgc2l6 ZSwgd2hlbgo+IHVzaW5nIGRibXNfc3RhdHMuYXV0b19zYW1wbGVfc2l6ZSwKPgo+IEJlY3Vhc2Ug SSdtIGFuIG9yYWNsZSBzdGFuZGFyZCBkYXRhYmFzZSB1c2VyLCBJIGNhbiB0aGluayBpbiB1c2lu ZyBhCj4gMjAlIHNhbXBsaW5nIHNpemUuCj4KPiBBbnkgY29tbWVudD8KPgo+IFRoYW5rIHlvdSA6 KQo+IC0tCj4gaHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL3dlYnBhZ2Uvb3JhY2xlLWwKPgo+Cj4K CgotLQpKdXJpanMKKzQ0IDc3MzggMDEzMDkwIChHTVQpCj09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09Cmh0dHA6Ly9vdG4ub3JhY2xlLmNvbS9vY20vanZlbGlrYW5v dnMuaHRtbAo=

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

Received on Tue Jan 31 2006 - 11:18:25 CST