Oracle - What is index monitoring feature in oracle? posted by
Babu Kunwar
What is index monitoring feature in oracle? Explain how to use it for index
optimization
SQL engine keeps indexes of all the tables that are defined inside a particular
database which cause a large amount of the CPU and I/O usage. Index monitoring
is a feature that is used to identify such index accurately and removing the
risks associated with dropping useful indexes. It can be started and stopped by
the ALTER INDEX syntax that is provided by Oracle. It can be also used for
checking whether application is using the index or not.
We can use index monitoring features for index optimization with STATSPACK and
AWR tables.
More links
Overview of PL/SQL Error Handling
Advantages of PL/SQL Exceptions
Explain some of the commonly used Predefined PL/SQL Exceptions.
What is user-defined exception? Explain it with an example.
Explain how PL/SQL exceptions are raised..........
|
