Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
The onperf utility on UNIXThe onperf utility is a windowing environment that you can use to monitor the database server performance. The onperf utility monitors the database server running on the UNIX™ operating system.
The onperf user interfaceWhen you invoke the onperf utility, it displays an initial graph-tool window. From this graph-tool window, you can display additional graph-tool windows as well as the query-tree, data-collector, and activity tools.
Graph toolThe graph tool is the principal onperf interface. Use the graph tool to display any set of database server metrics that the onperf data collector obtains from shared memory.
Graph-tool Tools menuThe Tools menu contains options that start additional onperf tools.

Graph-tool Tools menu

The Tools menu contains options that start additional onperf tools.

This menu provides the following options.

Query Tree: Starts a query-tree tool. For more information, see Query-tree tool.
Status: Starts a status tool. For more information, see Status tool.
Disk Activity: Starts a disk-activity tool. For more information, see Activity tools.
Session Activity: Starts a session-activity tool. For more information, see Activity tools.
Disk Capacity: Starts a disk-capacity tool. For more information, see Activity tools.
Physical Processor Activity: Starts a physical-processor tool. For more information, see Activity tools.
Virtual Processor Activity: Starts a virtual-processor tool. For more information, see Activity tools.