I 'm to run a script in cron but i'm not finding the output. When i run manually, the output is right in the directory from which i execute.
select value || '_' output
from v$parameter where name = 'db_name';
what directory will this lfsdiag_&&dbname&×tamp&&suffix go when i run from cron?