Interested to Buy Any Domain ? << Click Here >> for more details...
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 4366 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
how can you enable flashback feature?
How would you extract DDL of a table without using a GUI tool?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you connect from 10g user to 11g user??
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is dcl? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is fill factor? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
