Tkprof

TKPROF stands for Transient Kernel Profiler.

Some Useful Scripts

Below are a few useful scripts from $FND_TOP that are available on all the instances.

afamicxpar.sql – ICX Configuration
afamsact.sql – Summary SQL Activity
afcmcreq.sql – Prints the Log file names of the managers that can run a given request
afcmrrq.sql – For use by DBA’s for quick look of all running requests
afcmstat.sql – Displays all defined Managers and shows current status of manager processes.
afcrmchk.sql – Displays Concflict Resolution Managers status and last cycle information …
afimchk.sql – Checks to see if the Concurrent Manager monitor is actually running
afimlock.sql – Script to detect if the Internal Concurrent Manager is in a gridlock situation with another oracle process.
afqpmlck.sql – Lists all sessions that are waiting for a lock
afrqscm.sql – Prints the Log file names of the managers that can run a given request
afsvcpup.sql – Script to update GSC Component Parameters in case the UI is not available for some reason.
afrqstat.sql – Summary of concurrent request execution since Date

Cheers!