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

Home -> Community -> Mailing Lists -> Oracle-L -> A brief doc on 10046 tracing

A brief doc on 10046 tracing

From: Robyn <robyn.sands_at_gmail.com>
Date: Wed, 20 Jul 2005 11:37:12 -0400
Message-ID: <ece8554c050720083777242c04@mail.gmail.com>


SGVsbG8gYWxsLAoKSSd2ZSBiZWVuIGFza2VkIHRvIHByb3ZpZGUgYSBzaG9ydCBkb2Mgb24gMTAw NDYgdHJhY2luZyBmb3IgREJBcyBhbmQKZGV2ZWxvcGVycy4gU28sIGF0IHRoZSByaXNrIG9mIGlt cG9zaW5nLCB0aGUgdGV4dCBvZiBteSBmaXJzdCBkcmFmdCBpcwpiZWxvdy4gIEkgcGxhbiBvbiBp bmNsdWRpbmcgYSBjb3B5IG9mIE9yYWNsZSBOb3RlIDM5ODE3LjEgYXMgYW4KYXBwZW5kaXggYXMg d2VsbCBhcyBzb21lIHNhbXBsZSB0cmFjZSBmaWxlcyBmcm9tIHZhcmlvdXMgc3lzdGVtcy4gSQp3 aWxsIGFsc28gYmUgc3VnZ2VzdGluZyB0aGF0IGludGVyZXN0ZWQgcGFydGllcyBwdXJjaGFzZSBD YXJ5J3MgYm9vay4gCihJJ20gbm90IHNoYXJpbmcgbWluZSB3aXRoIHRoaXMgY3Jvd2QgLSBpdCBt YXkgbm90IGNvbWUgYmFjay4pCgpBbnkgc3VnZ2VzdGlvbnMsIGZlZWRiYWNrLCBldGMgd291bGQg YmUgYXBwcmVjaWF0ZWQuICBJJ20gdGhlIG9ubHkgb25lCmhlcmUgdGhhdCBrbm93cyBob3cgdG8g ZG8gdGhpcywgYW5kIEkgbmVlZCB0byBrZWVwIGl0IHNob3J0IGFuZApzaW1wbGUsIGJ1dCBjbGVh ciB0byB0aGUgdW5pbml0aWF0ZWQuICBJZiBhbnkgb25lIHdvdWxkIHByZWZlciB0aGF0IEkKc2Vu ZCB0aGUgZG9jIGRpcmVjdGx5IHRvIHRoZW0gYXMgYW4gYXR0YWNobWVudCwgcGxlYXNlIGxldCBt ZSBrbm93LgoKVGhhbmtzIGluIGFkdmFuY2UsCgpSb2J5bgoKCk9yYWNsZSAxMDA0NiBUcmFjZQoK T3JhY2xlIGlzIGNhcGFibGUgb2YgcHJvdmlkaW5nIGRldGFpbGVkIGluc3RydW1lbnRhdGlvbiBk YXRhIHRoYXQgY2FuCmJlIHVzZWQgdG8gbG9jYXRlIGFuIGVycm9yLCB0byBldmFsdWF0ZSBiaW5k IHZhcmlhYmxlcyBvciB0byBpZGVudGlmeQphbmQgcmVzb2x2ZSBhIHBlcmZvcm1hbmNlIGlzc3Vl LiAgVGhpcyBpbmZvcm1hdGlvbiBjYW4gYmUgYWNjZXNzZWQgdmlhCmEgMTAwNDYgdHJhY2UuICBB IDEwMDQ2IGRlZXAgdHJhY2UgKGxldmVsIDEyKSBzaG93cyBleGFjdGx5IGhvdyB0aGUKZGF0YWJh c2UgaXMgcHJvY2Vzc2luZyBhIHF1ZXJ5LCB0aGUgZXZlbnRzIHRoZSBzeXN0ZW0gaXMgd2FpdGlu ZyBvbgphbmQgaG93IG11Y2ggdGltZSBpdCBzcGVuZHMgd2FpdGluZyBmb3IgYSBzcGVjaWZpYyBl dmVudC4gIEJ5IGxvY2F0aW5nCnRoZSBzcGVjaWZpYyBwcm9jZXNzIG9yIHF1ZXJ5IHRoYXQgaXMg InRvbyBzbG93IiBhbmQgY2FwdHVyaW5nIGEgdHJhY2UKZmlsZSwgaXQgYmVjb21lcyBwb3NzaWJs ZSB0byBkZXRlcm1pbmUgdGhlIGltcHJvdmVtZW50IHRoYXQgd2lsbCBoYXZlCnRoZSBtb3N0IHNp Z25pZmljYW50IGltcGFjdCBvbiBwZXJmb3JtYW5jZS4gIEJ5IHJlY2FwdHVyaW5nIHRoZQp0cmFj aW5nIGF0IGRpZmZlcmVudCBwaGFzZXMgb2YgdGhlIHR1bmluZyBwcm9jZXNzLCBpdCBpcyBwb3Nz aWJsZSB0bwpjbGVhcmx5IGlkZW50aWZ5IGFuZCBxdWFudGlmeSBob3cgdGhlIHByb2Nlc3MgaGFz IGltcHJvdmVkLgoKV2hlbiBpbXBsZW1lbnRpbmcgYSAxMDA0NiB0cmFjZSwgdGhlIG9wdGltYWwg YXBwcm9hY2ggd2lsbCBjYXB0dXJlCm9ubHkgdGhlIHF1ZXJ5IG9yIHN1YnF1ZXJ5IHRoYXQgbmVl ZHMgdG8gYmUgZXZhbHVhdGVkLiAgVGhlIGdvYWwgaXMgdG8KZW5zdXJlIHRoYXQgb25seSB0aGUg cmVzb3VyY2VzIGJlaW5nIHVzZWQgYnkgdGhhdCBjcml0aWNhbCBwcm9jZXNzIGFyZQpyZWZsZWN0 ZWQgaW4gdGhlIHRyYWNlIGZpbGUuICBXaGVuIHBvc3NpYmxlLCB0aGUgYmVzdCBhcHByb2FjaCBp cyBvcGVuCmEgbmV3IHNlc3Npb24sIHR1cm4gdGhlIHRyYWNlIG9uLCBydW4gdGhlIHF1ZXJ5IGFu ZCBkZWFjdGl2YXRlIHRyYWNlCmluIG9uZSBzY3JpcHQuICBUaGlzIHByZXZlbnRzIG1pc2xlYWRp bmcgd2FpdCB0aW1lcyBmcm9tIGJlaW5nCnJlY29yZGVkIGluIHRoZSB0cmFjZSBmaWxlLiAgSXQg aXMgcG9zc2libGUgdG8gY2FwdHVyZSBhbmQgdHJhY2UgYQpsb25nIHJ1bm5pbmcgYWN0aXZlIHNl c3Npb247IHRoZSB0cmFjZSBmaWxlIG1heSBiZSBpbmNvbXBsZXRlIGJ1dCBpdAppcyBsaWtlbHkg dGhlIHByb2JsZW0gZXZlbnQgd2lsbCBiZSBjYXB0dXJlZC4KClRoZSBiYXNpYyB0cmFjZSBwcm9j ZXNzIGlzIHNob3duIGJlbG93LiAgU2FtcGxlIGNvbW1hbmRzIHdpbGwgZm9sbG93LgoKlQlTdGFy dCBhIG5ldyBzZXNzaW9uCpUJU2V0IFRpbWVkIFN0YXRpc3RpY3MgdG8gVFJVRSAKlQlTZXQgbWF4 X2R1bXBfZmlsZV9zaXplIHRvIFVOTElNSVRFRAqVCVNldCB0aGUgbmFtZSBvZiB0aGUgdHJhY2Ug ZmlsZSB0byBpbmNsdWRlIGFuIGVhc2lseSBmb3VuZCB2YWx1ZQooeW91ciBuYW1lIGlzIHVzdWFs bHkgYSBnb29kIG9wdGlvbikKlQlUdXJuIG9uIHRyYWNlIHdpdGggRXZlbnQgMTAwNDYgYXQgdGhl IGRlc2lyZWQgbGV2ZWwgKDEsNCw4IG9yIDEyKQqVCVBlcmZvcm0geW91ciB0cmFjaW5nIGV2ZW50 LiBDbGljayBvbiBhIGJ1dHRvbiBvbiBhIGZvcm0sIHJ1biBhIHNxbApzdGF0ZW1lbnQsIGV0Yy4K lQlUdXJuIHRyYWNlIG9mZiBhcyBzb29uIGFzIGNvbnRyb2wgcmV0dXJucyBiYWNrIHRvIHRoZSB1 c2VyCpUJU2VhcmNoIHRoZSByYXcgdHJhY2UgZmlsZSBmb3IgZXJyb3IgaW5mb3JtYXRpb24gaWYg dHJhY2luZyBhIGZhaWxlZCBwcm9jZXNzCpUJRXhlY3V0ZSBUa3Byb2YgdXNpbmcgcmF3IHRyYWNl IGZpbGUgYXMgaW5wdXQgZm9yIHBlcmZvcm1hbmNlIGlzc3VlcwoKVG8gdHJhY2UgYSBsb25nIHJ1 bm5pbmcgc2Vzc2lvbiB0aGF0IGlzIGFscmVhZHkgaW4gcHJvY2VzcywgZmluZCB0aGUKc2lkIGFu ZCBzZXJpYWwjIG9mIHRoZSBwcm9jZXNzLiAgVGhlc2UgdmFsdWVzIGNhbiB0aGVuIGJlIHVzZWQg dG8gc2V0CmEgMTAwNDYgZXZlbnQgZnJvbSBhbm90aGVyIHNlc3Npb24uICBUaGUgY29tbWFuZHMg dG8gdHJhY2UgYW4gZXhpc3RpbmcKc2Vzc2lvbiBzaG91bGQgYmUgZXhlY3V0ZWQgYnkgYSBEQkEu ICBSZXF1ZXN0IGFzc2lzdGFuY2UgaWYgeW91IGRvIG5vdApoYXZlIHRoaXMgbGV2ZWwgb2YgYWNj ZXNzLgoKClRyYWNlIExldmVscyAKCkxldmVsIDEJCkRlZmF1bHQgdHJhY2UgbGV2ZWwuIFRoaXMg bGV2ZWwgdHJhY2VzIGFsbCBhY3Rpdml0aWVzIHVudGlsIHRoZSB0cmFjZQpzZXNzaW9uIGlzIHN0 b3BwZWQuCgpMZXZlbCA0CQpQcm92aWRlcyBsZXZlbCAxIHRyYWNpbmcgYW5kIGRpc3BsYXlzIHRo ZSBlbnRlcmVkIHZhbHVlIGZvciBhbGwgYmluZAp2YXJpYWJsZXMuIEJpbmQgdmFyaWFibGVzIGFy ZSB0aGUgdmFsdWVzIHRoYXQgdGhlIHVzZXIgZW50ZXJzLiBUaGUKY29kZSBkaXNwbGF5cyB0aGVz ZSBiaW5kIHZhcmlhYmxlcyBhczogYjEsIGV0Yy4gV2hlbiBsZXZlbCA0IGlzCmFjdGl2YXRlZCwg dGhlIHN1YnN0aXR1dGVkIHZhbHVlIGZvciB0aGUgYmluZCB2YXJpYWJsZSBpcyBkaXNwbGF5ZWQg aW4KdGhlIHRyYWNlIGZpbGUuIEEgbGV2ZWwgNCB0cmFjZSB3aWxsIGJlIG9wdGltYWwgZm9yIGVy cm9yIHRyYWNpbmcuCgpMZXZlbCA4ICAKUHJvdmlkZXMgbGV2ZWwgMSB0cmFjaW5nIGFuZCBkaXNw bGF5cyBhIGxpc3Qgb2YgYWxsIGRhdGFiYXNlIHdhaXQKZXZlbnRzLiBEYXRhYmFzZSB3YWl0IGV2 ZW50cyBsaXN0IHRoZSByZWFzb25zIGlmIHRoZSBlbGFwc2VkIHRpbWUgaXMKZ3JlYXRlciB0aGFu IHRoZSBDUFUgdGltZSBpbiB0aGUgdGtwcm9mIHJlcG9ydC4KCkxldmVsIDEyICAKUHJvdmlkZXMg bGV2ZWwgMSB0cmFjaW5nIGluIGFkZGl0aW9uIHRvIGJvdGggYmluZCB2YXJpYWJsZQpzdWJzdGl0 dXRpb24gYW5kIGRhdGFiYXNlIHdhaXQgZXZlbnRzLiAgQSBsZXZlbCAxMiB0cmFjZSBpcyB1c2Vk IGZvcgpwZXJmb3JtYW5jZSBpc3N1ZXMuCgpTYW1wbGUgQ29tbWFuZHMKClRyYWNpbmcgYSBzdGF0 ZW1lbnQgZm9yIGJpbmQgdmFyaWFibGUgaXNzdWVzIG9yIGVycm9ycwoKLS0tIFNldHVwIFRyYWNp bmcKYWx0ZXIgc2Vzc2lvbiBzZXQgdGltZWRfc3RhdGlzdGljcz10cnVlOwphbHRlciBzZXNzaW9u IHNldCBtYXhfZHVtcF9maWxlX3NpemU9dW5saW1pdGVkOwphbHRlciBzZXNzaW9uIHNldCB0cmFj ZWZpbGVfaWRlbnRpZmllcj0ncm9ieW4nOwoKLS0tIEFjdGl2YXRlIHRoZSBUcmFjZQphbHRlciBz ZXNzaW9uIHNldCBldmVudHMgJzEwMDQ2IHRyYWNlIG5hbWUgY29udGV4dCBmb3JldmVyLCBsZXZl bCA0JzsKLyogY29kZSB0byBiZSB0cmFjZWQgZ29lcyBoZXJlICovCmFsdGVyIHNlc3Npb24gc2V0 IGV2ZW50cyAnMTAwNDYgdHJhY2UgbmFtZSBjb250ZXh0IG9mZic7CgoKVHJhY2luZyBhIHN0YXRl bWVudCBmb3IgcGVyZm9ybWFuY2UgaXNzdWVzCgotLS0gU2V0dXAgVHJhY2luZwphbHRlciBzZXNz aW9uIHNldCB0aW1lZF9zdGF0aXN0aWNzPXRydWU7CmFsdGVyIHNlc3Npb24gc2V0IG1heF9kdW1w X2ZpbGVfc2l6ZT11bmxpbWl0ZWQ7CmFsdGVyIHNlc3Npb24gc2V0IHRyYWNlZmlsZV9pZGVudGlm aWVyPSdyb2J5bic7CgotLS0gQWN0aXZhdGUgdGhlIFRyYWNlCmFsdGVyIHNlc3Npb24gc2V0IGV2 ZW50cyAnMTAwNDYgdHJhY2UgbmFtZSBjb250ZXh0IGZvcmV2ZXIsIGxldmVsIDEyJzsKLyogY29k ZSB0byBiZSB0cmFjZWQgZ29lcyBoZXJlICovCmFsdGVyIHNlc3Npb24gc2V0IGV2ZW50cyAnMTAw NDYgdHJhY2UgbmFtZSBjb250ZXh0IG9mZic7CgoKVHJhY2luZyBhbiBhbHJlYWR5IGFjdGl2ZSwg bG9uZyBydW5uaW5nIHNlc3Npb24uICAoREJBIG9ubHkpCgpGaW5kIHYkc2Vzc2lvbi5zaWQgYW5k IHYkc2Vzc2lvbi5zZXJpYWwjIGZvciBzZXNzaW9uIHRvIGJlIHRyYWNlZCBhbmQKc2V0IHRpbWVk X3N0YXRpc3RpY3MgYW5kIG1heF9kdW1wX2ZpbGVfc2l6ZSBhcyBmb2xsb3dzOgoKZXhlYyBkYm1z X3N5c3RlbS5TRVRfQk9PTF9QQVJBTV9JTl9TRVNTSU9OICgKCXNpZCA9PiAjIywKCXNlcmlhbCMg PT4gIyMjIywKCXBhcm5hbSA9PiAndGltZWRfc3RhdGlzdGljcycsCglidmFsID0+IHRydWUpCmV4 ZWMgZGJtc19zeXN0ZW0uU0VUX0lOVF9QQVJBTV9JTl9TRVNTSU9OICgKCXNpZCA9PiAjIywKCXNl cmlhbCMgPT4gIyMjIywKCXBhcm5hbSA9PiAnbWF4X2R1bXBfZmlsZV9zaXplJywKCWJ2YWwgPT4g MjE0NzQ4MzY0NykKCi0tLSBBY3RpdmF0ZSBUcmFjZSwgT3B0aW9uIDEgKEJlIHZlcnkgY2FyZWZ1 bCEgSXQgaXMgcG9zc2libGUgdG8gZW50ZXIKZGFuZ2Vyb3VzIHZhbHVlcyBiZXR3ZWVuIHRoZSBw YXJlbnRoZXNpcy4pCmV4ZWMgZGJtc19zeXN0ZW0uc2V0X2V2KAoJc2lkID0+ICMjLAoJc2VyaWFs ID0+ICMjIyMsCmV2ZW50ID0+IDEwMDQ2LApsZXZlbCA9PiAxMiwKbnVsbCA9PiAnJykKLyogV2Fp dCBmb3IgZXhlY3V0aW5nIGNvZGUgdG8gY29tcGxldGUgZHVyaW5nIHRoaXMgdGltZSB3aW5kb3cg Ki8KZXhlYyBkYm1zX3N5c3RlbS5zZXRfZXYoCglzaWQgPT4gIyMsCglzZXJpYWwgPT4gIyMjIywK ZXZlbnQgPT4gMTAwNDYsCmxldmVsID0+IDAsCm51bGwgPT4gJycpCgotLS0gQWN0aXZhdGUgVHJh Y2UsIE9wdGlvbiAyICAoTGVzcyBkYW5nZXJvdXMsIGJ1dCBkb2VzIG5vdCBwcm92aWRlCnRpbWlu ZyBmb3Igd2FpdHMgYW5kIGJpbmRzLikKZXhlYyBkYm1zX3N1cHBvcnQuc3RhcnRfdHJhY2VfaW5f c2Vzc2lvbigKCXNpZCA9PiAjIywKCXNlcmlhbCA9PiAjIyMjLAoJd2FpdHMgPT4gdHJ1ZSwKCWJp bmRzID0+IHRydWUpCi8qIGNvZGUgdG8gYmUgdHJhY2VkIGV4ZWN1dGVzIGR1cmluZyB0aGlzIHRp bWUgd2luZG93ICovCmV4ZWMgZGJtc19zdXBwb3J0LnN0b3BfdHJhY2VfaW5fc2Vzc2lvbigKCXNp ZCA9PiAjIywKCXNlcmlhbCA9PiAjIyMjKQoKRG8gbm90IHVzZSBkYm1zX3N5c3RlbS5zZXRfc3Fs X3RyYWNlX2luX3Nlc3Npb24gZm9yIGV4dGVuZGVkIHRyYWNpbmcuIApJdCBkb2VzIG5vdCBwcm92 aWRlIHRpbWluZyBmb3Igd2FpdHMgYW5kIGJpbmRzLgo=

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 20 2005 - 10:39:13 CDT

Original text of this message

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