Interested to Buy Any Domain ? << Click Here >> for more details...
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
- 1 Answers
- 7 Views
- I also Faced
- E-Mail Answers
Answer / Akhilesh Kumar Ojha
Performance tuning of a database refers to optimizing its efficiency and effectiveness to meet the system's requirements. This process aims to improve response times, throughput, scalability, and reduce resource consumption. The different areas for performance tuning include SQL tuning, schema design, indexing, database configuration, I/O tuning, memory management, and concurrency control.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a system tablespace and why do we need it?
What are the file systems and volume management techniques used in oracle rac?
How do you recover a lost control file?
What do you understand by row chaining?
Mention what are the benefits of oracle rac?
What is tkprof and how can we use it?
What is rac and what are the various benefits of using rac architecture?
Explain the oracle real application clusters architecture?
What are the conditions kept in mind while connecting the oracle rac with the network?
How is clustered database important in oracle rac architecture?
Mention what are the file storage options provided by oracle database for oracle rac?
How can a single instance environment be converted into rac environment and how will they be different?
Oracle General 
