Oracle DBA QuestionsWhat happen when we kill smon?What happen when we kill pmonWhat is fracture block and how to fix itWhat is corrupted block and how to fix itWhat are the oracle threads are going to start ,when we start the databaseHow to check index is working properly ,what are the steps to be taken and on what basis we have to decide particular index has to rebuild not all indexesWhat steps to be taken if receive a call that performance has gone down as DBA what steps has be takenWhat possible error can we able to see in alert fileSudden if performance go down what steps to be taken without using alert file is coz size 3m and we don't want to user alert file how to find the problem and how to fix itIf users are not able to connect database or database is down what preliminary steps to takenWhat actually do in oracle when we take hot backup where actually modified blocks are written?What should be RAM for 50gb database on what basis we have to decide the ramCan we able to connect database using listener instead of TNS namesNormally on daily basis what are the jobs DBA has to do on daily basis?Can we able to create physical standby database using hot backup if yes howIs there is something concurrent user connections are limit if yes how can we increase user connection interview said by using LISTENER FILE If we want to write query how write efficient query and how to make execution plans

Showing Answers 1 - 6 of 6 Answers

ianilreddy

  • Aug 7th, 2010
 

1. When we kill any background processes database will be down.
3. We can find corrupt block using v$database_block_corruption view using
RMAN utility we can solve the problem recover block datafile no block no or recoverblock corruption list;
8.
Snapshot too old error
When we are taking hot backup modified blocks stored in redologs.

  Was this answer useful?  Yes

ashok

  • Aug 30th, 2011
 

When process monitor kills we can't remove locks on tables,

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions