Thread: Tkprof

How to set Tkprof utility in oracle 10g .....?

Oracle 10g is dba's darling. It does many activities automatically and produces report. For example, statistics for database objects can be scheduled for 7pm every day; statistics will be collected automatically. Advisor central window gives you option of viewing: 1) the automatic database diagnostic monitor (addm) 2) the sql tuning advisor 3) the sql access advisor 4) the memory advisor 5) the mean time to recover advisor 6) the segment advisor 7) the undo advisor addm report will highlight problems within the database and suggest solutions. It will also advice you to run advisor 2,3,4,5,6,7 if necessary. Database control enterprise manager will provide you performance related information and also enable you to do dba's work through the user friendly interface. Database control enterprise manager 'performance tab' has a link top consumers which provides detailed information on resources consumed by sessions responsible for most of the physical and logical i/o's. information includes logical reads, hard parses, total parses, disk sorts, status, cpu, pga memory, db user, sid etc. you have the option to kill session using the interface provided by database control enterprise manager. Regards krishan ocp dba