Answer Posted / b.r.reddy
We can manually set the statistical values.
We can gather statistics in parallel mode.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
how can you get actual data change values from previous transactions in oracle?
What the different components in replication and what is their use? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How would you extract DDL of a table without using a GUI tool?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the default fill factor value? : sql server DBA
What is dcl? : sql server DBA
how can you schedule a job in database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What authentication modes does sql server support? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you implement fine-grained auditing?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.