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 would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

What is the dataguard background process??

1 Answers   iGate,

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

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 purpose does the model database server? : sql server DBA

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---