Oracle神諭

            BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理 ::
            284 隨筆 :: 9 文章 :: 106 評論 :: 0 Trackbacks

          SQL Profiler Introduction

          This is a quickly hacked tool to do statistics(統(tǒng)計(jì)) on SELECT queries in order to know where it is most efficient to create indexes.  目的是最有效的創(chuàng)建索引.

          This small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files. Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect(察覺) database problems efficiently.


          This tool can be very useful when you have a big volume of queries that you need to analyze not one by one一個(gè)接一個(gè) (meaning that the specific time isn't that much of interest), but rather(若非) when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.

          The Swing GUI was based on Apache's Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.

          posted on 2005-06-28 14:57 java世界暢談 閱讀(384) 評論(1)  編輯  收藏 所屬分類: 性能分析

          評論

          # re: SQL Profiler Introduction 2006-01-15 11:38 felice
          不錯(cuò),試用了一下,確是很不錯(cuò),計(jì)劃在我的項(xiàng)目組中推廣  回復(fù)  更多評論
            


          只有注冊用戶登錄后才能發(fā)表評論。


          網(wǎng)站導(dǎo)航:
           
          主站蜘蛛池模板: 华阴市| 远安县| 泰来县| 谢通门县| 宜章县| 乌鲁木齐市| 焉耆| 芜湖县| 马公市| 托里县| 延吉市| 萍乡市| 梁河县| 稻城县| 宁明县| 东安县| 涡阳县| 大连市| 繁昌县| 嘉义市| 吴川市| 和林格尔县| 昆山市| 韩城市| 永泰县| 永胜县| 永嘉县| 绥芬河市| 凉城县| 德安县| 博白县| 家居| 克东县| 孝昌县| 松潘县| 玉屏| 昌江| 静乐县| 房山区| 普兰店市| 阿拉善右旗|