OraFAQ Forum: Server Administration » Unable to see Trace file ?

Home » RDBMS Server » Server Administration » Unable to see Trace file ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to see Trace file ? [message #123119]

Thu, 09 June 2005 22:09

confident
Messages: 28
Registered: March 2005

Junior Member

well, recently i installed the oracle 9.2.0.6 in hpux IA64.. well i used this command to generate the trace file;

alter session set sql_trace=true;
select *****;
alter session set sql_trace=false;

i check in udump directory, there is no trace generated?
and parameter are timed_statistics=true and utl_file_dir=*
and whats problem?

Report message to a moderator

Re: Unable to see Trace file ? [message #123137 is a reply to message #123119]

Fri, 10 June 2005 01:31

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Check if the database USER_DUMP_DIR parameter points to the udump directory you use.

PS: For security reasons, I suggest you somehow get rid of utl_file_dir=* setting.

Best regards.

Frank

Report message to a moderator

Re: Unable to see Trace file ? [message #123154 is a reply to message #123119]

Fri, 10 June 2005 03:47

confident
Messages: 28
Registered: March 2005

Junior Member

SQL> select name,value from v$parameter where name='user_dump_dest';

/APSS_ors/app/oracle/admin/STS31/udump

and permission

drwxr-xr-x 2 oracle dba 1024 Jun 9 18:41 udump

unable to create

Report message to a moderator

Re: Unable to see Trace file ? [message #123611 is a reply to message #123119]

Tue, 14 June 2005 02:46

lixinyu
Messages: 3
Registered: June 2005

Junior Member

it is strange!

I met such issue before (under hpux):
1, the session has been traced .
2, close the trace.
3, delete the trace file in udump dir.
4, open the trace again.

there will not be new trace anymore.

can you quit this session and login to have a test again?

xinyu

Report message to a moderator

Previous Topic:	Database creation script
Next Topic:	can't logged as sysdba, why?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:17:42 CDT 2024