The main drill downs are "top sql", "top session", "top event" and "top objects". AAS is a single powerful metric which measures the load on the database based on the ASH data. AAS data provided the perfect road map for what data to drill into. The solution for this was "Average Active Sessions" ( AAS). The rich robust data from ASH in its raw form is difficult to read and interpret. ASH is an automated collection of session state sampling. Profiling, easy view of load and drill down (vs just a bunch of statistics) This page represents to the best of my knowledge the comparisons between Quest's. One executable (verses separate installs) Visual SQL Diagram. The session state method was officially packaged by Oracle in 10g when they introduced "Active Session History" ( ASH). Tune SQL like a pro with DB Optimizer, IDERAs SQL database optimization tool, which offers performance optimization suggestions, visual tuning diagrams and. 3 big differences between Spotlight/SQL Optimize from Quest and DB Optimizer from Embarcadero is that DB Optimizer is. The session sampling method was used by me occasionally over the years and I even wrote up a method to access this information without SQL on Oracle by reading the live database memory via C code. Session state includes who the session is, what their state is (active, waiting, and if waiting, what they are waiting on) and what SQL they are running. The solution to collecting performance data required letting go of the old stodgy problematic paradigm of trying to collect as many performance counters possible as often as we could and instead freeing ourselves with the simple approach of sampling session state.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |