From oracle-l-bounce@freelists.org Tue Mar 30 22:37:00 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2V4axl29974 for ; Tue, 30 Mar 2004 22:36:59 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2V4awo29969 for ; Tue, 30 Mar 2004 22:36:59 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C9C9635A72; Tue, 30 Mar 2004 23:33:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11109-53; Tue, 30 Mar 2004 23:33:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E0B7D635A60; Tue, 30 Mar 2004 23:33:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 23:32:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 06C12635A56 for ; Tue, 30 Mar 2004 23:32:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09565-94 for ; Tue, 30 Mar 2004 23:32:21 -0500 (EST) Received: from mailhost.kssnet.co.jp (mailhost.kssnet.co.jp [202.234.204.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D36EB635A3F for ; Tue, 30 Mar 2004 23:32:20 -0500 (EST) Received: from prem (p9103-ipadfx01kokuryo.gunma.ocn.ne.jp [220.98.193.103]) by mailhost.kssnet.co.jp (Post.Office MTA v3.5.3J release 223-101-J ID# 1001-419430633U100L2S100V35J) with ESMTP id jp for ; Wed, 31 Mar 2004 13:40:31 +0900 From: "Prem Khanna J" To: "Freelists" Subject: what exactly 'tim' means in a 10046 TRACE file ? Date: Wed, 31 Mar 2004 13:42:20 +0900 Organization: Kantoh System Message-ID: <008201c416da$8db7c890$dd00a8c0@prem> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0083_01C41725.FD9F7090" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165 X-MS-TNEF-Correlator: 00000000B6B50ACC57CB7F41875D42212617737E64F82800 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2136 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jprem@kssnet.co.jp Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=_NextPart_000_0083_01C41725.FD9F7090 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi List, i would like to know what exactly 'tim' value means in a '10046 event' trace file. (9iR2 on W2K) for example , what this means ? PARSE #1: tim=31028556368 is it the time(micro seconds) taken to parse ? (i don't think so.the query did not take so much time) OR is it the system time when the parse was done ? if so,how do i interpret it to a readable time format ? with Cary's book in front of me,i still can't get exactly what it is :( Regards, Prem. ------=_NextPart_000_0083_01C41725.FD9F7090 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IhQEAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAApAMAAAAAAACnAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANQHAwAfAA0AKgAAAAMANwEB A5AGAJAGAAAmAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAMQAAAHdoYXQgZXhhY3RseSAndGltJyBtZWFucyBpbiBhIDEwMDQ2IFRSQUNFIGZpbGUgPwAA AAACAXEAAQAAABYAAAABxBbajUqWde+2W4tL0pIOtjer8r9uAAACAR0MAQAAABgAAABTTVRQOkpQ UkVNQEtTU05FVC5DTy5KUAALAAEOAAAAAEAABg4AnDqB2hbEAQIBCg4BAAAAGAAAAAAAAAC2tQrM V8t/QYddQiEmF3N+woAAAAMAFA4AAAAACwAfDgEAAAACAQkQAQAAAGICAABeAgAANwMAAExaRnUL 63BFAwAKAHJjcGc5MzJ5APszNgHoAqQEZAIAY4JoCsBzZXQwIAhVmweyAoB9CoAIyCA7CW/YMjU1 AoASMioJsAnwqQSQYXQFsVIN4GgJgAEB0CA1LjQwLjFAMS4yMjEwAoBcknYIkHdrC4BkNAxgTmMA UAsDC2BuZxagM4IzC6YgSGkgTAQAvHQsCqIKhAqAGUB3CGAAbGQgbGlrZSChFTAga25vB+B3ENCJ BUBleADQdGx5CuPTCoEZQCd0B3AnDEARMOwgdgdAClAgB4AGIguAHCBhHRAc8RagMDQ2tRwAdgnw dB1iGbR0FRAKYxsgZgMQZS4gKCA5aVIyIAIgIFd4MkspGboCEAXAHBFtywtQGyAsG7R0aAQAHhUK Pxm1YwBAIFBBUsBTRSAjMTobMAdwpD0zFqAyOBQwNg8g7jgkpx/1JAFpI8IbIQdx7ChtDeADYCAR AAWgF1D0cykbMGEbEAOhIBQbUG8c8QqxEQAdcz8hEBlAZCcCIB0gI9Juaykgby6VKEJxClByHHZk aRrQvxuAI8Ep0SyBHhAXkGgoc+Eh5mIgT1IvZhEwJ+jkc3kZgGVtKHMbsSnx5yhCKrsZtHdhBCAr 0Rsg5yuABpAsgSxoG5Er0B5w8x5xMYBycAlwBUAoESon8x6wCXBhZAGgI0ExwyKxvwDABUAkljOE KBAu8EMKwOx5JwQgBuBvLHAegQNR7wIwIXA0kAeALBlAGYADEPsJUBnDYwBwLAEU0Bv4G8MTKBEk ATooGbpSZWeVCxFzGaVQCXBtLhm0BRIhAEBgAAADAN4/n04AAAMACVkDAAAAAwBAZQAAAAALABOA CCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAFYAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAA AAAAAwAbgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAOOQAQAeACKACCAGAAAAAADAAAAAAAAARgAA AABUhQAAAQAAAAUAAAAxMC4wAAAAAAsAI4AIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAAwAk gAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAC2ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAA AAAAAAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBIgAggBgAAAAAAwAAAAAAAAEYA AAAAgoUAAAAAAAACAfgPAQAAABAAAAC2tQrMV8t/QYddQiEmF3N+AgH6DwEAAAAQAAAAtrUKzFfL f0GHXUIhJhdzfgIB+w8BAAAAmwAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABtc3BzdC5kbGwAAAAA AE5JVEH5v7gBAKoAN9luAAAAQzpcRG9jdW1lbnRzIGFuZCBTZXR0aW5nc1xBZG1pbmlzdHJhdG9y XExvY2FsIFNldHRpbmdzXEFwcGxpY2F0aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcT3V0bG9v ay5wc3QAAAMA/g8FAAAAAwANNP03AgACARQ0AQAAABAAAABOSVRB+b+4AQCqADfZbgAAAgF/AAEA AAAxAAAAMDAwMDAwMDBCNkI1MEFDQzU3Q0I3RjQxODc1RDQyMjEyNjE3NzM3RTY0RjgyODAwAAAA AAMABhAWyH01AwAHEGYBAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAASElMSVNULElXT1VM RExJS0VUT0tOT1dXSEFURVhBQ1RMWVRJTVZBTFVFTUVBTlNJTkExMDA0NkVWRU5UVFJBQ0VGSUxF KDlJUjJPTlcySylGT1JFWEFNUExFLFdIQVRUSElTTQAAAAA2fQ== ------=_NextPart_000_0083_01C41725.FD9F7090-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------