oracle trace file
Solutions on MaxInterview for oracle trace file by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle trace file"
Giulio
14 Jul 2017
1SELECT s.SID,
2 s.SERIAL#,
3 pa.VALUE || '/' || lower(sys_context('userenv', 'instance_name')) ||
4 '_ora_' || p.SPID || '.trc' AS TRACE_FILE
5FROM V$SESSION s, V$PROCESS p, V$paRAMETER pa
6WHERE pa.NAME = 'user_dump_dest'
7 AND s.paDDR = p.ADDR
8 AND s.AUDSID = sys_context('USERENV', 'SESSIONID');similar questions
oracle control file sizeoracle savepointoracle savepoint rollbackoracle connect by leveloracle export view ddloracle drop joboracle list data filesoracle job historyoracle export trigger ddloracle dependencies tableoracle selectmake table fit in oracle sqloracle list datafiles in tablespacejob oracle exempleoracles pipesoracle create datafileoracle control fileoracle add datafile to tablespaceoracle gather table statisticsoracle index hintoracle hint dblink your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful