In the realm of database analysis, Quest Central 2.7 now allows users to create a tuning plan. It also features a shared repository of analysis results, eliminating the need to e-mail such results. The update features a shared folder for XML files on the network, which reduces the amount of space needed for storage. The suites Knowledge Xpert has been enhanced. Quest Central, previous to this update, had generic help text and advice. Now, industry knowledge and expertise from Oracle experts has been collected and is served up in the background of the suites tools. When a DBA is analyzing a database, he or she can zero in on a flashing red light or a spike of performance issues, click on it, and the tool will explain what the problem is and how to resolve it, officials said.For space management, Quest Central now has new rules that help to automate object sizing and growth regulation. It also has the ability to restart standard and LiveReorg scriptsan important enhancement, considering that DBAs often have to start scripts over or even rebuild them when they run into issues. A wizard interface now automates scripts and gives DBAs the ability to restart. SQL tuning has also been tweaked, with the ability to query the SGA (System Global Area) and to run reports on top sessions for SQL. This last feature is also standard, being a part of the console with this update, and can name top offending users by session, by offending application or by offending SQL statement. Quest Central for Oracle 2.7 starts at $2,400 for a single component and $11,600 for the suite of all four components. It will be live on Quests site by Monday afternoon.
A new summary report also features listings by state, with green or red color differentiation.