View Single Post

   
  #1 (permalink)  
Old 04-20-2008, 12:25 PM
bozon
 
Posts: n/a
Default Dynamic Explain plan option in version 10

Some quick questions where does it put the file for a particular user?
Does it put the file in the home directory of the user? If the user is
a nologin user and doesn't have a home directory is there a way to
specify the directory that the server uses for the explain plan file?

If you can't currently specify the file name or location for the
explain plan I would like to request a feature

set explain on <to <filename>;

and the analogous

onmode -Y 1 <filename>

As background our database users aren't given home directories for
security reasons I am told (less you can do the less you can muck with
defense.)

Reply With Quote