Integration Software

InShape for Oracle

We all know that the secret to staying healthy and fit depends on regular, routine exercise and good maintenance habits. The same is true for our database. But how can we ensure that our database stays in shape?

One of the most challenging tasks for an Oracle database administrator is to solve performance issues which impact business critical processes. InShape was designed from the ground up with performance tuning in mind, it divides complex database information into logically grouped categories.

Throughout the work week end-users interact with the database to conduct their urgent business activities. They insert new data and run complex transactions using a variety of applications that combine and integrate data from different sources. Sales teams enter new customer and pricing data; Business Analysts report on operational data stores, data marts or data warehouses to make decisions that achieve better business outcomes; managers keep track of their key performance indicators. InShape can profile these application specific queries for in depth troubleshooting.

General Database Information

A quick glance of all important aspects of your database. The starting point to zoom in into specific database areas such as:

  • configuration settings
    (e.g. installed options, database parameters, memory settings)
  • tuning overview
  • backup overview
  • session information
  • configuration of logical and physical space
InShape for Oracle inshape dboverview
InShape for Oracle inshape backup

Backup and High Availability

An overview of your backup and recovery strategy. All information you need to make sure you can restore a database.

  • An overview of all current and archived redolog information
  • Archiver information
  • Flashback data archives
  • Streams settings
  • Grants on SYS objects
  • Custom objects created under the SYS schema

Session and Locks

Everything you need to investigate the root cause of why a session is currently not responsive.

  • An overview of all current sessions with their module info, the wait event, lock information
  • Zoom into a specific session to see its resource usage, current sql, parsing information, redo and memory usage
  • Delve into the current sql to check the sql plan, execution times, optimizer information
  • All lock information, such as DML and DDL locks, distributed transactions, blocking and waiting lock threads
InShape for Oracle inshape session locks


InShape for Oracle inshape space

Space Management

With the space management screens, you can get all information about the logical and physical setup of your database

  • All tablespaces in the system, including the SYSAUX and temporary tablespaces
  • All database datafiles
  • A detailed redo log overview, zoom in to find high load moments of the day
  • An extended overview of undo information used to identify bottlenecks in your undo management strategy
  • Flashback data archives
  • Directories used for data pump and external tables
  • Quick overview of the trace file locations and alert log directory

Security Overview

Uses these screens to check who can access your database, what privileges and roles they have. Audit unauthorized access and detect security breaches.

  • Overview of all users in the database, with one-click access to all current sessions
  • All roles, privileges and assigned users
  • User profiles
  • Resource management plans
  • Audit overview to be used to identify potential security gaps
InShape for Oracle inshape security
InShape for Oracle inshape tuning

Performance Tuning

When the system performs slow, use these screens to identify what’s causing delays.

  • Overview of all sql statements consuming lots of I/O and/or CPU
  • Zoom into the bad performing sql statements to investigate the culprit sql plan
  • Check system wide latches, statistics, wait events and system events in order to discover resource starvation
  • Spot bad parsing and sql statements vulnerable for sql injection
  Contact Us   Data Sheet   Request a quote

Requirements

Runs on:

  • Windows XP
  • Windows Vista
  • Windows 7
  • Windows 8

Requires Internet Explorer to be installed.
Requires the .Net Framework 4.x to be installed.

News

Blog

Twitter Feed

Contact us


+ 5 = eight