-
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?
-
Your parameter should be like
user_dump_dest = C:\Oracle\admin\BIBLE\udump
you have set the last parameter as dump.
Hemant
-
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 ???
-
"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
-
I am sure udump directory exist
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]
-
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
-
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
vicky
-
I checked all
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.
-
I hate to state the obvious but did you issue
"ALTER SESSION SET SQL_TRACE = TRUE"
MH
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|