...
Based on the assumptions above, it is possible to guess how inefficient CPU usage is caused to execute the same query in the form of "Prepare-execute" every time. Therefore, if the following items are excessively increased with v$sysstat, it is recommended that the developer or operator modify the application program so as not to perform repetitive PREPARE or use the PLAN-CACHE function provided from Altibase version 5.
| Code Block | ||
|---|---|---|
| ||
iSQL> SELECT * FROM V$SYSSTAT WHERE NAME LIKE '%prepare%count%'; SEQNUM NAME VALUE --------------------------------------------------------------------- 37 prepare success count 25522 38 prepare failure count 56 |
...
It is conceptually impossible that some of the processes described above all require CPU resources, require CPU resources, and as a result, the query processing itself should produce fast performance while using a low CPU. However, it can be said that is is possible according to the efforts of the user/developer to efficiently use the CPU and perform the required performance.
...