Re: Newbie question - Oracle Trace Results

On Apr 9, 12:53 pm, tony_auds..._at_hotmail.com wrote:

snip

> I would have expected to see the EXEC and FETCH lines as well. At the
> point the application reaches the abort stage, it has already
> processed a number of SQL statement successfully and also, if i move
> the SQL statements to be executed around in the application, it will
> run fine until it reaches a statement that is, by comparison, large.
>
> I am presuming that due to the lack of EXEC and or FETCH lines, that
> the SQL has not been executed on the server.
> If this is the case, is there anything that would cause this to
> happen?

There's some low level tracing in the sqlnet communcations area that you can look at enabling.

>
> Unfortunately, the application we are running will not run with Oracle
> 9 client or above. Already been down that route!!
> Just for information, Oracle 8 client, Oracle 8.1.7.4 server, Windows
> 2000 SP4 and MDAC 2.7
>
> The application connects through a ODBC DSN, using the Microsoft ODBC
> driver (using the Oracle driver makes matters worse) and i've tried
> the Trace option in Windows DataSources, but this gives me even less
> information.
>
> Looking at the Oracle trace file, it is making me wonder whether there
> is something specific on the server that is causing the issue!!
>
> This is making my hair grey, and my Kids are already buying 'Just for
> Men' in bulk!!
>
> Regards

A couple of questions ... are you seeing errors in the alert log perhaps on the server when this is occurring? Is there a more experienced dba in your environment that can be of assistance perhaps?

FYI I tend to pass almost all trace files thru orasrp ( a resource profiler ) which when you execute it with a " --sort=crsid " will sort in the order that statements actually are in a trace file ... may not be terribly relevant to what you are doing now though.

I would expect to see a PARSE in cursor followed up by an EXEC and perhaps an ERROR in the situation that you are describing but well it's been a long time since I looked at a raw 8x trace file. Received on Wed Apr 09 2008 - 15:42:45 CDT