Interested to Buy Any Domain ? << Click Here >> for more details...
How can you gather statistics on a table?
- 3 Answers
- 8598 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 |
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the importance of batch source set up in ar? : oracle accounts receivable
Name three advisory statistics you can collect.
types of receipts and detail desription about recipts and tables effected by receipts?
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
Could you please let me know the interfaces in OM / FA??
What background process refreshes materialized views?
what is domain in database and its benefits?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What is the sql query to find the employee who has Nth maximum salary?
Oracle General 
