As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 3481 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 do you understand by flashback feature of oracle?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Explain materialized views and how they are used.
How would you go about verifying the network name that the local_listener is currently using?
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?
how can you implement fine-grained auditing?
What the different components in replication and what is their use? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what are the benefits of flashback feature?
What is a correlated sub-query? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is dbcc? : sql server DBA
what is the diffrence between core dba and apps dba?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
