Books for you

Another
common cause is a shared pool that??™s too small, as discussed previously in the
section ???The shared pool.??? Keep in mind that youcan avoid the creation of execution
plans by using stored outlines, as described in Chapter 4. And, as of
Oracle9i, you also have the ability to edit the hints that make up a stored outline.
As described earlier, Oracle Database 11g includes the ability to cache
complete result sets, which can minimize the impact of repeated execution of
identical queries.
Database workload
If your application is well designed and your database is operating at optimal
efficiency, youmay experience a shortage of CPU resources for the simple reason
that your server doesn??™t have enough CPU power to perform all the work it??™s
being asked to do. This shortage may be due to the workload for one database (if
the machine is a dedicated database server) or to the combined workload of multiple
databases running on the server. Underestimating the amount of CPU
resources required is a chronic problem in capacity planning.


Pages:
387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411