Answer Posted / guest
We can gather statistics on a table through>>
analyze table TABLE_NAME compute statistics , or
analyze table TABLE_NAME estimate statistics
Regards
Abhinav
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Where would you look for errors from the database engine?
What is dcl? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is fill factor? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What authentication modes does sql server support? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain materialized views and how they are used.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?