Oracle Dba Interview Question and Answers
56. |
What is the use of Oracle Cluster Registry(OCR)? |
|
OCR stores information about cluster resources and their configuration. The CRS process uses that information to manage resources. |
|
|
57. |
What are the different types of connection load balancing? |
|
There are two types of connection load balancing are : - Server side load balancing
-
Client side load balancing
|
|
|
58. |
What is downstream capture? |
|
Generally, capture process functions at source database. However, if you want to save resources at the source database, you can set up another database for the capture process only. The feature, allows you to move capture process to another database, is called downstream capture.
|
|
|
59. |
What is system change number? |
|
SCN is an ID that Oracle generates for every transaction. It is recorded with the corresponding change in a redo entry. |
|
|
60. |
What is an SID? |
|
The SID is the system identifier. This environment variable is used to determine which database to connect to. |
|
|