How to give developers access to trace files

          

How to give developers access to trace files


Oracle database - Explain how to give developers access to trace files (required as input to tkprof) posted by Babu Kunwar
<<Previous   Next>>

Explain how to give developers access to trace files (required as input to tkprof)

The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On UNIX the default file mask for these files are "rwx r-- ---".

There is an undocumented INIT.ORA parameter that will allow everyone to read (rwx r-r--) these trace files: _trace_files_public = true Include this in your INIT.ORA file and bounce your database for it to take effect.


Explain how to get the view definition of fixed views/tables

Select * from v$fixed_view_definition WHERE view_name='V$SESSION';



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
More links
SQL single-row character

CONCAT(string1, string2), INITCAP(string), LENGTH(string), LPAD(string, #,padding_char), RPAD(string, #,padding_char), LTRIM(string,searchString), RTRIM(string,searchString), REPLACE(string,searchString,replacement), SUBSTR(string,start,length), UPPER(string), LOWER(string)............

Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring