| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Where are my trace files going?
Another possiblity is that file has once generated a trace file and you accidently rm that file.
As the file is still opened by this session, the session still write the trace content to that "rm"ed tracefile, so you are unable to read that file.
You can use lsof -p $SPID to identify whether the trace file is deleted or it did not get generated at all. like:
root_at_misc3 root]# lsof -p 13863
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME oracle 13863 oracle cwd DIR 8,8 4096 1651678 /home/oracle/product/8.1.7/dbs oracle 13863 oracle rtd DIR 8,2 4096 2 / oracle 13863 oracle txt REG 8,8 23872327 2403986 /home/oracle/product/8.1.7/bin/oracle oracle 13863 oracle mem REG 8,2 494474 80003 /lib/ld-2.2.4.so oracle 13863 oracle mem REG 8,8 4192428 1242955 /home/oracle/product/8.1.7/lib/libjox8.so oracle 13863 oracle mem REG 8,8 33269 1242967 /home/oracle/product/8.1.7/lib/libdsbtsh8.so oracle 13863 oracle mem REG 8,2 66037 80016 /lib/libdl-2.2.4.so oracle 13863 oracle mem REG 8,2 140140 80018 /lib/libm-2.2.4.so oracle 13863 oracle mem REG 8,2 88032 80048 /lib/libpthread-0.9.so oracle 13863 oracle mem REG 8,2 1285820 80012 /lib/libc-2.2.4.so oracle 13863 oracle mem REG 8,2 262324 80037 /lib/libnss_files-2.2.4.so oracle 13863 oracle 0u CHR 136,1 3 /dev/pts/1 oracle 13863 oracle 1u CHR 136,1 3 /dev/pts/1 oracle 13863 oracle 2u CHR 136,1 3 /dev/pts/1 oracle 13863 oracle 3r CHR 1,3 33458 /dev/null oracle 13863 oracle 4r CHR 1,3 33458 /dev/null oracle 13863 oracle 5w REG 8,8 37064 523441 /home/oracle/admin/catalog/udump/ora_13863.trc (deleted) //I did the test here. oracle 13863 oracle 6r CHR 1,3 33458 /dev/null oracle 13863 oracle 7r CHR 136,1 3 /dev/pts/1 oracle 13863 oracle 8r FIFO 0,0 193607440 pipe oracle 13863 oracle 9r REG 8,8 358912 2763598 /home/oracle/product/8.1.7/rdbms/mesg/oraus.msb oracle 13863 oracle 11w FIFO 0,0 193607441 pipe oracle 13863 oracle 409u REG 8,17 419438592 32708 /oradata/catalog/system.dbf
> 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: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).
> >
>
> 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: mladen_at_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_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).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: chao_ping_at_vip.163.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 - 23:34:25 CST
 |
 |