Home | Previous Page | Next Page   Monitoring Database Server Performance >

Monitoring Cartesian Joins

The server can be configured to raise an alarm any time a cartesian join is executed. To enable this alarm, set the IFMX_CART_ALRM environment variable to any value before starting the server.

When triggered by a query executing a cartesian join, the alarm will write a message to the log similar to the following:

Cartesian Join being processed for session 1.2453

The value of IFMX_CART_ALRM can be modified while the server is on-line using the onutil SET command:

% onutil
1> SET IFMX_CART_ALRM 1;
Dynamic Configuration completed successfully
2> SET IFMX_CART_ALRM 0;
Dynamic Configuration completed successfully

The onutil SET command cannot make changes to environment variables persistent. If the server is restarted, the new setting will be lost. To ensure that your desired setting IFMX_CART_ALRM persists across server restarts, put the variable in an environment-configuration file.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]