v$instance.instance_name : V_instance « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. V_instance

v$instance.instance_name

   

SQL>
SQL>
SQL>  select c.value || '/' || d.instance_name ||
  2                     '_ora_' || a.spid || '.trc' trace
  3    from v$process a, v$session b, v$parameter c, v$instance d
  4   where a.addr = b.paddr
  5     and b.audsid = userenv('sessionid')
  6     and c.name = 'user_dump_dest'
  7  /

TRACE
--------------------------------------------------------------------------------
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP/xe_ora_264.trc

SQL>
SQL>
SQL>

   
    
    
  

Related examples in the same category