RE: time in trace file

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 27 Apr 2004 20:49:36 -0500
Message-ID: <005a01c42cc3$13786a40$3a00a8c0@CVMLAP02>

Be warned, though. It's only going to work on a couple of ports. Not all of them. For whatever reason, different ports of Oracle use different bases for their tim values.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22 Pittsburgh

- SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DEEDSD_at_Nationwide.com
Sent: Tuesday, April 27, 2004 10:59 AM
To: oracle-l_at_freelists.org
Subject: Re: time in trace file

There's a Perl script in Cary's book that converts from tim to real date/time and back. It's example 6-10 on page 134.

                          "Sultan Syed"

                          <ssyed_at_fine.ae>          T

                                                   To:   "oracle
freelists.org" <oracle-l_at_freelists.org>                         
                          Sent by:                 cc:

                          oracle-l-bounce_at_freelis

                          ts.org                   bcc:

                                                   Subject:
time in trace file          
 

 

                          04/27/2004 02:48 AM

                          Please respond to

                          oracle-l

Hi guys,
How can I interpret with this time format,I know this is the time of parse call is over,but how can I convert this into date format.Is it possible?
PARSE #30:c=2,e=15,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=933354557 Thanks in advance
Syed

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Apr 27 2004 - 20:47:06 CDT