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
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what do you understand by flashback feature of oracle?
What is dbcc? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what are the benefits of flashback feature?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what do you understand by fine-grained auditing?
What happens on checkpoint? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What is dcl? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the last version,the release date of that version and fix pack of ibm db2 udb?