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.
Improving individual query performanceYou can test, monitor, and improve queries.
Optimize queries with the SQL statement cacheBefore the database server runs an SQL statement, it must first parse and optimize the statement. Optimizing statements can be time consuming, depending on the size of the SQL statement.
Monitoring memory usage for each sessionYou can use several onstat -g command options to obtain memory information for each session.

Monitoring memory usage for each session

You can use several onstat -g command options to obtain memory information for each session.

About this task

You obtain memory information by identifying the SQL statements that use a large amount of memory.

Procedure

To identify SQL statements using large amount of memory:

Run the onstat -g ses command to display memory of all sessions and see which session has the highest memory usage.
Run the onstat -g ses session-id command to display more details on the session with the highest memory usage.
Run the onstat -g stm session-id command to display the memory used by the SQL statements.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.