Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
- 0 Answers
- 336 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You see a wait on lms process in statspack, what does that mean?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
How should a many-to-many relationship be handled?
Which function is used to find the largest integer less than or equal to aspecific value?
What does database administrator do?
If you see contention for library caches how you can fix it?
Give one method for transferring a table from one schema to another?
Which rman command is used to create an exact replica of a database innew host?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
What is the main function of database?
What are roles in oracle?
What is the difference between a database and instance?
Oracle General 
