Answer / braj123

1.By using statspack report find buffer busy wait events.

2.>select * from V$system_event where event like '%wait%';

3.>select * from v$waitstat;

Solutions:
* Identify and eliminate hot blocks from the application
via changing the PCTFREE and PCTUSED values to reduce the
number of rows per data block.
* Each instance has its own freelist groups.
* Increase the number of rollback segments.

how can you enable flashback feature?

0 Answers   Oracle,

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---