How can you gather statistics on a table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the payment term in ar. : oracle accounts receivable

844


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

987


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1966


8. Supporting AP, AR and GL?

2034


What view would you use to determine free space in a tablespace?

1999


What do you mean by hz_ in customer tables? : oracle accounts receivable

855


What is db_recovery_file_dest in oracle? When do you need to set this value?

879


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

2373


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.

1946


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2128


what is semphore explian it?

2472


What is Restricted Mode of Instance Startup in Oracle?

893


as a technical developer in oracle applications which type errors feced in your experience sofar

2098


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1893


Explain prerequisites and post activities of oracle database installation

1876