Oracle - Performance Tuning

Post date: Apr 29, 2019 4:11:13 AM

Components of the Query Optimizer

The query optimizer operations include:

• • Query Transformation

  • Estimation

  • Plan Generation

How do you get the index of a table and on which column the index is?

dba_indexes and dba_ind_columns

How do you get the index of a table not in used?

how to full table  scan avoid .

How to sync replica in secondary RCA

which toot to use backup and recovery 

How to sync data in DR