How can you gather statistics on a table?

Question Posted / guest

3 Answers
17677 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can you gather statistics on a table?..

Answer / santosh

you can use dbms_stats package

Is This Answer Correct ?

19 Yes

3 No

How can you gather statistics on a table?..

Answer / guest

We can gather statistics on a table through>>

analyze table TABLE_NAME compute statistics , or

analyze table TABLE_NAME estimate statistics

Regards
Abhinav

Is This Answer Correct ?

12 Yes

1 No

How can you gather statistics on a table?..

Answer / balu

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

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More DB Administration Interview Questions

Explain the use of table functions.

1 Answers

how can you create a user-defined lock?

0 Answers Oracle,

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

What is the importance of a recovery model? : sql server DBA

0 Answers

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

How can we see the database version in os level

6 Answers Oracle,

Can you redefine a table online?

0 Answers Oracle,

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

For more DB Administration Interview Questions Click Here