http://blog.csdn.net/pan_tian/article/details/7677338

The statements that need to be adjusted conform to the following points :

(1).CPU Take up too much

(2).Parse,Execute,Fetch Spend too much time

(3).DISK Too many reads ,query/current(SGA) Too few read blocks in

(4). Access many blocks , Only return 2 That's ok

tkprof More articles about

  1. tkprof Tool details 2 ( Some examples )

    TKPROF It's an executable , Bring it with you Oracle Server In software , No additional installation is required . The tool file can be used to parse ORACLE Of SQL TRACE(10046) To produce more readable content .  actually tkpro ...

  2. Tkprof Tool detailed explanation 1

      Indicate the : Some articles are reprinted from other people's blogs , Convenient for future reference : Generated in database oracle trace In file , Readability is poor , At this point you can use tkprof Tools to format trace file ,tkprof It's a command ...

  3. Oracle There was a tkprof Formatting oracle Of trace file

    1.MySQL The composition of the log file system 2. Slow query log 3. Slow query log Demo long_query_time : Set the threshold of slow query , Beyond the set value of SQL That is, it is recorded in the slow query log , The default value is 10sslow_query_lo ...

  4. SQL_TRACE And tkprof analysis

    One . SQL_TRACE When SQL Statement performance problems , We can use SQL_TRACE To keep track of SQL Implementation of , By tracking , We can learn about one SQL perhaps PL/SQL How the package works ,SQL_TRACE Command will SQL ...

  5. [terry note ]Oracle Conversation tracking ( Two ):TKPROF

    Take a note [terry note ]Oracle Conversation tracking ( One ):SQL_TRACE&EVENT 10046 http://www.cnblogs.com/kkterry/p/3279282.html ...

  6. tkprof explain

    Use  tkprof  Tools tkprof orcl_ora_3048_ Anqing Huaining .trc  Anhui Anqing Huaining .txt sys=no  aggregate=yes sys=no waits=yes sort=fc ...

  7. SQL Performance optimization tools TKPROF

     Full name Trace Kernel Profile, Used to format trace files , Is a command line tool . The main formats are as follows : tkprof tracefile outputfile - tracefile: To points ...

  8. oracle tkprof Tool details

    oracle  tkprof Tool details It's today 2013-09-26, Conduct tkprof Tool use learning , Take notes here : One ) View the session information that needs to be tracked : select s.sid,s.serial#,s.us ...

  9. Oracle Performance analysis 3:TKPROF brief introduction

    tkprof It is Oracle It comes with a command in line tool , Its main function is to trace the original file to the type of text file , for example , The easiest way , Use the following : tkprof ly_ora_128636.trc ly_ora_1 ...

  10. Oracle 11g R2 performance optimization tkprof

    Another blog post concludes on SQL TRACE How the tool is used , But the resulting trace File formats are not very friendly to read , For better analysis trace file ,Oracle It also comes with a formatting tool tkprof.tkprof Tools ...

Random recommendation

  1. IOS Exception logging and display function

    In the ordinary APP In the process of development, we often encounter the problem of abnormal flashback , The detailed error information can be recorded through the log , This example needs to record, no matter which page is wrong, it needs to record , The logging plug-in used here CocoaLumberjack, With ...

  2. Log4j Use the tutorial log4:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).

    1.Logger class adopt Logger Class static methods Logger.getRootLogger obtain RootLogger. All others loggers It's through static methods Logger.getLogger To instantiate and get ...

  3. A big event was planned today : Relearning JS

    Recently, I saw an article on Ruan Dashen's blog , It's about how to teach yourself computer technology , Original text Teach Yourself Computer Science. After reading it, I know where my flaws are , My biggest problem is that the foundation is not strong enough . ...

  4. 18-09-16 How to go from pychram Third party package import designer

    1 stay pychrm The operation 2 find pycharm Find the corresponding package in 3 Find the folder in the designer Then copy it

  5. Zend Studio Practical shortcut keys

    Editing function Composite key Realization function Applicable conditions Ctrl+/ Single-line comments . At present, it is php Code , Add a double slash line comment on the line where the cursor is located , If you select multiple lines, double slashes will be added to each line : And when the code is html Add before and after the line <!-- --& ...

  6. URL Included

    http://www.cnblogs.com/Olive116/p/3426957.html  Map control http://www.cnblogs.com/tugenhua0707/  front end

  7. pycharm Use github

    pycharm Use github Bind account File-settings Enter in the search box git There will be github, And then type you github Username and password , You can click on the ”test” Test it , If appear : Co ...

  8. Windows Next how to solve git&#160;bash Default home Directory path problem

    from :http://blog.csdn.net/lucien_zhou/article/details/62069246 To solve this problem , I've been looking online for a long time , I've tried, according to other people on the Internet , modify git install ...

  9. HDU - 5015 233 Matrix( Yang hui triangle / Prefix + Matrix fast power )

    233 Matrix In our daily life we often use 233 to express our feelings. Actually, we may say 2333, 23 ...

  10. ( One )mybatis And JDBC Introduce

    Preface : Why are you learning mybatis Before you know JDBC Well ? because mybatis In order to ORM The model is the framework of the central idea , And all ORM The models are all based on JDBC Encapsulated , Different ORM Model for JDBC The strength of the package is different . ...