1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?

Question Posted / guest


As a part of your job, what are the DBCC commands that you commonly use for database maintenance?..

Answer / 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

More DB Administration Interview Questions

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

How would you go about increasing the buffer cache hit ratio?

2 Answers  




what is asm?

0 Answers   Oracle,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

Name a tablespace automatically created when you create a database.

5 Answers  

For more DB Administration Interview Questions Click Here
Categories