Answer Posted / guest

We can gather statistics on a table through>>

analyze table TABLE_NAME compute statistics , or

analyze table TABLE_NAME estimate statistics


Regards
Abhinav

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

1966

---

how can you get actual data change values from previous transactions in oracle?

1076

---

how can you schedule a job in database?

1099

---

What happens on checkpoint? : sql server DBA

1072

---

how can you process messages in order asynchronously?

961

---

Where would you look for errors from the database engine?

2837

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1186

---

What purpose does the model database server? : sql server DBA

1157

---

Which autogrowth database setting is good? : sql server DBA

1135

---

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

2395

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2034

---

when does an alert gets signaled?

1027

---

what do you understand by flashback feature of oracle?

979

---

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.

1978

---

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

2097

---