Answer Posted / santosh
you can use dbms_stats package
Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
what is the use of recording information about current session?
What are the different sql server versions you have worked on? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
what is a crs resource?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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
what is the use of ocr?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Can you redefine a table online?
What would you do with an "in-doubt" distributed transaction?
how can you create a user-defined lock?
what are the differences of where and if in SAS?
internal architecture
what is grd?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA