Answer / braj123

--> use VMSTAT to check the cpu enqueues.
--> also use top and sar commands for cpu load.

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

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  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

Describe what redo logs are.

1 Answers  

---