How can you gather statistics on a table?

Question Posted / guest

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?..

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

Is This Answer Correct ?

0 Yes

0 No

More Oracle AllOther Interview Questions

i have marks in table,how to find total?

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

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

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

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

Give the two types of tables involved in producing a star schema and the type of data they hold.

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

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

What background process refreshes materialized views?

For more Oracle AllOther Interview Questions Click Here