Answer / kd

buffer busy wait indicates that there are some buffers in
the buffer cache that multiple processes are attempting to
access concurrently.

General goal is to reduce total I/IO on the system by:
DBWR contention tuning.
Implementing ASSM.
Adding freelists to table and index.
Tuning sql to access rows with fewer blocks reads by adding
indexes.
select * from v$waitstat

Is access a database?

0 Answers  

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

---

What is field in database give an example?

0 Answers  

---

What is the use of ROWS option in IMP command ?

1 Answers  

---

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers  

---

How to change database dialect?

0 Answers  

---

What is stored in a database?

0 Answers  

---

How does a database partition work?

0 Answers  

---

where a Database Procedure is stored ?

1 Answers  

---

What is the best database software?

0 Answers  

---

Is google a database?

0 Answers  

---

What is the example of rdbms?

0 Answers  

---