How can you gather statistics on a table?

Answer Posted / mkjmkumar

Use
>set autotrace on

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1831


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1492


Can we modify approve purchase order?if yes what is navigation?

1547


What is the disk migration? what is the steps involved in oracle disk migration?

719


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

1804






key flexfield structure

1601


What is Tax Categories?

1626


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1545


What is an Oracle database Full Backup?

630


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.

1741


A scenario for amount correction & how to use amount correction functionality in AP invoices

1649


Explain how to close periods in ar. : oracle accounts receivable

707


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1624


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1841


Why more redos are generated when the oracle database is in begin backup mode?

665