15:50:08 sys@TQGZS> SELECT FILE# ,NAME,BYTES from v$datafile where FILE#=1; FILE# NAME BYTES ---------- -------------------------------------------------- ---------- 1 /u01/oracle/oradata/tqgzs/system01.dbf 734003200
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | SELECT d.VALUE || '/' || LOWER (RTRIM (i.INSTANCE, CHR (0))) || '_ora_' || p.spid || '.trc' trace_file_name FROM (SELECT p.spid FROM v$mystat m, v$session s, v$process p WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p, (SELECT t.INSTANCE FROM v$thread t, v$parameter v WHERE v.NAME = 'thread' AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i, (SELECT VALUE FROM v$parameter WHERE NAME = 'user_dump_dest') d / |
Recent Comments