Answer / daid kumar

We find the Information from V$SYSSTAT
And for Increasing The Hit Ratio we hav eto incraese the
Size Of SGA. by Alter System Command and also In init.ora
file

Answer / abul kasam topon

we can set db_catch_size using alter system command with
scope spfile sid='x';

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

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

0 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 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  

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---