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

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

Question Posted / guest

1 Answers
4263 Views
IBM, I also Faced
E-Mail Answers

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

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

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

2 Answers

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

how can you schedule a job in database?

0 Answers Oracle,

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers

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

1 Answers

Give two methods you could use to determine what DDL changes have been made.

2 Answers

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers

what do you understand by flashback feature of oracle?

0 Answers Oracle,

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

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

0 Answers

What view would you use to determine free space in a tablespace?

3 Answers

For more DB Administration Interview Questions Click Here