Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h7DD5lp01514 for ; Wed, 13 Aug 2003 08:05:47 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h7DD5hp01506 for ; Wed, 13 Aug 2003 08:05:43 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h7DAeWF21277 for oracle-l@orafaq.net; Wed, 13 Aug 2003 03:40:32 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005CA783; Wed, 13 Aug 2003 03:34:23 -0800 Message-ID: Date: Wed, 13 Aug 2003 03:34:23 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Mladen Gogala Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Mladen Gogala Subject: Re: How to take sql*loader trace/ AFTER LOGON SCHEMA TRIGGER Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Try with "ADMINISTER DATABASE TRIGGER" On 2003.08.13 04:29, Jack van Zanen wrote: > > > Yes I tried granting alter session first > > > > -----Original Message----- > Sent: Tuesday, August 12, 2003 11:24 PM > To: Multiple recipients of list ORACLE-L > > > Does the user whom you created the trigger have "alter session" privilege? > > Tanel. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > Sent: Tuesday, August 12, 2003 4:39 PM > > > > As system (8.1.7.3): > > > > create or replace trigger > > after logon on .schema > > begin > > Execute immediate 'alter session set events=''10046 trace name > > context forever, level 12'''; end; > > > > > > When I logon after creating this trigger as the user I get > > the error message insufficient privileges. If I grant DBA it seems to > > work but that is a bit much for privileges. > > > > Which privileges are neccesary to run this?? > > > > Just alter session won't work. > > > > > > Jack > > > > > > -----Original Message----- > > Sent: Monday, August 11, 2003 4:59 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Create or replace database trigger turn_tracing_on after logon on > > schema.scott Begin Execute immediate 'alter session set events=''10046 > trace > > name context forever, level 8'''; End; / > > > > That should give you more then enough info to trace, especially on 9i. > > > > -- > > Mladen Gogala > > Oracle DBA > > > > > > > > -----Original Message----- > > Senthil Kumar > > Sent: Monday, August 11, 2003 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi All, > > > > I'm loading a set of data into one of my schema. And wanted to take > > the trace files also. > > > > I tried the follwoing. > > > > 1. Identified the sid,serila# for the sql*loader session. > > 2. used the follwoing, > > exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); > > > > but this is not generation any trace files. But if I trun my system to > > sql_trace=TRUE, I'm able to collect the trace details. I don't want to > > do this. > > > > I want to take the trace only for the sql*loader session. How do i do > that. > > > > TIA, > > Senthil. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Senthil Kumar > > INET: senthilkumard@summitworks.com > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may also send > > the HELP command for other information (like subscribing). > > > > > > -------------------------------------------------------- > > Note: > > This message is for the named person's use only. It may contain > > confidential, proprietary or legally privileged information. No > > confidentiality or privilege is waived or lost by any mistransmission. > > If you receive this message in error, please immediately delete it and > > all copies of it from your system, destroy any hard copies > > of it and notify the sender. You must not, directly or > > indirectly, use, disclose, distribute, print, or copy > > any part of this message if you are not the intended > > recipient. Wang Trading LLC and any of its subsidiaries > > each reserve the right to monitor all e-mail > > communications through its networks. > > > > Any views expressed in this message are those of the individual > > sender, except where the message states otherwise and the sender is > > authorized to state them to be the views of any such entity. > > --------------------------------------------------------- > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > INET: mladen@wangtrading.com > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may also send > > the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jack van Zanen > > INET: JACK@QUANTSYSTEMS.NL > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may also send > > the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: tanel.poder.003@mail.ee > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jack van Zanen > INET: JACK@QUANTSYSTEMS.NL > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: mgogala@adelphia.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).