Goal of this tutorial
Before proceeding further, lets see what we want to achieve from this tutorial.
You can see a sample view in right pane. This is what we will be creating in subsequent steps.
Things to note:
- The view displays the result of an SQL statement
- The view has an option of selecting REFRESH INTERVAL on top right. You can set it to any value you want, and the view will keep on refreshing itself after this time interval automatically.
- Column 'Total CPU Rate' displays the rate at which CPU is being used. This rate is calculated by TE automatically. In this example, it shows the amount of CPU an application has comsumed in last n seconds('n' is the denominator of this column).
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: