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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DEEDSD@xxxxxxxxxxxxxx Sent: Tuesday, April 27, 2004 10:59 AM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxx> T To: "oracle freelists.org" <oracle-l@xxxxxxxxxxxxx> Sent by: cc: oracle-l-bounce@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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------