QC Sense Schema

QC Sense has a single database schema per ALM site. The schema is created during the ALM installation, and stored by default in the Site Administration schema. However, the QC Sense schema is independent of the ALM Site Administration schema, and the tables can be stored in any database schema. For enterprise sites, we recommend storing the schema on another database server. For details on defining an alternate location for the QC Sense schema, see QC Sense Configuration.

The QC Sense schema consists of the following tables:

Table Name

Data Source

Data Type

PERF_CLIENT_OPERATIONS

Client

Raw

PERF_CLIENT_METHODS_CALLS

Client

Raw

PERF_CLIENT_REQUESTS

Client

Raw

PERF_SERVER_THREADS

Server

Raw

PERF_SERVER_SQLS

Server

Raw

PERF_SERVER_GENERAL_MEASURES

Server

Aggregated

PERF_SERVER_THREAD_TYPES

Server

Aggregated