SOS!!! why I can't found any trace files in udump directory

[oramiller]

I have already set below init parameters
timed_statistics=true
user_dump_dest=/oracle/app/oracle/admin/SID/dump
sql_trace=true

then I restart DB

but when i execute sql statement in sqlplus(i have set sql_trace=true in sesession level). then i go to udump directory . Not any files was created.

Why?

[hemanr]

Your parameter should be like


user_dump_dest = C:\Oracle\admin\BIBLE\udump


you have set the last parameter as dump.

[pipo]

well you set the directory you want, it doesn't have to be udump ...
nevertheless I do not see why you have your problem ... are you sure that the directory exists ???

[tomate]

"but when i execute sql statement in sqlplus(i have set sql_trace=true in sesession level). then i go to udump directory . Not any files was created."

Do you have make only the set sql_trace=true. I think make a select Statment and then there should be a trace.file.
If not, then i cant see another problem.

Importent is that the directory is writen write

[oramiller]

the udump directory exist absolutely


I think I have completed all setting about sql trace. but oracle didn't generate any trace file . I feel despair.

[Edited by oramiller on 07-11-2001 at 04:25 AM]

[pipo]

and what are the rights on the directories under the dump one ??? can user oracle create a file in the dump directory ???
try doing : touch testfile

[vicky]

Hi,

Try this ...

$svrmgrl
SVRMGR>connect internal
SVRMGR>show parameter user_dump_dest

check the output whether it's correct one or not, if it's correct then check the permision of directory, and Owner & Group should be ORACLE_USER & DBA


Vicky

[oramiller]

I checkd all
user_dump_dest = /oracle/app/oracle/admin/hyx/udump

the /oracle/app/oracle/admin/hyx/udump exist ,
its owner is oracle and group is dba ,permission is 755.

[Mr.Hanky]

I hate to state the obvious but did you issue
"ALTER SESSION SET SQL_TRACE = TRUE"
MH

[Mr.Hanky]

My bad, sorry.
MH