Using profile option ‘Initialization SQL Statement -Custom’

Posted by Jiltin     Tags: , , , , 17 February, 2009    2,893 views    (1) Comment

How to set ‘Initialization SQL Statement – Custom’ (FND_INIT_SQL) profile option? This is used to get trace files for the concurrent Programs you run through oracle applications. User mainly by technical persons who are trying to solve an issue where manipulating some database session level parameter can help to gather more information. Using the profile option ‘Initialization SQL Statement – Custom’, you can add site-specific initialization code, such as Read Full Article (Click here)...

Categories : Oracle AOL Tags : , , , ,

Handy tkprof sql creating script using bash shell unix, linux with oracle environment

Posted by Jiltin     Tags: , , , , 10 December, 2008    8,327 views    (0) Comment

Oracle gives you this program called TKProf that reads your trace file and spits out somewhat meaningful output. My favorite option to tkprof is sort=prsela,fchela,exeela. This sorts the statements from longest running to shortest running. I prefer this format because I can concentrate on the top two or three statements for the most impact. By tracing, I mean capturing all the SQL in a user’s session, or a SQL trace. As you can tell from the Oracle Performance Tuning Guide and Read Full Article (Click here)...

Categories : 11i DBA Scripts, 11i Scripts, Scripts Oracle, Scripts Unix Tags : , , , ,