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



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

Answer / 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

More DB Administration Interview Questions

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,


I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  


What are the operating modes in which database mirroring runs? : sql server DBA

1 Answers  


how can you initialize log miner?

1 Answers   Oracle,


What view would you use to look at the size of a data file?

3 Answers  


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  


how can you enable flashback feature?

1 Answers   Oracle,


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


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

1 Answers   IBM,


Explain CREATE DATABASE syntax?

2 Answers  


Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1 Answers  


Categories