Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Get oracle installation path

SQL> SQL> SQL>      select c.value || '\ORA' || to_char(a.spid,'fm00000') || '.trc'   2        from v$process a, v$session b, v$parameter c   3       where a.addr = b.paddr   4         and b.audsid = userenv('sessionid')   5         and c.name = 'user_dump_dest'   6      / C.VALUE||'\ORA'||TO_CHAR(A.SPID,'FM00000')||'.TRC' ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP\ORA00604.trc