How can you gather statistics on a table?

Question Posted / guest

3 Answers
8661 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can you gather statistics on a table?..

Answer / mkjmkumar

A. If u want to gather statistics with output use
Set Autotrace on
B. IF u want to gather statistics only Without Output user
Set Autotrace TraceOnly

Is This Answer Correct ?

2 Yes

0 No

How can you gather statistics on a table?..

Answer / mkjmkumar

Use
>set autotrace on

Is This Answer Correct ?

1 Yes

0 No

How can you gather statistics on a table?..

Answer / kd

exec dbms_stats.gather_table_stat (owner, tablename);
or
analyze table xxx estimate statiistics;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers jusco,

What is auto invoicing? Explain : oracle accounts receivable

0 Answers

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

0 Answers

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers IBM,

please send me oracle pl/sql exp resume. and also faqs...

0 Answers

What is difference b/w Credit memo and Adjustment in AR.

1 Answers Oracle,

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers Wipro,

what is correlated subquery

3 Answers

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers Polaris,

For more Oracle AllOther Interview Questions Click Here