Answer Posted / balu
exec dbms_stats.gather_table_stats('ownername','tablename')
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
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 is the default fill factor value? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is logical system in sap basis
Query processing is slow(eg select query)how will u solve that
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the steps you will take to improve performance of a poor performing query?
Why would you call update statistics? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the use of recording information about current session?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is dbcc? : sql server DBA