Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Quest Hones Database Management Tools

    By
    Lisa Vaas
    -
    June 16, 2003
    Share
    Facebook
    Twitter
    Linkedin

      Quest Software Inc. is rolling out a version of Quest Central for Oracle that sports new memory management capabilities and automated advice that can help get DBAs out of tight spots, the company announced on Monday.

      Quest Central for Oracle 2.7 is a collection of database management tools including Spotlight on Oracle, a diagnostics tool; SQLab Vision, a tuning tool; Live Space Management, a tool for managing space and reorganizing without taking a database down; and Knowledge Xpert, a tool that supplies definitions to help DBAs work through problems.

      TOAD (Tool for Oracle Application Developers), a database development product that normally ships with Quest Central versions, is not included in this version. TOAD will appear in Version 4.0, which will ship in the fall, said officials at the Irvine, Calif., company.

      Quest Central for Oracle 2.7 enables database performance tuning, administration, performance diagnostics and space management in a single console. The update features an enhanced console that allows for user feedback, browsing thats enabled through a virtual tree, notification of license expiration and an option to automatically check for software updates.

      The update will enable database administrators to view temporary and locally managed data files and tablespaces. It comes with new Table VOEs (Visual Object Editors), giving DBAs the ability to modify tables and their parameters. It also features the ability to kill user sessions from the console. As part of the standard console—i.e., shipping with any of the suites components—the software also provides the ability to look into Oracles Trace files through a GUI interface.

      Performance diagnostics were updated with new Oracle9i advisories, enhanced startup-up and loading views, and the ability to remember Windows sizing and positioning.

      Page 2

      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.

      A new summary report also features listings by state, with green or red color differentiation.

      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 scripts—an 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.

      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Careers

      SThree’s Sunny Ackerman on Tech Hiring Trends

      James Maguire - June 9, 2022 0
      I spoke with Sunny Ackerman, President/Americas for tech recruiter SThree, about the tight labor market in the tech sector, and much needed efforts to...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×