Re: Get a lot of tracefiles

On 7 Dec 2001 05:11:00 -0800, clang_at_mediaprint.at (Christian Lang) wrote:

>I'm confused about a lot of trace files in the udump directory.
>they looks like as follows:
>#########################################
>/d01/oracle/admin/DWH/udump/dwh_ora_1732.trc
>Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
>With the Partitioning option
>JServer Release 8.1.7.2.0 - Production
>ORACLE_HOME = /d01/oracle/817
>System name: SunOS
>Node name: uxsun2
>Release: 5.6
>Version: Generic_105181-20
>Machine: sun4u
>Instance name: DWH
>Redo thread mounted by this instance: 1
>Oracle process number: 59
>Unix process pid: 1732, image: oracle_at_uxsun2 (TNS V1-V3)
>
>*** 2001-12-07 11:50:46.028
>*** SESSION ID:(10.4071) 2001-12-07 11:50:45.840
>4
>4
>4
>4
>4
>4
>################################################
>and thats it. There is no more Information in it.
>They are createt one by one during the whole day.
>The max_dump_file_size is set to unlimited.
>The Developers are not generating any traces.
>Do'nt know where they come from.
>any suggestion ?
>thanks a lot
>Christian Lang

If the process is still running you can easily find it. The trace include the process id in v$process and it's spid (in this case 1732) you can link back to v$session (v$session.paddr = v$process.address) to see what the client is doing.
You can also run a ps -fp <spid> to see what happens at the Unix side.

Enough suggestions for a moment I think, good luck with hunting it down.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Dec 07 2001 - 12:19:26 CST