Re: 10g Trace files to ?/rdbms/log
- From: Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 10 Feb 2004 08:12:34 -0800 (PST)
Thanks, Borris.
- Kirti
--- Boris Dali <boris_dali@xxxxxxxx> wrote:
> Kirti,
>
> Seems to work ok on Solaris:
>
> SQL> select * from v$version;
>
> BANNER
> -------------------------------------------------------Oracle
> Database 10g Enterprise Edition Release 10.1.0.2.0 -
> 64bi
> PL/SQL Release 10.1.0.2.0 - Production
> CORE 10.1.0.2.0 Production
> TNS for Solaris: Version 10.1.0.2.0 - Production
> NLSRTL Version 10.1.0.2.0 - Production
>
> SQL> sho parameter user_dump
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> user_dump_dest string
> /u01/app/oracle/admin/db10g1/
>
> udump
> SQL> -- for non-sys account
> SQL> select spid from v$process where addr = (select
> paddr from v$session where
> audsid=sys_context('userenv','sessionid'));
>
> SPID
> ------------
> 2306
>
> SQL> alter session set sql_trace=true;
>
> Session altered.
>
> SQL> select * from dual;
>
> D
> -
> X
>
> SQL> !ls -lat /u01/app/oracle/admin/db10g1/udump/ |
> grep 2306
>
> -rw-r----- 1 ora10g1 dba 1392 Feb 10 09:21
> db10g1_ora_2306.trc
>
>
> Thanks,
> Boris.
>
> --- Kirtikumar Deshpande
> <kirtikumar_deshpande@xxxxxxxxx> wrote: > I filed an
> iTAR after all...
> >
> > This is a bug # 3372651 on HP-UX platform, I was
> > told by OWS. No patch or workaround in sight. The
> > bug is not visible on the Metalink, but my TAR# is
> > tied to the bug (per OWS). I will post an
> > update when this gets resolved.
> >
> > I do not have Linux yet, or Solaris, so I can not
> > confirm that the bug only affected HP-UX.
> > Would appreciate it if someone can test it and
> > report the result.
> > Thanks.
> >
> > Cheers!
> >
> > - Kirti
> >
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
