Location of the Output File

If you execute the SET DEBUG FILE statement with a simple filename on a local database, the output file is located in your current directory. If your current database is on a remote database server, the output file is located in your home directory on the remote database server. If you provide a full pathname for the debug file, the file is placed in the directory that you specify on the remote database server. If you do not have write permissions in the directory, you receive an error.

SET DEBUG FILE TO 'debug' || '.out';