From oracle-l-bounce@freelists.org Wed Mar 31 00:35:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2V6Zw214187 for ; Wed, 31 Mar 2004 00:35:58 -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 i2V6Zuo14182 for ; Wed, 31 Mar 2004 00:35:57 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CD9E8634CAA; Wed, 31 Mar 2004 01:32:28 -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 31722-96; Wed, 31 Mar 2004 01:32:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D6AA634C58; Wed, 31 Mar 2004 01:32:28 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 31 Mar 2004 01:31:18 -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 74474634BBD for ; Wed, 31 Mar 2004 01:31:18 -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 00425-22 for ; Wed, 31 Mar 2004 01:31:18 -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 1073A634BAC for ; Wed, 31 Mar 2004 01:31:17 -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; Wed, 31 Mar 2004 15:39:29 +0900 From: "Prem Khanna J" To: Cc: Subject: RE: what exactly 'tim' means in a 10046 TRACE file ? Date: Wed, 31 Mar 2004 15:41:18 +0900 Organization: Kantoh System Message-ID: <00aa01c416eb$2c1c6300$dd00a8c0@prem> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_00AB_01C41736.9C040B00" 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: 00000000B6B50ACC57CB7F41875D42212617737E84FC2800 In-Reply-To: <003601c416dd$8e94dac0$6601a8c0@CVMLAP02> Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2145 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_00AB_01C41736.9C040B00 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Thanx a lot for ur reply Mr.Cary . I have a few more questions please ! These are a few lines from my trace file for a simple query. *** SESSION ID:(10.12) 2004-03-29 18:40:55.421 PARSE #1: tim=31028556368 EXEC #1: tim=31028575483 1.The difference between PARSE and EXEC is ( 31028575483 - 31028556368 ) = 19115 . is it so many micro seconds elapsed ? 2.The timestamp in " *** " line is the nearest one. so how many seconds have the clock advanced by during the PARSE and EXEC line ? Can you explain me please ? Thanx again. Regards, Prem. ------=_NextPart_000_00AB_01C41736.9C040B00 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IhIGAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAApAMAAAAAAACnAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANQHAwAfAA8AKQAAAAMAOAEB A5AGANwHAAArAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMANgAA AAAAHgBwAAEAAAAxAAAAd2hhdCBleGFjdGx5ICd0aW0nIG1lYW5zIGluIGEgMTAwNDYgVFJBQ0Ug ZmlsZSA/AAAAAAIBcQABAAAAFgAAAAHEFusrv+RHIVTxu0mjp2u7jhcYOJ4AAAIBHQwBAAAAGAAA AFNNVFA6SlBSRU1AS1NTTkVULkNPLkpQAAsAAQ4AAAAAQAAGDgAmACHrFsQBAgEKDgEAAAAYAAAA AAAAALa1CsxXy39Bh11CISYXc37CgAAAAwAUDgAAAAALAB8OAQAAAB4AKA4BAAAAKgAAADAwMDAw MDA2AWpwcmVtQGtzc25ldC5jby5qcAFQcmVtIEtoYW5uYSBKAAAAHgApDgEAAAAqAAAAMDAwMDAw MDYBanByZW1Aa3NzbmV0LmNvLmpwAVByZW0gS2hhbm5hIEoAAAACAQkQAQAAAPcCAADzAgAAaAQA AExaRnV+TmBpAwAKAHJjcGc5MzJ5APszNgHoAqQD4wIAcERycQ5AZmNoCsBz8GV0MCAHEwKDAFAD VNUQn0MJ8HQIcHkCgxDhIxBFERUxMjgDMCc4eQ5AJzYA4BXzAcAV1ma1FeEzFeA1F6EXkzYXdKY2 FhEXkjRlAoB9CoCJCMggOwliMjU1Cbs7AoAZoioJsAnwBJBhdDUFsVIN4GgaoRGANS4ANDAuMTEu MjKSMRuxXHYIkHdrC4B0ZDQMYGMAUAsDC2BuWmceEDMXoAuzMRXAVMERIG54IGEgCQAFQLcCEAXA CHAgCXALUHkF0NhyLkMKwCIQLgrjCoCkSSARIHZlIPFmB9ETBGAJcCBxClBzdGknAiAEIAtQZWER UCAhfyLUItQgoAeQI4EkISOkbF8LgAeRA1Ij8CIQdByAY30jgGYDEChRBbEhAACQbfck8SRCFCAu EiIlhCBRGGANIuMqKzAGAEVTU0mAT04gSUQ6KB4QER2wMikgAdAwNC2hH+AtMjkgIHA6HZAeOhrQ HYAeACV6UEFS4StwICMxOgyCKAAHcFw9Mx4QFbAa0DYPIDh/CNAAQQwwJYQwsAoREYBFGFhFQy8v MDA3NTT3F5Ewvh+UNDDRAtEUkgwB/zEWAFAflwwwICYd0DFmJjFcIGQGkCPACXBuKEFitRFgdwnh IC7UAHBkMdSTBAAixSggMvkgLTtlVTBTICyAPS1AOR3ANcsioTrBaQVAc28j8ABw+nki1G0N4ANg KRAFkR7AtQQgZQtgcBFQOlA/JXrfM6QskDfbL7EkcWEpQDqweQOgIiArMkNQJzI6snSvOHEcYCaR JIAgAiBlKeDnKjYdQT4xaG8j4T5xP1dLI1NEUmMJAGNrIPBkrnYAcChAOlBiIhBkCHH/H7Ai1ERS Od1D00BmNLcUgW9Lah/zE8ADkXkIYD/QeK8LUyPwI4Ak9T8glmcLcTNFRiLjUmVP0Asgcyy7LnUJ cG0p4EvPGZEAU3AAHgBCEAEAAAAqAAAAPDAwMzYwMWM0MTZkZCQ4ZTk0ZGFjMCQ2NjAxYThjMEBD Vk1MQVAwMj4AAAADAJIQAwAAAAMA3j+fTgAAAwAJWQMAAAADAEBlAAAAAAsAE4AIIAYAAAAAAMAA AAAAAABGAAAAAAOFAAAAAAAAAwAVgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADABuACCAG AAAAAADAAAAAAAAARgAAAABShQAA45ABAB4AIoAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAA BQAAADEwLjAAAAAACwAjgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADACSACCAGAAAAAADA AAAAAAAARgAAAAABhQAAAAAAAAsALYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAwgAgg BgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAALAEiACCAGAAAAAADAAAAAAAAARgAAAACChQAAAAAA AAIB+A8BAAAAEAAAALa1CsxXy39Bh11CISYXc34CAfoPAQAAABAAAAC2tQrMV8t/QYddQiEmF3N+ AgH7DwEAAACbAAAAAAAAADihuxAF5RAaobsIACsqVsIAAG1zcHN0LmRsbAAAAAAATklUQfm/uAEA qgA32W4AAABDOlxEb2N1bWVudHMgYW5kIFNldHRpbmdzXEFkbWluaXN0cmF0b3JcTG9jYWwgU2V0 dGluZ3NcQXBwbGljYXRpb24gRGF0YVxNaWNyb3NvZnRcT3V0bG9va1xPdXRsb29rLnBzdAAAAwD+ DwUAAAADAA00/TcCAAIBFDQBAAAAEAAAAE5JVEH5v7gBAKoAN9luAAACAX8AAQAAADEAAAAwMDAw MDAwMEI2QjUwQUNDNTdDQjdGNDE4NzVENDIyMTI2MTc3MzdFODRGQzI4MDAAAAAAAwAGEGK+YSUD AAcQrAEAAAMAEBAAAAAAAwAREAEAAAAeAAgQAQAAAGUAAABUSEFOWEFMT1RGT1JVUlJFUExZTVJD QVJZSUhBVkVBRkVXTU9SRVFVRVNUSU9OU1BMRUFTRVRIRVNFQVJFQUZFV0xJTkVTRlJPTU1ZVFJB Q0VGSUxFRk9SQVNJTVBMRVFVRVJZAAAAAGrZ ------=_NextPart_000_00AB_01C41736.9C040B00-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------