As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
Answer Posted / irimi
DBCC commands are most useful for performance and troubleshooting
PROCCACHE
SHOW_STATISTICS
TRACESTATUS
SHOWCONTIG
....
| Is This Answer Correct ? | 0 Yes | 0 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
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the recovery models for a database? : sql server DBA
How do you open a cluster administrator? : sql server DBA
how can you connect from 10g user to 11g user??
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what is asm?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what is a user-defined lock?
Where would you look for errors from the database engine?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the difference between clustered and non-clustered index? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA