You see a wait on lms process in statspack, what does that mean?
- 1 Answers
- 655 Views
- I also Faced
- E-Mail Answers
Answer / Ashish Parmar
A wait event on LMS (Log Miner Scheduler) in STATSPACK indicates that the Log Miner process is waiting for the Log Miner Scheduler to allocate work. This can happen due to a high load on the database or when the log mining process is not configured properly.
| Is This Answer Correct ? | 0 Yes | 0 No |
When should an artificial (or derived) primary key be used?
What is main function of database administrator?
How do you use automatic pga memory management with oracle 9i and above?
As an oracle dba what are the entire unix file you should be familiar with?
When should you increase copy latches?
What does a dba do all day?
What is the main function of database?
If you are not sure what command does a particular unix function what is the best way to determine the command?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
How do you install statspack?
Give one method for transferring a table from one schema to another?
What is dba and functionalities of dba?
Oracle General 
