Oracle PL/SQL Tutorial/System Tables Data Dictionary/process

Join v$process, v$session and v$parameter

   <source lang="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 rownum < 50
 5     and b.audsid = sys_context("userenv","sessionid")
 6     and c.name = "user_dump_dest"
 7  /

C.VALUE||"\ORA"||TO_CHAR(A.SPID,"FM00000")||".TRC"

---

C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP\ORA01476.trc

Statistics

---

        23  recursive calls
         0  db block gets
         6  consistent gets
         1  physical reads
         0  redo size
       501  bytes sent via SQL*Net to client
       380  bytes received via SQL*Net from client
         2  SQL*Net roundtrips to/from client
         1  sorts (memory)
         0  sorts (disk)
         1  rows processed

SQL> SQL></source>