You see a wait on lms process in statspack, what does that mean?
No Answer is Posted For this Question
Be the First to Post Answer
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?
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?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What are the types of schemas?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
How do you use automatic pga memory management with oracle 9i and above?
How do you prevent output from coming to the screen?
What are the beneficial tools for administering the database?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What are the different types of database users?
What is the dba role in oracle?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?