RE: trace files written to ORACLE

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Wed, 4 Feb 2004 10:16:12 -0800 (PST)
Message-ID: <20040204181612.53987.qmail@web9504.mail.yahoo.com>

I think it is a new feature in 10g R1 ;)

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 3 17:04:44 2004

SQL> show parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u888/oradata/DA9T/bdump
core_dump_dest                       string      /u888/oradata/DA9T/cdump
max_dump_file_size                   string      10485760
shadow_core_dump                     string      partial
user_dump_dest                       string      /u888/oradata/DA9T/udump

SQL> oradebug setospid 1779
Oracle pid: 7, Unix process pid: 1779, image: oracle_at_df2hp017 (SMON)

SQL> oradebug event 10046 trace name context forever, level 12 Statement processed.

SQL> oradebug tracefile_name
/u01/home/oracle/product/10.1.0/rdbms/log/da9t_ora_1779.trc

SQL> !ls -ld /u888/oradata/DA9T/*dump  
drwxrwxr--   2 oracle     dba          29696 Jan 31 15:44 /u888/oradata/DA9T/bdump
drwxrwxr--   2 oracle     dba             96 Feb  2 12:44 /u888/oradata/DA9T/cdump
drwxrwxr--   2 oracle     dba           1024 Feb  1 07:13 /u888/oradata/DA9T/udump

No links for *dump directories. Ownerships, permissions ok.

I have failed to find anything wrong with my setup. Worked fine when DA9T was a 9i database using exactly the same file systems/directories etc.

Not a big issue to me, yet, to log an iTAR.

Kirti
- Cary Millsap <cary.millsap_at_hotsos.com> wrote:

> Check Metalink too. I vaguely recall a student mentioning that this
> behavior occurred as the result of a bug.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> * Nullius in verba *
>
> Upcoming events:
> - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
> - SQL Optimization 101: 2/16 Dallas
> - Hotsos Symposium 2004: March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
>
>
>
> -----------------------------------------------------------------

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 04 2004 - 12:16:12 CST

RE: trace files written to ORACLE_HOME/rdbms/log