Re: dbms_stats.auto_sample_size or sample size 20
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- Date: Tue, 31 Jan 2006 17:27:26 +0000
QlRXOiBJJ3ZlIGdvdCBpbnRlcmVzdGluZyByZXN1bHQgdXNpbmcgZGJtc19zdGF0cy5hdXRvX3Nh
bXBsZV9zaXplLiBJdAppcyBldmVuIHNsb3dlciB0aGVuIDEwMCUgaW4gdGhhdCBjYXNlLgoKU1lT
OnRlc3RqMTAyPiBzZXQgdGltaW5nIG9uClNZUzp0ZXN0ajEwMj4gYmVnaW4Kc3lzLmRibXNfc3Rh
dHMuZ2F0aGVyX3RhYmxlX3N0YXRzKG93bm5hbWU9Pm51bGwsdGFibmFtZT0+J1RFU1RfR0FUSEVS
X1NUQVQnLGVzdGkKbWF0ZV9wZXJjZW50PT5kYm1zX3N0YXRzLmF1dG9fc2FtcGxlX3NpemUpOyBl
bmQ7ClNZUzp0ZXN0ajEwMj4gLwoKUEwvU1FMIHByb2NlZHVyZSBzdWNjZXNzZnVsbHkgY29tcGxl
dGVkLgoKRWxhcHNlZDogMDA6MDA6MjQuMDQKU1lTOnRlc3RqMTAyPiBzZXQgdGltaW5nIG9mZgpT
WVM6dGVzdGoxMDI+IHNlbGVjdCBOVU1fUk9XUywgU0FNUExFX1NJWkUgZnJvbSBkYmFfdGFibGVz
IHdoZXJlCnRhYmxlX25hbWUgPSAnVEVTVF9HQVRIRVJfU1RBVCc7CgogIE5VTV9ST1dTIFNBTVBM
RV9TSVpFCi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0KICAgIDY0MDQ0NyAgICAgICAgNTc3MAoKCgoK
T24gMS8zMS8wNiwgSnVyaWpzIFZlbGlrYW5vdnMgPGoudmVsaWthbm92c0BnbWFpbC5jb20+IHdy
b3RlOgo+IEl0IGlzIGludGVyZXN0aW5nIGVub3VnaCB3aGF0IG9mdGVuIHBlb3BsZSB0aGluayB0
aGV5IGFyZSByZWR1Y2luZwo+IHN0YXRpc3RpY3MgZ2F0aGVyaW5nIHRpbWUgYnkgZGVjcmVhc2lu
ZyB0aGUgZXN0aW1hdGVfcGVyY2VudAo+IHBhcmFtZXRlci4KPiBUYWtlIGEgbG9vayBvbiB0aGUg
dGVzdCBiZWxvdy4gQWNjb3JkaW5nIHRvIHRoZSB0ZXN0IHJlc3VsdHMgdXNpbmcKPiAxMDAlIGFz
IHNhbXBsZSBzaXplIGZvciB0aGUgcGFydGljdWxhciB0YWJsZSBpcyBxdWlja2VyIHRoZW4gMjAl
Lgo+Cj4gSnVhbiCWIHVuZm9ydHVuYXRlbHkgdGhlcmUgaXMgbm8gYW4gdW5pdmVyc2FsIGFuc3dl
ciB0byB5b3VyIHF1ZXN0aW9uLgo+IFN0YXRpc3RpY3MgZ2F0aGVyaW5nIGlzIHZlcnkgY2FzZSBz
cGVjaWZpYyB0aGluay4gU2FtcGxlIHNpemUgPTEwMCUKPiBkZWxpdmVycyAxMDAlIHByZWNpc2Ug
c3RhdGlzdGljcyBhbmQgdGhlIHN0YXRpc3RpY3MgZ2F0aGVyaW5nIHByb2Nlc3MKPiBpcyBub3Qg
bmVjZXNzYXJ5IHNsb3dlciB0aGVuIHVzaW5nIDIwJSBvciAxMCUuIFNvbWUgdGltZXMgMSUgc2Ft
cGxlCj4gc2l6ZSBpcyBnb29kIGVub3VnaCB0byBnaXZlIHRoZSBvcHRpbWl6ZXIgYWxsIG5lY2Vz
c2FyeSBpbmZvcm1hdGlvbi4KPiBTb21ldGltZXMgMTAwJSBzdGF0aXN0aWNzIGRvZXNuJ3QgaGVs
cCB0byBpbXByb3ZlIHNpdHVhdGlvbi4KPiBUaGlzIGlzIHdoeSBzb21lIG9uZSBwYXlzIERCQS1z
IGZvciB0aGUgd29yayB0aGV5IGFyZSBkb2luZyA7KQo+Cj4gSi4KPgo+Cj4gU1lTOnRlc3RqMTAy
PiBzZWxlY3QgKiBmcm9tIHYkdmVyc2lvbgo+IFNZUzp0ZXN0ajEwMj4gLwo+Cj4gQkFOTkVSCj4g
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQo+IE9yYWNsZSBEYXRhYmFzZSAxMGcgRW50ZXJwcmlzZSBFZGl0aW9uIFJlbGVhc2Ug
MTAuMi4wLjEuMCAtIFByb2QKPiBQTC9TUUwgUmVsZWFzZSAxMC4yLjAuMS4wIC0gUHJvZHVjdGlv
bgo+IENPUkUgICAgMTAuMi4wLjEuMCAgICAgIFByb2R1Y3Rpb24KPiBUTlMgZm9yIDMyLWJpdCBX
aW5kb3dzOiBWZXJzaW9uIDEwLjIuMC4xLjAgLSBQcm9kdWN0aW9uCj4gTkxTUlRMIFZlcnNpb24g
MTAuMi4wLjEuMCAtIFByb2R1Y3Rpb24KPgo+IFNZUzp0ZXN0ajEwMj4gZHJvcCB0YWJsZSB0ZXN0
X2dhdGhlcl9zdGF0Cj4gU1lTOnRlc3RqMTAyPiAvCj4KPiBUYWJsZSBkcm9wcGVkLgo+Cj4gU1lT
OnRlc3RqMTAyPiBjcmVhdGUgdGFibGUgdGVzdF9nYXRoZXJfc3RhdCB0YWJsZXNwYWNlIHVzZXJz
IGFzCj4gU1lTOnRlc3RqMTAyPiBzZWxlY3QgbHBhZCgnYScsMTAwMCwnYScpIHRleHQgZnJvbSBk
YmFfb2JqZWN0cyB3aGVyZQo+IHJvd251bSA8PTQwMDAwCj4gU1lTOnRlc3RqMTAyPiAvCj4KPiBU
YWJsZSBjcmVhdGVkLgo+Cj4gU1lTOnRlc3RqMTAyPiBpbnNlcnQgLS0rIEFQUEVORAo+IFNZUzp0
ZXN0ajEwMj4gaW50byB0ZXN0X2dhdGhlcl9zdGF0IGEgc2VsZWN0ICogZnJvbSB0ZXN0X2dhdGhl
cl9zdGF0Cj4gU1lTOnRlc3RqMTAyPiAvCj4KPiA0MDAwMCByb3dzIGNyZWF0ZWQuCj4KPiBTWVM6
dGVzdGoxMDI+IGNvbW1pdDsKPgo+IENvbW1pdCBjb21wbGV0ZS4KPgo+IFNZUzp0ZXN0ajEwMj4g
aW5zZXJ0IC0tKyBBUFBFTkQKPiBTWVM6dGVzdGoxMDI+IGludG8gdGVzdF9nYXRoZXJfc3RhdCBh
IHNlbGVjdCAqIGZyb20gdGVzdF9nYXRoZXJfc3RhdAo+IFNZUzp0ZXN0ajEwMj4gLwo+Cj4gODAw
MDAgcm93cyBjcmVhdGVkLgo+Cj4gU1lTOnRlc3RqMTAyPiBjb21taXQ7Cj4KPiBDb21taXQgY29t
cGxldGUuCj4KPiBTWVM6dGVzdGoxMDI+IGluc2VydCAtLSsgQVBQRU5ECj4gU1lTOnRlc3RqMTAy
PiBpbnRvIHRlc3RfZ2F0aGVyX3N0YXQgYSBzZWxlY3QgKiBmcm9tIHRlc3RfZ2F0aGVyX3N0YXQK
PiBTWVM6dGVzdGoxMDI+IC8KPgo+IDE2MDAwMCByb3dzIGNyZWF0ZWQuCj4KPiBTWVM6dGVzdGox
MDI+IGNvbW1pdDsKPgo+IENvbW1pdCBjb21wbGV0ZS4KPgo+IFNZUzp0ZXN0ajEwMj4gaW5zZXJ0
IC0tKyBBUFBFTkQKPiBTWVM6dGVzdGoxMDI+IGludG8gdGVzdF9nYXRoZXJfc3RhdCBhIHNlbGVj
dCAqIGZyb20gdGVzdF9nYXRoZXJfc3RhdAo+IFNZUzp0ZXN0ajEwMj4gLwo+Cj4gMzIwMDAwIHJv
d3MgY3JlYXRlZC4KPgo+IFNZUzp0ZXN0ajEwMj4gY29tbWl0Owo+Cj4gQ29tbWl0IGNvbXBsZXRl
Lgo+Cj4gU1lTOnRlc3RqMTAyPiBzZWxlY3QgY291bnQoKikgZnJvbSB0ZXN0X2dhdGhlcl9zdGF0
Owo+Cj4gICBDT1VOVCgqKQo+IC0tLS0tLS0tLS0KPiAgICAgNjQwMDAwCj4KPiBTWVM6dGVzdGox
MDI+IHNlbGVjdCBieXRlcy8xMDI0LzEwMjQgZnJvbSBkYmFfc2VnbWVudHMgd2hlcmUKPiBzZWdt
ZW50X25hbWUgPSAnVEVTVF9HQVRIRVJfU1RBVCc7Cj4KPiBCWVRFUy8xMDI0LzEwMjQKPiAtLS0t
LS0tLS0tLS0tLS0KPiAgICAgICAgICAgICA3MjUKPgo+IFNZUzp0ZXN0ajEwMj4KPiBTWVM6dGVz
dGoxMDI+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0KPiBTWVM6dGVzdGoxMDI+Cj4gU1lTOnRlc3RqMTAyPiBhbHRlciBzeXN0ZW0gZmx1c2ggQlVG
RkVSX0NBQ0hFOwo+Cj4gU3lzdGVtIGFsdGVyZWQuCj4KPiBTWVM6dGVzdGoxMDI+IHNldCB0aW1p
bmcgb24KPiBTWVM6dGVzdGoxMDI+IGJlZ2luCj4gc3lzLmRibXNfc3RhdHMuZ2F0aGVyX3RhYmxl
X3N0YXRzKG93bm5hbWU9Pm51bGwsdGFibmFtZT0+J1RFU1RfR0FUSEVSX1NUQVQnLGVzdGkKPiBt
YXRlX3BlcmNlbnQ9PjIwKTsgZW5kOwo+IFNZUzp0ZXN0ajEwMj4gLwo+Cj4gUEwvU1FMIHByb2Nl
ZHVyZSBzdWNjZXNzZnVsbHkgY29tcGxldGVkLgo+Cj4gRWxhcHNlZDogMDA6MDA6MTkuMDUKPiBT
WVM6dGVzdGoxMDI+IHNldCB0aW1pbmcgb2ZmCj4gU1lTOnRlc3RqMTAyPiBzZWxlY3QgTlVNX1JP
V1MsIFNBTVBMRV9TSVpFIGZyb20gZGJhX3RhYmxlcyB3aGVyZQo+IHRhYmxlX25hbWUgPSAnVEVT
VF9HQVRIRVJfU1RBVCc7Cj4KPiAgIE5VTV9ST1dTIFNBTVBMRV9TSVpFCj4gLS0tLS0tLS0tLSAt
LS0tLS0tLS0tLQo+ICAgICA2Mzk1NzAgICAgICAxMjc5MTQKPgo+IFNZUzp0ZXN0ajEwMj4KPiBT
WVM6dGVzdGoxMDI+Cj4gU1lTOnRlc3RqMTAyPiBhbHRlciBzeXN0ZW0gZmx1c2ggQlVGRkVSX0NB
Q0hFOwo+Cj4gU3lzdGVtIGFsdGVyZWQuCj4KPiBTWVM6dGVzdGoxMDI+IHNldCB0aW1pbmcgb24K
PiBTWVM6dGVzdGoxMDI+IGJlZ2luCj4gc3lzLmRibXNfc3RhdHMuZ2F0aGVyX3RhYmxlX3N0YXRz
KG93bm5hbWU9Pm51bGwsdGFibmFtZT0+J1RFU1RfR0FUSEVSX1NUQVQnLGVzdGkKPiBtYXRlX3Bl
cmNlbnQ9PjEwMCk7IGVuZDsKPiBTWVM6dGVzdGoxMDI+IC8KPgo+IFBML1NRTCBwcm9jZWR1cmUg
c3VjY2Vzc2Z1bGx5IGNvbXBsZXRlZC4KPgo+IEVsYXBzZWQ6IDAwOjAwOjE4LjAyCj4gU1lTOnRl
c3RqMTAyPiBzZXQgdGltaW5nIG9mZgo+IFNZUzp0ZXN0ajEwMj4gc2VsZWN0IE5VTV9ST1dTLCBT
QU1QTEVfU0laRSBmcm9tIGRiYV90YWJsZXMgd2hlcmUKPiB0YWJsZV9uYW1lID0gJ1RFU1RfR0FU
SEVSX1NUQVQnOwo+Cj4gICBOVU1fUk9XUyBTQU1QTEVfU0laRQo+IC0tLS0tLS0tLS0gLS0tLS0t
LS0tLS0KPiAgICAgNjQwMDAwICAgICAgNjQwMDAwCj4KPgo+IE9uIDEvMjUvMDYsIEp1YW4gQ2Fy
bG9zIFJleWVzIFBhY2hlY28gPGp1YW5jYXJsb3NyZXllc3BAZ21haWwuY29tPiB3cm90ZToKPiA+
IEhpLCBjb3VsZCB5b3UgZ2l2ZSBhbiBhZHZpY2Ugb24gdGhpcyBwbGVhc2U/Cj4gPgo+ID4gV2hh
dCBpcyBiZXR0ZXIgdG8gc2Ugc2FtcGxlIHNpemUgdG8gMjAgb3IgdXNlIGRibXNfc3RhdHMuYXV0
b19zYW1wbGVfc2l6ZQo+ID4KPiA+IFJlYWRpbmcgb24gYXNrdG9tIEkgZm91bmQgdGhhdCBzb21l
IHRpbWVzIHVzZWQgYSAxMDAgc2FtcGxlIHNpemUsIHdoZW4KPiA+IHVzaW5nIGRibXNfc3RhdHMu
YXV0b19zYW1wbGVfc2l6ZSwKPiA+Cj4gPiBCZWN1YXNlIEknbSBhbiBvcmFjbGUgc3RhbmRhcmQg
ZGF0YWJhc2UgdXNlciwgSSBjYW4gdGhpbmsgaW4gdXNpbmcgYQo+ID4gMjAlIHNhbXBsaW5nIHNp
emUuCj4gPgo+ID4gQW55IGNvbW1lbnQ/Cj4gPgo+ID4gVGhhbmsgeW91IDopCj4gPiAtLQo+ID4g
aHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL3dlYnBhZ2Uvb3JhY2xlLWwKPiA+Cj4gPgo+ID4KPgo+
Cj4gLS0KPiBKdXJpanMKPiArNDQgNzczOCAwMTMwOTAgKEdNVCkKPiA9PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PQo+IGh0dHA6Ly9vdG4ub3JhY2xlLmNvbS9vY20v
anZlbGlrYW5vdnMuaHRtbAo+CgoKLS0KSnVyaWpzCis0NCA3NzM4IDAxMzA5MCAoR01UKQo9PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQpodHRwOi8vb3RuLm9yYWNs
ZS5jb20vb2NtL2p2ZWxpa2Fub3ZzLmh0bWwK
--
//www.freelists.org/webpage/oracle-l
Other related posts:
