Operation
To simulate the query slowdown problem, setup the database as below.
The CLP script in the adhoc SQL window on the right pane does the following:
- Creates a table.
- Inserts random data into the table. (To simulate the problem, indexes are not created on the table initially.)
To execute the CLP code :
- Click on the RUN button on the adhoc SQL window.
Pre-Requisites
Before proceeding to the next step, make sure that:
- Sample database is created. Use following command to create sample database:
- All monitor switches are turned ON. Use following commands to turn ON the monitor switches:
UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
UPDATE DBM CFG USING DFT_MON_LOCK ON
UPDATE DBM CFG USING DFT_MON_SORT ON
UPDATE DBM CFG USING DFT_MON_STMT ON
UPDATE DBM CFG USING DFT_MON_TABLE ON
UPDATE DBM CFG USING DFT_MON_TIMESTAMP ON
UPDATE DBM CFG USING DFT_MON_UOW ON
- Database is activated. Use following command to activate the database: