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.

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

wat is global index and local indes

1 Answers   Oracle,

---

what is incremental checkpoint?

1 Answers   CTS,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

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

3 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---