Oracle - What is cost based optimization? When is it triggered? posted by
Babu Kunwar
What is cost based optimization? When is it triggered?
Cost based optimizer as the name suggest does not talk in sense of money.
Optimizer means to get best out of the given resource. In Oracle CBO is used so
that the tables and indexes in your application can be analyzed regularly. The
frequency with which we analyze the objects depends on the rate of change
within the objects. For example in case of batch transaction applications, we
should reanalyze the objects after each large set of batch transactions. CBO
checks that what is the percentage of CPU being utilized by the application,
how many times the system is hitting memory (cache)?
We can trigger CBO by changing the statics of object by doing an analyze. Also
by changing some initialization parameters.
More links
Types of users - a local user, an external user, or a global user
Explain how to create users through Sql Plus.
How to delete an Oracle applications user?............
|
