Monitoring Performance

In This Section:

Finding Diagnostic Information

Viewing Essbase Server Information

Viewing Application Information

Viewing Database Information

Monitoring the Status of Applications and Databases

Monitoring User Sessions and Requests

Monitoring Applications from the Operating System

Also see:

Finding Diagnostic Information

Essbase provides performance information dialog boxes at the Essbase Server, application, and database level. View performance information before performing these tasks:

  • Preparing to migrate data

  • Adding users

  • Analyzing performance problems

  • Performing other administrative tasks

Essbase displays information on a snapshot basis; to see the latest information, click Refresh. If the Refresh button is displayed in a window or dialog box, it updates every tab in the window or dialog box.

For a comprehensive discussion of Essbase Server, application, and outline logs, see Essbase Server and Application Logs.

The following sections provide procedures for accessing information about Essbase Servers, applications, and databases that are commonly used to diagnose performance or other issues.

Viewing Essbase Server Information

You can view information about the Essbase Server license, configuration, operating system, disk drives, and applications for Essbase Server.

  To view Essbase Server information, use a tool:

Tool

Topic

Location

Administration Services

Monitoring Essbase Servers

Oracle Essbase Administration Services Online Help

MaxL

display application

Oracle Essbase Technical Reference

ESSCMD

GETAPPSTATE

Oracle Essbase Technical Reference

Viewing Application Information

You can view application information to identify which databases are running in the application and to check access, security, and startup information.

  To view application information, use a tool:

Tool

Topic

Location

Administration Services

Monitoring Applications

Oracle Essbase Administration Services Online Help

MaxL

display application

Oracle Essbase Technical Reference

ESSCMD

GETAPPSTATE

Oracle Essbase Technical Reference

Viewing Database Information

You can view information about database storage, database statistics, and lock contention. This information may help you identify activities or operations that affect performance.

  To view database information, use a tool:

Tool

Instructions

See

Administration Services

Monitoring Databases

Oracle Essbase Administration Services Online Help

MaxL

display database

Oracle Essbase Technical Reference

ESSCMD

  • For general information: GETDBINFO

  • For database storage information: GETDBSTATE

  • For currency information: GETCRDBINFO

  • For database statistics: GETDBSTATS

  • For runtime information: GETDBINFO

Oracle Essbase Technical Reference

Monitoring the Status of Applications and Databases

You can view the start and stop status of applications and databases that you are authorized to use.

  To view application/database status, use a tool:

Tool

Instructions

For More Information

Administration Services

Viewing Application/Database Status

Oracle Essbase Administration Services Online Help

ESSCMD

GETAPPINFO

GETDBINFO

Oracle Essbase Technical Reference

Monitoring User Sessions and Requests

You can monitor active user sessions for an Essbase Server, application, or database. If you have Administrator or Application Manager permissions, you can disconnect a user session or terminate a request made during a session. See Disconnecting Users and Terminating Requests in Essbase Native Security Mode.

  To monitor user sessions and requests, use a tool:

Tool

Instructions

For More Information

Administration Services

Viewing Active User Sessions

Oracle Essbase Administration Services Online Help

MaxL

display session alter system

Oracle Essbase Technical Reference

Monitoring Applications from the Operating System

Each application that is loaded is an open task or process in the operating system. You can use the operating system to view application tasks or processes:

  • On Windows platforms, the application is displayed in an application server window, where you can view application activities as they occur. When the Agent starts an application, a new icon is displayed in the taskbar. Double-click the icon to view the application server window.

  • On UNIX platforms, the application server is often a background process. When the application starts, the ESSBASE command starts the ESSSVR process. To see activities, you can route all messages to a file with the tail -f log command, where log is the name of a file that you specify.

  • You can also view a snapshot of the Essbase Server or application log using Administration Services. For information about viewing, filtering, searching, and analyzing logs, see Oracle Essbase Administration Services Online Help. For information on server and application logs, see Essbase Server and Application Logs.