RE: Tracing exp

From: <J.Velikanovs_at_alise.lv>
Date: Wed, 28 Jul 2004 08:59:21 +0300
Message-ID: <OF0DD772E4.1B7E9333-ONC2256EDF.00203D6C-C2256EDF.0021A336@alise.lv>

If v$session.program doesn't work for you. You can try to use v$session.MACHINE.
Or you can use any combination of conditions. CREATE OR REPLACE TRIGGER sys.logon_vjv
 AFTER
  LOGON
 ON DATABASE
DECLARE
  v_user varchar2(30);
  v_row v$session%rowtype;
BEGIN
  BEGIN
   SELECT user INTO v_user

       FROM dual;
   IF v_user = 'ZAP2' THEN

     select * into v_row
       from v$session where AUDSID=SYS_CONTEXT ('USERENV', 'SESSIONID');
     if v_row.MACHINE = 'host.domain' 
        and v_row.PROGRAM = 'exp.exe'
     then 
        dbms_support.start_trace(true,true); 
     end if;

   END IF;
  EXCEPTION
 WHEN OTHERS THEN NULL;
  END;
END;
/

Jurijs
9268222

---

http://otn.oracle.com/ocm/jvelikanovs.html

"David Kurtz" <info_at_go-faster.co.uk>
Sent by: oracle-l-bounce_at_freelists.org
28.07.2004 02:17
Please respond to oracle-l  

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        RE: Tracing exp

I've done this application session, but not with export. It also depends on
the operating system.
v$session.program is not populated on all flavours of Unix when the connection is made via a listener.

regards

---

David Kurtz
Go-Faster Consultancy Ltd.

tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk

mailto:david.kurtz_at_go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daniel Fink
> Sent: 27 July 2004 22:05
> To: oracle-l_at_freelists.org
> Subject: Re: Tracing exp
>
>
> Untested, unproven, just popped into the head of a known-deranged
> Scotch hound...
>
> How about a logon trigger that checks v$session.program and sets
> the trace if the program is 'exp'?
>
> Regards,
> Daniel Fink
>
> Schauss, Peter wrote:
> > We have a third party application which does some replication by doing
> > a series of exports (Oracle exp) from the source database and using
> > the generated files to import into the target database. Since
> the performance
> > of this process is becoming a concern, I would like to put a
> 10046 trace on one
> > of these exports to see if there is anything that we can do to make
the
> > underlying SQL more efficient.
> >
> > Is there a parameter in the exp command which I could use to
> trigger a 10046
> > trace?
> >
> > The userid under which these exp's run is used for other
> purposes, so I would
> > prefer not to use a login trigger for this purpose.
> >
> > Thanks,
> > Peter Schauss
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 28 2004 - 01:04:15 CDT