Interested to Buy Any Domain ? << Click Here >> for more details...
How can you gather statistics on a table?
- 3 Answers
- 8913 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / kd
exec dbms_stats.gather_table_stat (owner, tablename);
or
analyze table xxx estimate statiistics;
| Is This Answer Correct ? | 0 Yes | 0 No |
What does coalescing a tablespace do?
Could you please let me know the interfaces in OM / FA??
what is sql*loader parameters and where we will use it.
what is different between inline query,subquery& corelated query?
how to create an user in oracle 10g.please give me an example..
Why more redos are generated when the oracle database is in begin backup mode?
How would you go about increasing the buffer cache hit ratio?
What type of index should you use on a fact table?
how can it possibble to see the report output in excel sheet in oracle applications
How can you gather statistics on a table?
What is auto invoicing? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Oracle General 
