Oracle database - Explain how to give developers access to trace files
(required as input to tkprof) posted by
Babu Kunwar
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';
More links
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)............
|
