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 | 6월에 Oracle Help Center에 등록된 튜토리얼 | 명품관 | 2023.07.18 | 415 | 0 |
11 | 2023년 7월 오라클 CPU 패치 업데이트 | 명품관 | 2023.07.19 | 444 | 0 |
10 | Exadata System Software 23.1.4.0.0 Update | 명품관 | 2023.07.19 | 372 | 0 |
9 | Exadata System Software Updates 소식(2023. 08) | 명품관 | 2023.08.28 | 476 | 0 |
8 | Oracle Critical Patch Update Advisory - January 2024 | 명품관 | 2024.01.17 | 396 | 0 |
7 | MySQL 8.3 버전(Innovation 포함) 몇가지가 릴리즈 배포 | 명품관 | 2024.01.17 | 754 | 0 |
6 | Oracle Enterprise Manager 13c Release 5 Update 19 (13.5.0.19) 배포 | 명품관 | 2024.01.22 | 479 | 0 |
5 | Exadata System Software Updates - January 2024 | 명품관 | 2024.01.29 | 542 | 0 |
4 | Oracle Enterprise Manager 13c Release 5 Update 20 (13.5.0.20) 가 릴리즈 | 명품관 | 2024.02.26 | 717 | 0 |
3 | Exadata System Software Updates - March 2024 | 명품관 | 2024.04.08 | 374 | 0 |
2 | Oracle Enterprise Manager 13c Release 5 Update 21 (13.5.0.21) | 명품관 | 2024.04.08 | 420 | 0 |
1 | Oracle Database 23ai 발표: 정식 출시 | 명품관 | 2024.05.07 | 201 | 0 |