Interested to Buy Any Domain ? << Click Here >> for more details...
How can you gather statistics on a table?
- 3 Answers
- 8727 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 |
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
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.
What is auto invoicing? Explain : oracle accounts receivable
When a user process fails, what background process cleans up after it?
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
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.
What view would you use to look at the size of a data file?
how to write customizations in po
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
what is the difference between oracle 81,91,11i
Oracle General 
