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





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

1.select Active_State from V$INSTANCE
2.select Database_Status from V$INSTANCE
3.V$INSTANCE view provides one row of statistics for each Oracle instance running against the database