Results 1 to 2 of 2

Thread: Tkprof

  1. #1
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Tkprof

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


  2. #2
    Junior Member
    Join Date
    Nov 2006
    Answers
    1

    Oracle 10G is DBA's darling

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact