MySQL Users Mostly Unfazed by Sun Acquisition

http://www.pcworld.com/businesscenter/article/144725/mysql_users_mostly_unfazed_by_sun_acquisition.html

Biggest Databases in the world !

click here to view them
http://weblogs.asp.net/pleloup/archive/2003/12/15/43693.aspx
Source: Wintercorp

Oracle Tuning Tools

Ignite™ for Oracle Performance

Confio Software is revolutionizing the way enterprises monitor, analyze and optimize their databases and applications. Developed for Oracle DBA?s, managers and developers, Confio's Ignite for Oracle performance solution enables organizations to optimize service levels for IT end-users and reduce total cost of operating infrastructure.

Actionable Data At An SQL Statement Level
Confio Ignite for Oracle performance tool offers DBAs unparalleled insight into the true sources of Oracle database performance issues that affect IT systems and customer service levels. Unlike other Oracle performance management solutions that take a snapshot of a single session at one point in time, Ignite for Oracle shows all sessions all of the time, monitoring databases from a single repository on a 24/7 basis. Analysis is based on Wait-time methodology so problems can be isolated to specific SQL statements, which provide the deepest and most actionable level of performance detail. Performance impacts can also be investigated without needing to re-create the problem. DBAs can access trend reports spanning weeks, months or years to conclusively demonstrate performance changes, improvements, and impacts of new applications.

Precise Problem Origination
Ignite for Oracle performance management provides a level of visibility into Oracle performance problems that eliminates vagueness and ambiguity regarding the root cause and owner of inefficiencies. Oracle performance issues can be traced to a departmental level so the appropriate owners can be engaged, such as the application owners, developers, DBAs, system and network admins, consultants or outside vendors.


Optimized customized impact
Unlike traditional Oracle performance management tools that focus only on internal IT impact, Ignite for Oracle?s proactive monitoring is designed to optimize the impact on the customer experience, the most relevant goal of performance analysis. Custom alerts and notifications empower DBA?s to quickly address mission-critical problems and minimize or eliminate customer impact.
Confio Ignite for Oracle's Wait-Time approach to analysis measures the time spent waiting on each Oracle resource, illuminating causes of database and SQL statement delays. By isolating bottlenecks inside the statement layer, improvements can be quickly identified and addressed. Impacts can be tracked over time to gauge effectiveness of modifications.

Agentless Operation
Ignite for Oracle performance management requires no installed software on the production server so performance tool contributes no load or process burden on the server.

for more information on the product please click on the link below -
http://www.confio.com/opt2_oracle_tuning_tools.php

mtop/mkill - MySQL Monitoring Tools

mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided.

mkill (MySQL kill) monitors a MySQL server for long running queries and kills them after a specified time interval. Queries can be selected based on regexes on the user, host, command, database, state and query.

Where to get it - http://mtop.sourceforge.net/

Oracle Enterprise Manager 10g R2

I found a very good presentation by Oracle DBA explaining OEM 10g Architecture, Features and monitoring.

http://www.nyoug.org/Presentations/2005/oem10gr2.pdf

Sybase MDA Tables

Monitoring tables (also known as MDA tables) are available in Adaptive Server version 12.5.x and later. So what does the MDA stand for "Monitoring Data Access” / “Monitoring and Diagnostics for ASE” / “Monitoring and Diagnostic Access" / “Monitoring and Diagnostic API. MDA tables are nothing but proxy tables in master database. There are approximately 35 mda tables. All starting with mon prefix. These tables can be accessed with regular SQL select statements. MDA tables provides low-level monitoring information which were not previously available like #logical I/Os for each process,SQL 'stacktrace' (stored proc/trigger call stack), cache usage details per table etc.

for more information on mda tables goto http://www.sybase.com or refer to Rob Verschoor web page - http://www.sypron.nl/main.html