Answer Posted / balu

exec dbms_stats.gather_table_stats('ownername','tablename')

internal architecture

2141

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2365

---

what is asm?

995

---

what do you understand by flashback feature of oracle?

947

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2017

---

What the different types of replication and why are they used? : sql server DBA

1104

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1915

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1013

---

Can you redefine a table online?

1059

---

What types of replication are supported in sql server? : sql server DBA

1224

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2186

---

what is a user-defined lock?

984

---

how to restore files with rman?

2236

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1944

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3697

---