There are two possibilities: 1) You are hitting a well known bug which doesn't allow you to turn on 10046 by using set_ev or alter session. The only way to actually do it is to use oradebug. 2) Your trace files are with Saddam Hussein.
On 12/01/2003 05:04:25 PM, Thomas A. La Porte wrote: > Environment: Oracle 8.1.7.4 on RedHat AS2.1 > > > I'm in the process of preparing to convert a 90M row table from > heap-organized to index organized. I think I've pretty well got a > formula for doing the actual table conversion. It's a very basic > table, four NUMBER columns, with a PK on the first two. I'm > planning to extract the data to a sorted, comma-delimited flat > file, then using SQL Loader with direct path to do the import. > On a 2.8GHz 2-way Linux box, that process is taking me about 30 > minutes. > > Building two additional indexes on that table after the data has > been loaded is taking anywhere from 30 minutes up to three hours. > I'm trying to determine why there is a wide variation in the > performance of the index build operation by tracing the session, > however, I can't seem to generate a trace file! I can run the > 'alter session' to get a 100046 trace, but no file is created in > my user_dump_dest (nor, for that matter, is it being created in > my background_dump_dest, core_dump_dest, or any place else on the > local machine as best as I can tell). > > I've run these traces before in other instances on the same > machine, and I don't believe that there is a file ownership or > permissions problem anywhere in the mix. Does anyone have any > thoughts on where my trace file is going, if it is going > anywhere? Or how to determine why I'm not generating a trace > file? > > Any thoughts or pointers are greatly appreciated. > > -- Tom > > Thomas A. La Porte, DreamWorks SKG > <mailto:[EMAIL PROTECTED]> > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thomas A. La Porte > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
