What parameters control copy latches?
No Answer is Posted For this Question
Be the First to Post Answer
How can you tell if an index on particular table is used or not used in 9i?
You see a wait on lms process in statspack, what does that mean?
What is the difference between raid 5 and raid 10? Which is better for oracle?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
When using oracle export/import what character set concerns might come up? How do you handle them?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
Which function is used to find the largest integer less than or equal to aspecific value?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What does the no logging option do? Why would we be careful of using it?