How can you gather statistics on a table?
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 command would you use to create a backup control file?
What is auto invoicing? : oracle accounts receivable
What Are Cross Validation & Adi?
what are the tools used for oracle 10g in real time.
Explain the difference between a data block, an extent and a segment.
can u give guidance abt packages of plsql
What does coalescing a tablespace do?
What is $FLEX$ and $PROFILES$?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is supporting issues GL AP and AR?
statement string in open is null or 0 length ORA-40735
How can you enable a trace for a session?