Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does one give developers access 2 trace files (required as input 2 tkprof)?

April 26, 2017developers files input tkprof trace

0

Posted

How does one give developers access 2 trace files (required as input 2 tkprof)?

1 Answer

0

Posted

D “alter session set sql_trace=true” command generates trace files in USER_DUMP_DEST that can be used by developers as input 2 tkprof. On Unix D default file mask for D se files are “rwx r– —“. D re is an undocumented INIT.ORA parameter that will allow everyone 2 read (rwx r– r–) D se trace files: _trace_files_public = true Include this in ur INIT.ORA file and bounce ur database for it 2 take effect.