Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Oracle to tell me why it's unhappy
Sybrand Bakker wrote:
> "Antti Järvinen" <costello_at_iki.fi> wrote in message
> news:m31yq0gdth.fsf_at_cs72168.pp.htv.fi...
> > stanb_at_panix.com (Stan Brown) writes:
> > > So (finally) here's the question. How can I configure Oracle to give me
> > > the gory details f what the appliaction is requestiong Oracle to do,
> > > preferably just when it fails, as the application ogs _a lot_ of data
to
> > > Oracle.
> >
> > Several people have suggested turning trace on in the db instance or
session
> > which can be done no prob. Another way of doing this is to turn trace
> > on on sql*net, but of course only if your app connects via sql*net. So
> > in the $ORACLE_HOME/app/oracle/product/version/network/admin/sqlnet.ora
> > of your client machine say something like
> > LOG_DIRECTORY_CLIENT=/specify/here/a/directory
> > TRACE_DIRECTORY_CLIENT=/specify/here/a/directory
> > TRACE_LEVEL_CLIENT=SUPPORT
> > or maybe
> > TRACE_LEVEL_CLIENT=19
> > (or 9, or other random number that is documented nowhere?)
> > then run your app and in the sqlnet.log and sqlnet.trc files that
> > appear in the specified directory you should find also your
> > sql statements. Bad thing here is that it may be difficult to
> > try finding values of possible bind variables, that here are
> > of somewhat interest..
> >
> > --
> > Antti Järvinen, costello_at_iki.fi
> > "concerto for two faggots and orchestra"
>
>
Of course-it had to be either 16 or 9, as any good mystic could tell you. Is there documentation for 16? Received on Tue May 08 2001 - 14:26:35 CDT