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: How to trace sql comes from middleware in production environment?

Re: How to trace sql comes from middleware in production environment?

From: wangbin <wangbin_at_start.com.au>
Date: 30 Apr 2002 04:09:28 -0700
Message-ID: <2d15bd69.0204300309.16530cac@posting.google.com>


"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ucs9l0gtg8c91b_at_corp.supernews.com>...
>
> assuming 8i or higher you can create an after logon trigger on the affected
> schema to put the session in trace mode automatically for you.
>
> Hth

Although those corba servers have different process names, they share the same user in oracle.

Cheers,
Bin Received on Tue Apr 30 2002 - 06:09:28 CDT

Original text of this message

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