MOATS: The Mother of All Tuning Scripts!
MOATS 2.0 (RAC-aware) by Sidney Chen:
SQL Dashboard by Jagjeet Singh:
Both are RAC-aware, use terminal coloring techniques like my (fish.sql :) and some Exadata metrics.
A couple of screenshots from their tools:
I’ve taken down the original video of MOATS (I actually messed something up in Youtube and the video disappeared :-) If you’d like to see the original MOATS, you can download it from Adrian’s website site (current version 1.05) and make sure you read the README.txt file in the zip!
Also thanks to Randolf Geist for finding and fixing some bugs in our alpha code (and anyone else that have contributed!)
P.S. Have you already figured out how the top-style screen refreshing in SQLplus works?! ;-)
NB! If you want to move to the "New World" - offload your data and workloads to Hadoop, without having to re-write your existing applications - check out Gluent. We are making history! ;-)
출처 : http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 | 추천 수 |
---|---|---|---|---|---|
12 | Announcing MySQL Server 8.0.15 | 명품관 | 2019.02.07 | 658 | 0 |
11 | VirtualBox 6.0.4 released | 명품관 | 2019.01.30 | 727 | 0 |
10 | VirtualBox 6.0.2 released | 명품관 | 2019.01.18 | 1437 | 0 |
9 | Oracle Database 19c Now Available on LiveSQL! | 명품관 | 2019.01.17 | 2035 | 0 |
8 | VirtualBox Appliance로 오라클 12.2 사용하기 | 명품관 | 2017.03.03 | 1172 | 0 |
7 | Oracle Database 12c Release 2 Linux x86-64 Released [2] | 명품관 | 2017.03.02 | 1338 | 0 |
» | MOATS: The Mother of All Tuning Scripts! (by TANEL PODER) | 명품관 | 2016.04.28 | 83763 | 0 |
5 | eDB360 - Carlos Sierra's Tools(SQLTXPLAIN 개발자) | 명품관 | 2016.04.25 | 1779 | 1 |
4 | Oracle Berkeley Database (BDB) 6.2 Announced | 명품관 | 2016.04.21 | 2314 | 0 |
3 | RACSIG에서 구글 이벤트를 통해 Load-Balancing a RAC Database 타이틀로 webinar 진행합니다. | 명품관 | 2016.04.20 | 2054 | 0 |
2 | 오라클 매거진 - November/December 2015 | 명품관 | 2016.01.27 | 679 | 0 |
1 | Oracle Database certification on Microsoft Windows 10 | 명품관 | 2016.01.08 | 3239 | 0 |