SQL Performance (MOSC)

MOSC Banner

Understanding time stamp in a raw trace file like tim=1368641422961630 and how to interpret tiime di

edited Jun 4, 2013 4:58PM in SQL Performance (MOSC) 3 commentsAnswered
Hi,
I am looking at trace file

starts with
PARSING IN CURSOR #140672103923496 len=90 dep=1 uid=63 oct=3 lid=63 tim=1368641422961638 hv=3358918054 ad='2cfc4c068' sqlid='a24va0m43a1d6'

then near end I see
PARSING IN CURSOR #140672086735696 len=83 dep=2 uid=63 oct=3 lid=63 tim=1368641427032630 hv=4225919871 ad='2cda81a10' sqlid='cvyqpj3xy4uvz'

So I want to know
 1368641427032630  - 1368641422961638 = 4072300

How long is this?
How to interpret 1368641427032630 as a date/time stamp?

Regards, Dave

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center