메뉴 건너뛰기

Korea Oracle User Group

새소식

 

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:

moats_racScreen Shot 2015-12-08 at 12.56.41

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/

번호 제목 글쓴이 날짜 조회 수 추천 수
187 Announcing SQL Server on Linux [5] 명품관 2016.03.09 2881 1
186 eDB360 - Carlos Sierra's Tools(SQLTXPLAIN 개발자) 명품관 2016.04.25 1665 1
185 오라클 릴리즈 로드맵 [2] file 명품관 2019.05.15 7145 1
184 VirtualBox 5.0.10 released! November 10th, 2015 ecrossoug 2015.11.13 948 0
183 Oracle Announces Beta Availability of Oracle Database 12c Release 2 명품관 2015.12.07 917 0
182 2023년 5월 오라클 Help Center Learn의 튜토리얼과 labs 명품관 2023.06.13 229 0
181 The Modern Command Line (SQL, PL/SQL) 명품관 2015.11.24 619 0
180 How to Test OCFS2 in a Virtual Environment 명품관 2015.11.24 1893 0
179 How to Configure x86 Memory Performance for Large Databases Using Linux HugePages 명품관 2015.11.24 1431 0
178 How to Set Up DTrace to Detect PHP Scripting Problems on Oracle Linux 명품관 2015.11.24 1641 0
177 Advanced Usage of the AWR Warehouse 명품관 2015.11.24 989 0
176 Multitenant Database Management 명품관 2015.11.24 560 0
175 Oracle VirtualBox 5.0.14 released! 명품관 2016.01.21 408 0
174 Announcing the general availability of Oracle Linux 7.2 명품관 2015.11.30 186729 0
173 Watch featured OTN Virtual Technology Summit Replay Sessions - Nov 30, 2015 명품관 2015.12.01 28162 0
172 Free webinar - Advanced Oracle Database Administration in Action with Uwe Hesse 명품관 2016.01.06 435 0
171 Oracle PL/SQL to Excel xlsx API ORA_EXCEL 명품관 2016.01.07 1425 0
170 Time-out and Thanks by Tom Kyte (Tom Kyte 의 휴식) 명품관 2016.01.08 20396 0
169 Oracle Database certification on Microsoft Windows 10 명품관 2016.01.08 3071 0
168 Announcing the general availability of Unbreakable Enterprise Kernel Release 4 명품관 2016.01.11 666 0
위로