Action
I have generated an Oracle .trc file in the normal manner.
I can view the trace file in Toad and a normal text editor.
Version Used
I attempt to load the trave file into SQL Developer version :
Oracle SQL Developer 4.0.0.13
Version 4.0.0.13
Build MAIN-13.80
Oracle is 11.2.0.3
Error Observed
and the following error is generated :
java.lang.NumberFormatException: For input string: "18446744069414649858"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:444)
at java.lang.Long.parseLong(Long.java:483)
at oracle.dbtools.raptor.sqltrace.parser.EventWait.<init>(EventWait.java:99)
at oracle.dbtools.raptor.sqltrace.parser.SqlCursor.addEvent(SqlCursor.java:150)
at oracle.dbtools.raptor.sqltrace.parser.TraceFile.shred(TraceFile.java:189)
at oracle.dbtools.raptor.sqltrace.SqlTraceEditorNode.getTraceFile(SqlTraceEditorNode.java:27)
at oracle.dbtools.raptor.sqltrace.SqlTraceTreeEditor.init(SqlTraceTreeEditor.java:45)
at oracle.dbtools.raptor.sqltrace.SqlTraceTreeEditor.getGUI(SqlTraceTreeEditor.java:60)
at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.attachEditor(SplitPane.java:1119)
at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.attachNewEditor(SplitPane.java:1113)
at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.doLayout(SplitPane.java:586)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.whenCurrentEditorChanges(NbEditorManager.java:1591)
at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.whenCurrentEditorChanges(TabGroup.java:1026)
at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.setCurrentTabGroupState(TabGroup.java:847)
at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.addTabGroupState(TabGroup.java:129)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:546)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:523)
at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditor(NbEditorManager.java:391)
at oracle.ide.cmd.OpenCommand.openWithNoProject(OpenCommand.java:337)
at oracle.ide.cmd.OpenCommand.access$100(OpenCommand.java:62)
at oracle.ide.cmd.OpenCommand$1.run(OpenCommand.java:266)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
Source Of Error
Using a text editor I opened up the .trc file and there is an entry (I have bolded and underlined the text) :
(it is a large file so I have only shown the rows before and after the offending number string)
EXEC #139845798097160:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1884964958,tim=1392804358387712
FETCH #139845798097160:c=0,e=7,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1884964958,tim=1392804358387732
CLOSE #139845798097160:c=0,e=6,dep=1,type=3,tim=1392804358387758
WAIT #139845798105544: nam='library cache lock' ela= 178 handle address=3933045368 lock address=7565422120 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388295
WAIT #139845798105544: nam='library cache pin' ela= 141 handle address=3933045368 pin address=7565421864 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388508
WAIT #139845798105544: nam='library cache lock' ela= 136 handle address=7068253496 lock address=7450118032 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388732
WAIT #139845798105544: nam='library cache pin' ela= 106 handle address=7068253496 pin address=7450117776 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388908
PARSE #139845798088992:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=0,tim=1392804358391715
Hope this helps