Interested to Buy Any Domain ? << Click Here >> for more details...
How can we collect the statistics of different database objects?
- 1 Answers
- 7 Views
- I also Faced
- E-Mail Answers
Answer / Satendra Pal Singh Chauhan
To collect statistics for database objects, you can use DBMS_STATS package. You can run DBMS_STATS.GATHER_TABLE_STATS procedure to gather statistics for a specific table or DBMS_STATS.GATHER_DATABASE_STATS procedure to gather statistics for the entire database.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
What do you understand by redo log file mirroring?
Mention what is olr?
Mention what is cluster?
Mention where does the clusterware write when there is a network or storage issue?
How is clustered database important in oracle rac architecture?
Mention what is split brain syndrome in rac?
Can you list down the different components of physical and logical database structure?
How would you identify the shared_pool_size parameter that needs to be adjusted?
Mention what are the file storage options provided by oracle database for oracle rac?
What is split brain syndrome in rac?
What are the file storage options provided by oracle database for oracle rac?
Oracle General 
