Home > Articles

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Administration Utilities

The following sections describe the administration utilities available from third-party vendors.

AppWorx Corporation

Product Name: AppWorx Oracle Applications Extension

Product Category: System Management

Contact Name: Tim Donovan

Contact Phone: (425) 644-2121

Contact E-mail: tdonovan@appworx.com

Web Page: http://www.appworx.com

The AppWorx Oracle Applications Extension (OAE) is an Oracle-approved software solution that extends the capabilities of Concurrent Manager by providing job scheduling, workload balancing, and output management in the Oracle Applications environment. With AppWorx and OAE as their single point of control, Oracle Applications customers can manage their job streams as business processes, implementing multi-job and multi-instance dependencies and providing conditional logic to their processing. The product is designed for use by both end users and systems personnel.

AppWorx OAE has a full-featured output viewer to examine data online. It also provides enterprise-caliber output management; distributing data to remote printers, e-mail addresses, printer lists, or data files, as well as removing expired output. AppWorx OAE can be configured to send e-mail notifications of job status, issue alerts via pager, or run custom scripts based on job outcome. AppWorx OAE is tightly integrated with Oracle's Concurrent Manager and the Oracle database, and can run standard and nonstandard jobs alike, simplifying the automation of complex processing routines including FSG Generation, MRP planning, Mass Allocations, and G/L Importing and Posting.

OuterBay Technologies

Product Name: OuterBay Archiver for Oracle Applications

Product Category: Online archiving, Purge and Archive, Data Management

Contact Name: Bill Morrow, Vice President of Sales and Marketing

Contact Phone: (408) 557-6100

Contact E-mail: sales@outerbay.com

Web Page: http://www.outerbay.com

OuterBay is the creator of OuterBay Archiver, an Online-Archive solution that leverages standard Oracle Applications purge functions to intelligently deposit purged data into a single online archive database. By reducing the amount of data in production, Oracle Applications runs faster, 11i upgrades take less time, and system infrastructure costs are reduced.

Purging older data from OLTP will reduce the required system outage, so using the OuterBay Archiver should be considered a prestep when performing an Oracle 11i upgrade. The OuterBay Archiver removes the need to support legacy versions of the applications, because historical data is upgradeable and accessible through Oracle 11i. It also reduces the hardware upgrade costs historically required to ensure acceptable performance after an upgrade. Plus, it safeguards your corporate investment in Oracle Applications and user training by extending the standard Oracle functionality. OuterBay is a member of the Oracle Partner Program.

Precise Software Solutions, Inc.

Product Name: Precise/Interpoint

Product Category: Administration Utilities

Contact Phone: (781) 461-0700, toll-free (800) 310-4777

Contact FAX: (781) 461-0460

Contact E-mail: info@precise.com

Web Page: http://www.precise.com

Precise/Interpoint is a unique performance management solution for enterprise resource planning (ERP) applications. Tailored to Oracle Applications, Precise/Interpoint monitors your Oracle database as well as your ERP application to identify and track problematic SQL statements to their origins—ERP users, modules, transactions, programs, screens, reports, requests. Using the core technology of Precise/SQL, Precise/Interpoint gets to the root of your database performance problem, regardless of its cause: database parameters, the ERP application, user customizations, or extensions.

By optimizing the way ERP applications access your Oracle database, Precise/Interpoint maximizes the performances of your ERP applications and helps you meet your business needs.

Step-by-Step, Nonintrusive Performance Management

Precise/Interpoint provides meet an easy-to-use, comprehensive method that guides you through performance management from start to finish—from proactive monitoring and problem detection to problem analysis, resolution, and verification. Precise/Interpoint allows you to pinpoint the causes of your performance problems, model potential solutions to those problems, and analyze the impact of proposed changes before putting those changes into production.

ERP Performance Challenges Overcome

ERP applications meet automate complex business processes in which high performance and throughput are crucial. ERP vendors create their applications for average users, not specific users in unique business environments. User needs, usage patterns, customizations, system components and architectures, and platform environments vary from business to business, causing ERP application performance to vary widely. Tuning ERP applications to ensure that those applications work together efficiently and effectively in their unique environments is crucial if those applications and the businesses they help automate are to succeed.

Ideal for today's customizations and development, deployment, and production environments, Precise/Interpoint helps you manage ERP performance by automatically and proactively identifying and tracking resource-consuming SQL statements to their points of origin: ERP users, modules, transactions, programs, screens, reports, or requests. Precise/Interpoint also breaks down Oracle resources by ERP entity, allowing you to focus on and tune your largest Oracle resource consumers.

Pinpointing Performance Problems

ERP applications identify themselves to Oracle databases using one or several generic user IDs and program names. Because ERP identifiers do not individualize ERP users or transactions, it is impossible for most performance management tools to pinpoint the true sources of performance bottlenecks in ERP applications.

Tailored to Oracle Applications, Precise/Interpoint continuously monitors the Oracle database and ERP applications and correlates the resulting data to locate the cause of a performance problem, regardless of where that problem occurs—in the database, the core ERP application, the user customization or extension. Next, Precise/Interpoint drills down to pinpoint the resource-consuming SQL statements executed by the ERP application.

SQL Statement Improvement

Most ERP applications prevent you from changing the SQL statements they generate. Therefore, the only way to tune SQL statements is to tune the objects those statements access.

Precise/Interpoint displays all relevant indexes for an SQL statement to help you identify and choose the best one. If no relevant index exists, Precise/Interpoint helps you design a new one by displaying relevant table columns and their usage and effects on the problematic SQL statement.

Solving one performance problem may cause problems elsewhere in a system, however. Therefore, it is critical to simulate and verify changes before putting them into production. Precise/Interpoint lets you simulate the creation, deletion, or modification of an index in a production-safe environment to determine how that change would impact your environment.

By improving SQL statements, Precise/Interpoint helps you maximize the performances of your ERP applications according to your business's application configuration, system architecture, and database platform and version features.

Tailored to Oracle

Precise/Interpoint supports all versions of Oracle. Special modules handle the latest features and allow you to establish performance baselines and benchmark the performances of your ERP applications when you migrate your databases to newer versions of Oracle.

Quest Software

Product Name: SQL Impact

Product Category: System Administration, Data Conversion, and Implementation

Contact Name: Barry Lewis

Contact Phone: (949) 754-8000

Contact E-mail: blewis@quest.com

Web Page: http://www.quest.com/sql_impact/

SQL Impact allows changes to be made to a database with proper impact analysis. This software provides documentation and auditing capabilities to manage the interdependencies between the application source code and all database objects. Developers use SQL Impact to identify that all programs impacted are verified. SQL Impacts' impact analysis process determines precisely which components of an application are affected by structural changes to the database.

SQL Impact drills down to the individual lines of source code affected. SQL Impact can initiate an editing session to perform and test the required changes. This software provides important application documentation on how each application uses the database and the interdependencies between application objects. By automating the tedious and error-prone task of impact analysis, SQL Impact enhances the productivity of DBAs and developers while improving the overall reliability of the system.

Product Name: I/Watch

Product Category: System Administration Utility

Contact Name: Dax French

Contact Phone: (949) 754-8000

Contact E-mail: Dax.French@quest.com

Web Page: http://www.quest.com/i_watch/

I/Watch monitors both the database and operating system. It runs unattended and alerts the DBA or system administrator of impending problems. When notification of the problem is received, I/Watch takes the DBA through the necessary steps to respond from pinpointing the problem all the way to its final resolution. I/Watch provides sophisticated historical replay and analysis capabilities to identify the causes of the problem.

I/Watch can be configured to provide early notification, should the same conditions recur. If practical, I/Watch can even be programmed to take automatic corrective action, thus minimizing the chances of the problem reoccurring. Other features include a capacity to help tune the environment for optimal performance, recommendations for configuration changes, and identification of bottlenecks.

Product Name: SQLab Vision

Product Category: System Administration Utility

Contact Name: Vickie Cohen

Contact Phone: (949) 754-8000

Contact E-mail: Vickie.cohen@quest.com

Web Page: http://www.quest.com/sqlab_vision/

SQLab Vision is the new generation of application tuning. Combining a powerful Oracle tuning environment with nonintrusive collection technology, impact analysis capabilities, and expert tuning advice, SQLab Vision evolves SQLab Xpert into the most advanced tuning solution available

SQLab Vision features Quest's new StealthCollect technology to collect SQL statements and performance indicators from Oracle databases and host operating systems at subsecond intervals. SQLab Vision collects data nonintrusively, with no added overhead on the target database and minimal overhead on the host system. StealthCollect runs 24/7, enabling you to identify and resolve problems in the past and collect performance information automatically, requiring no management time or active maintenance.

Product Name: SQL Navigator

Product Category: System Administration Utility

Contact Name: John Theis

Contact Phone: (949) 754-8000

Contact E-mail: john.theis@quest.com

Web Page: http://www.quest.com/sql_navigator-portal/

The SQL Navigator family is a complete development environment for Oracle PL/SQL and SQL server-side development and management. It provides an integrated environment for development and testing of stored procedures, schemas, SQL scripts, and more, all from an easy-to-use graphical user interface. This solution suite was conceived, designed, and developed by Oracle developers and DBAs who have hands-on experience with the most typical problems faced by Oracle developers. SQL Navigator has set new standards in the complex process of developing, testing, and managing applications that interface with Oracle databases.

SQL Navigator's user-friendly design is helping Oracle development and administration teams achieve unprecedented productivity gains worldwide.

The SQL Navigator family also includes optional modules for PL/SQL debugging, SQL tuning with Xpert advice, integrated version control with InterSolv PVCS and Microsoft SourceSafe, integrated impact analysis, and Oracle Web development.

Product Name: Schema Manager

Product Category: System Administration Utility, Implementation Tools

Contact Name: Hassan Fahimi

Contact Phone: (949) 754-8000

Contact E-mail: hassan.fahimi@quest.com

Web Page: http://www.quests.com/

Schema Manager provides a comprehensive repository that supports all object types and dependencies. Simple drag-and-drop capabilities enable a DBA to quickly populate the repository from an existing database environment, creating a baseline version. Using the baseline version, Schema Manager can support schema changes in both development and production modes.

During development, frequent schema changes can be made directly to the development database. In contrast, in production mode schema changes must be carefully orchestrated. Schema Manager calculates the "delta" and captures all the changes made during development and then automatically generates the corresponding upgrade script to apply the changes to the target database. With pre-audit and post-audit features, if the deployment is unsuccessful, a rollback script is provided to undo all changes without loss of user data.

Product Name: SharePlex for Oracle

Product Category: Enhanced Reporting, System Administration, and e-Commerce

Contact Name: Melanie Kacerek

Contact Phone: (949) 754-8000

Contact E-mail: mkacerek@quests.com

Web Page: http://www.quests.com

SharePlex for Oracle is a high-speed, log-based replication software solution that continuously replicates changes from a production instance to multiple, fully accessible "target" Oracle instances. The target instances can be used daily for reports and queries, and as needed for high availability and disaster recovery (planned and unplanned outages of the production system). Offloading the reports improves the general performance for an OLTP environment. Relocating ad hoc queries eliminates spikes in OLTP performance. Target instances can be local or remote because SharePlex for Oracle supports both LAN and WAN environments. Consequently, you can use SharePlex for Oracle to get the data to the users, wherever they might be.

SharePlex for Oracle is designed to handle business volumes of data—thousands of transactions per second for thousands of tables without the overhead costs associated with trigger-based solutions. By monitoring the redo logs, replicating the changes via memory as much as possible, and using a continuous, high-speed network protocol over TCP/IP (not SQL*Net), SharePlex for Oracle is able to replicate quickly with a very small footprint on the source system, source instance, and the network. Its comprehensive and flexible nature enables SharePlex to replicate complete ERP applications because it replicates long columns and sequences in addition to tables. SharePlex for Oracle provides continually updated and accessible targets that offer options for reporting, high availability, and disaster recovery, without the drawbacks of trigger-based solutions.

Product Name: Space Manager

Product Category: System Administration Utility

Contact Name: Hassan Fahimi

Contact Phone: (949) 754-8000

Contact E-mail: Hassan.Fahimi@quest.com

Web Page: http://www.quest.com/space_manager/

Space Manager provides a comprehensive solution for space management and reorganization. This software offers preventative maintenance, problem detection and resolution, and capacity planning across any number of databases. In correct object sizing and reorganization, Space Manager can provide both defragmentation and relocation, features designed to improve access times and have minimal impact on application availability.

Space Manager's capacity-planning feature can prevent problems such as running out of space by predicting the future size of individual objects, groups of objects, or even the entire database. The software automates the space management process, thus increasing DBA productivity and significantly enhancing the performance and overall quality of the Oracle database environment.

Product Name: SQLab Xpert

Product Category: System Administration Utility

Contact Name: Azeem Mohammed

Contact Phone: (949) 754-8000

Contact E-mail: azeem.mohammed@quest.com

Web Page: http://www.quests.com/

SQLab Xpert provides context-sensitive tuning advice for SQL statements based on the Oracle execution plan and the database structure. The software identifies offensive SQL statements, provides EXPLAIN information, tunes the SQL and the Indexing scheme, and as a result resolves I/O bottlenecks.

When the offensive SQL statements have been identified, SQLab Xpert provides fast, intelligent advice on how to improve response time, substantially improving productivity. With a click of a button, SQLab Xpert can then rewrite SQL statements to implement the advice that is selected. This software provides for a comparison of several possible tuning scenarios simultaneously across multiple databases and enables the user to select the solution that provides the best results.

Product Name: TOAD

Product Category: System Administration Utility

Contact Name: John Theis

Contact Phone: (949) 754-8000

Contact E-mail: john.theis@quest.com

Web Page: http://www.quest.com/toad/

TOAD is a lightweight, powerful tool built around an advanced PL/SQL editor. Object browsers give users quick access to database objects. Hotkeys, auto-correct, and type-ahead features make PL/SQL editing and testing fast and effortless. Registered users get Web access to bug fixes and enhancements. Licensed TOAD users get bug fixes, regular enhancements, and new features, such as Oracle9 and 9i object support and more.

TOAD users also benefit from e-mail access to Quest Software Technical Support Staff.

  • + Share This
  • 🔖 Save To Your Account

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020