Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Problem

Re: Performance Problem

From: <stevedhoward_at_gmail.com>
Date: 22 Apr 2006 06:54:21 -0700
Message-ID: <1145714061.012364.174490@i39g2000cwa.googlegroups.com>


Hi Jatinder,

You should have a trace file under udump, which you can find by the following...

show parameter user_dump_dest

Since the session has been terminated, you will probably have to grep/find the directory for a string in the statement with which you are having the problem. When you find the trace file, even without tkprof, my guess is it will jump right out at you what the issue is.

Regards,

Steve Received on Sat Apr 22 2006 - 08:54:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US