Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> A brief doc on 10046 tracing
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-lReceived on Wed Jul 20 2005 - 10:39:13 CDT
![]() |
![]() |