What's the benefit of "dbms_stats" over "analyze"?

Question Posted / narmada kumari

What's the benefit of "dbms_stats" over "analyze"?..

We can manually set the statistical values.
We can gather statistics in parallel mode.

Is This Answer Correct ?

4 Yes

2 No

More DB Administration Interview Questions

What does coalescing a tablespace do?

What is a correlated sub-query? : sql server DBA

i had backup last manday.now i need back monday to now ..how do get backup?

Give two examples of how you might determine the structure of the table DEPT.

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

what are the types of connection load-balancing?

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

What are the different ways of moving data or databases between servers and databases in SQL Server?

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

Where in the Oracle directory tree structure are audit traces placed?

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Which dictionary tables and/or views would you look at to diagnose a locking issue?

For more DB Administration Interview Questions Click Here