Get oracle installation path : process « System Tables Views « Oracle PL / SQL






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

 








Related examples in the same category

1.Query v$process a, v$session
2.Query process for The Current Usage of the PGA Memory