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_at_yahoo.com> 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_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
>
Post your free ad now!
http://personals.yahoo.ca
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 Tue Feb 10 2004 - 08:38:03 CST