As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 3293 Views
- IBM, I also Faced
- E-Mail Answers
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
what is the use of ocr?
Query processing is slow(eg select query)how will u solve that
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
when does an alert gets signaled?
How do you open a cluster administrator? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is grd?
What is fill factor? : sql server DBA
Explain materialized views and how they are used.
What types of replication are supported in sql server? : sql server DBA
what is asm?
internal architecture
What are the commands used in dcl? : sql server DBA
how can you enable flashback feature?
How would you best determine why your MVIEW couldn't FAST REFRESH?
