Explain What is the use of ANALYZE command?
Submitted by: AdministratorTo perform one of these function on an index,table, or cluster:
- to collect statisties about object used by the
optimizer and store them in the data dictionary.
- to delete statistics about the object used by
object from the data dictionary.
- to validate the structure of the object.
- to identify migrated and chained rows of the table or
cluster.
Submitted by: Administrator
- to collect statisties about object used by the
optimizer and store them in the data dictionary.
- to delete statistics about the object used by
object from the data dictionary.
- to validate the structure of the object.
- to identify migrated and chained rows of the table or
cluster.
Submitted by: Administrator
Read Online Oracle Security Job Interview Questions And Answers
Top Oracle Security Questions
☺ | What is snapshots? |
☺ | How to specify the Archived log file name format and destination? |
☺ | Explain What are the dictionary tables used to monitor a database spaces? |
☺ | How to prevent unauthorized use of privileges granted to a Role? |
☺ | Explain snapshot log? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |