Where are my trace files going?

From: Thomas A. La Porte <tlaporte_at_anim.dreamworks.com>
Date: Mon, 01 Dec 2003 14:04:25 -0800
Message-ID: <F001.005D8587.20031201140425@fatcity.com>

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.

Thomas A. La Porte, DreamWorks SKG
<mailto:tlaporte_at_anim.dreamworks.com>

--

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

Author: Thomas A. La Porte
INET: tlaporte_at_anim.dreamworks.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_at_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). Received on Mon Dec 01 2003 - 16:04:25 CST