Re: Large table query with cpu throttling
Date: Tue, 19 Feb 2008 12:31:07 +0800
Message-ID: <804dabb00802182031w5cb70071h265e6d3ccc4314bb@mail.gmail.com>
UGFydCBvZiB0aGUgZm9sbG93aW5nIGFyZSBhIHJlc2VudCwgYXMgSSBmb3VuZCB0aGUgZnJlZWxp
c3Qgd2Vic2l0ZSBhCmxvdCBvZiBnYXJiYWdlLiAgIE5vdCBzdXJlIHdoeS4KClRoYW5rIHlvdSB2
ZXJ5IG11Y2ggUGF0cmljayBhbmQgwba1v7/tICh1a2phLmRpb24pLgoKMjAwOC8yLzE5IMG2tb+/
7SA8dWtqYS5kaW9uQGdtYWlsLmNvbT46Cj4gQnV0IHdoYXQncyB0aGUgbWVyaXQgb2YgdGhlIHBh
cnRpdGlvbiB3aGVuIHlvdSBzaG91bGQgZXh0cmFjdCBhbGwgdGhlCj4gcmVjb3JkcyhhcyBPcCBz
YWlkKSBhbmQgZG9uJ3QgbmVlZCB0byBkZWxldGUgc29tZSByZWdpb24gb2YgZGF0YQo+IHBlcmlv
ZGljYWxseT8KPiBJIGNhbid0IGluZmVyIGFueSBuZWNlc3NpdHkgb2YgcGFydGl0aW9uIGZyb20g
T1AncyByZXF1ZXN0Lgo+CgpBbm90aGVyIHJlYXNvbiBpcyBJIGFtIG5vdCB0aGUgb3duZXIgb2Yg
dGhlIGRhdGFiYXNlIDotKSwgaXQgd2FzCmxlZ2FjeSwgYW5kIG1hbnkgYXBwbGljYXRpb25zIGhh
dmUgYmVlbiBydW5uaW5nIG9uIHRvcCBvZiBpdCB3aXRob3V0CmFueSBpc3N1ZSwgc28gSSBhbSBh
ZnJhaWQgbW9kaWZ5aW5nIGl0cyBkZXNpZ24gaXMgdW5saWtlbHkuCgo+IE15IHJlY29tbWVuZGF0
aW9uIGZvciBDUFUgdGhyb3R0bGluZyBpcwo+IChwc2V1ZG8gY29kZSkKPgo+IGxvb3AKPiAgICBi
dWxrIGNvbGxlY3QgZnJvbSB5b3VyX3RhYmxlIHRvIGFycmFyeTsKPiAgICAgZXhpdCB3aGVuIG5v
IHJvd3MgZm91bmQgZXhpdCBsb29wOwo+ICAgIGRvIHNvbWV0aGluZyB3aXRoIHlvdXIgZmV0Y2hl
ZCBhcnJheTsKPiAgICAgc2xlZXAgZm9yIGEgc2hvcnQgdGltZTsgKGRibXNfbG9jay5zbGVlcCgw
LjEpKTsKPiBlbmQgbG9vcDsKPgo+Cj4KPgpHb29kIHNvbHV0aW9uLCBhcyBteSBvcmlnaW5hbCB3
YXMgYSBob2RnZXBvZGdlIG9mIHNjcmlwdHMgKyBwbC9zcWwuCm5vdyB0aGlzIGlzIGVudGlyZWx5
IHBsL3NxbCAtIHRoYW5rIHlvdSB2ZXJ5IG11Y2guCiAodW5sZXNzIG1vcmUgY29tcGxleCBzdHVm
ZiBuZWVkIHRvIGJlIGRvbmUgd2l0aCB0aGUgZmV0Y2hlZCBhcnJheSAtCnRoZW4gQyBtYXkgY29t
ZSBpbikuCgpBZnRlciBzb21lIHRob3VnaHRzLCBmdXJ0aGVyIHRvIG15IGNvbW1lbnQgYWJvdmU6
CgpTb2xuIDIgd29uJ3Qgd29yazogICBJdCBpcyBpbXBvc3NpYmxlIHRvIGF1dG9tYXRpY2FsbHkg
Z2VuZXJhdGUgdGhlCmVudGlyZSB1bml2ZXJzZSBvZiB0aGUgcm93aWQgdmFsdWVzIC0gdGhlIHNw
YWNlIG9mIHBvc3NpYmlsaXRpZXMgaXMKanVzdCB0b28gbGFyZ2UuCgpTb2xuIDMgd29uJ3Qgd29y
ayBlaXRoZXI6ICAgIlNFTEVDVCByb3dpZCIgcmV0dXJuZWQgYSByZXN1bHQgdGhhdCBpcwpub3Qg
YWx3YXlzIHRoZSBzYW1lIGFzICJTRUxFQ1Qgcm93aWQgb3JkZXIgYnkgcm93aWQiIGFuZCBzbyBp
dCBpcwppbXBvc3NpYmxlIHRvIGRvIGJhdGNoaW5nIG9mIGZpcnN0IDEwMCByb3dzLCB0aGVuIG5l
eHQgMTAwIHJvd3MgYW5kIHNvCm9uIChieSB1c2luZyAiU0VMRUNUIHJvd2lkIiB3aXRob3V0IHRo
ZSAib3JkZXIgYnkiKS4gICBUaGUgc29sdXRpb24Kd2lsbCB3b3JrIGlmIEkgY2FuIGRvIGEgIm9y
ZGVyIGJ5IHJvd2lkIiwgYnV0IHRoaXMgaXMgaW1wb3NzaWJsZSwgYXMKdGhlcmUgYXJlIHRyYW5z
YWN0aW9ucyB0aGF0IHJlZ3VsYXJseSB1cGRhdGUgdGhlIHRhYmxlLCBhbmQgdG8KY29uc3RydWN0
IGEgIm9yZGVyIGJ5IHJvd2lkIiBzZWVtZWQgaW1wb3NzaWJsZSAoYXNzdW1pbmcgZXZlcnkgbWlu
dXRlCkkgZXh0cmFjdCBvbmx5IDEwMCByb3dzLCBzbyBldmVyeSBtaW51dGUgdGhlcmUgaXMgYSBu
ZWVkIHRvIHJlb3JkZXIKdGhlIHRhYmxlIGJ5IHJvd2lkIC0gb2YgMSBiaWxsaW9uIHJvd3M/KQoK
U28gQUxMIG15IHByZXZpb3VzIHByb3Bvc2VkIHNvbHV0aW9uIHNlZW1lZCBub3Qgd29ya2luZyAt
IGF0IGxlYXN0IGluCnRoZSBoZWFkIHNvIGZhci4gICBBbnkgc3VnZ2VzdGlvbnM/Cg==
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 18 2008 - 22:31:07 CST