ELLAROSE 16.01.11

ELLAROSE 是一款基於 Windows 的工具，專門為 Oracle 使用者提供更簡單的方式來管理和最佳化資料庫效能，同時也保留了強大的功能。（不幸的是，它不會接管世界或使用絕地心靈控制術；你不可能什麼都擁有。）

其關鍵優勢之一是，ELLAROSE 能夠在提取和處理基準原始資料後，直接以圖形化檢視產生關鍵效能指標。

ELLAROSE 採用極其簡單卻有效的 GUI，顯示最佳化和管理資料庫時所有必要且有用的面向。它在啟動時直接顯示連線、資料來源、環境和檔案選項，讓使用者能立即掌握目前狀況，並看到可能的後續步驟。這對時間就是金錢的人來說非常實用。

ELLAROSE 提供一些可自訂選項，讓您依自己偏好的方式工作，在資料來源方面可選擇自動工作負載儲存庫或 statspack。（我們一位從事 Oracle 工作的朋友說這是件好事。）

也可以從指定檔案載入基準資料，以產生歷史效能 (SQLStat)。也可以執行統計，以判斷總執行次數和平均執行次數，例如耗時、CPU 時間、處理列數、磁碟讀取、排序等。

等等，還有更多。彷彿以上還不夠，ELLAROSE 還支援（準備好了嗎）物件、安全性和儲存瀏覽器、資料檔案統計與對應、I/O 設定檔、等待事件、鎖存、緩衝區快取內容、SGA 命中率、顧問、健康檢查、參數歷史，以及 SQL 和系統拓撲。

整體而言，ELLAROSE 不適合膽小的人，也不適合那些認為這裡的 Oracle 與古希臘或《駭客任務》有關的人，但它確實附帶了廣泛且詳細的使用者文件，這點很不錯。ELLAROSE 也不需要安裝即可使用，只要解壓縮然後啟動即可。

*注意：為避免關於文字文件的啟動錯誤，必須將下載的套件儲存在 C: 磁碟機。

ELLAROSE is a Windows-based tool designed specifically with giving users of Oracle an easier way to manage and optimize database performance, while also retaining powerful features. (not take over the world or use Jedi force mind trick powers, unfortunately; you can’t have everything.)

One of its key advantages is the fact that ELLAROSE is capable of generating key performance metrics in graphical views directly after the extraction and processing of baseline raw data.

ELLAROSE comes wrapped up in devilishly simple yet effective GUI that shows all the aspects necessary and useful when optimizing and managing databases. It shows the connection, data sources, environment and file options directly at startup so users can instantly get a feel for what’s going on and also see potential next steps. This could be very handy for people where time is literally money.

ELLAROSE comes with a few customisable options for whatever way you want to work, giving you the choice of automatic workload repository or statspack when it comes to data sources. (A friend of ours who works with Oracle, says this a good thing.)

It’s also possible to load baseline data from a specified file in order to generate historical performance (SQLStat). Statistics can also be run to determine the total number of and average executions, such as elapsed, and CPU time, processed rows, disk reads, sorts, and others.

But wait, there’s more. As if all that stuff above wasn’t enough, ELLAROSE also supports (wait for it) object, security and storage browsers, datafile statistics and maps, an I/O profile, wait events, latching, buffer cache content, SGA hit ratios, advisors, health check, parameter history, and also SQL and system topology.

Overall, ELLAROSE isn’t for the faint of heart or who think that Oracle in this sense relates to something in ancient Greece or the Matrix, but it does come included with extensive and detailed user documentation, which is nice. ELLAROSE also doesn’t need to be installed to use, just unpacked and then launched.

*Note: To avoid a startup error concerning a text documents, it's necessary to save the downloaded package in the C: drive.