Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_stats.auto_sample_size or sample size 20

Re: dbms_stats.auto_sample_size or sample size 20

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


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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 31 2006 - 11:27:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US