When should you increase copy latches? What parameters control copy latches?
- 1 Answers
- 647 Views
- I also Faced
- E-Mail Answers
Answer / Niranjan Jha
You should increase copy latches when your database experiences high rates of data block copies, such as during export and import operations or table partitioning. Copy latches are managed by the database parameter CONCURRENCY, specifically the COPIES_PER_LATCH setting.
| Is This Answer Correct ? | 0 Yes | 0 No |
You see a wait on lms process in statspack, what does that mean?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What is end user in database?
What is oracle partial backup?
How do I become a data manager?
What is the difference between raid 5 and raid 10? Which is better for oracle?
What do you mean by oracle dba and what is its role?
What are the beneficial tools for administering the database?
Tell me about standby database? What are some of the configurations of it?
How can you find all the processes on your system?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
Oracle General 
