Advanced Oracle DBA Interview Questions and Answers - 1
What is oracle streams?
The oracle streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases.
It provides tools to capture, process (stage), and manage database events through Advanced Queuing Queues
What is streams pool in Oracle 10g?
Streams pool is a part of System Global Area (SGA) from which memory for Streams is allocated if it is configured. It can be configured by specifying initialization parameter, STREAMS_POOL_SIZE.
If the size of the Streams pool is greater than zero, then any SGA memory used by Stream is allocate from the Streams pool.
If the size of the Stream pool is equal to zero, then the memory used by Streams is allocated from the shared pool that may use up to 10% of the shared pool.
What is database change notification?
Database Change Notification is a service that is used to notify the registered clients whenever a change is committed.
List some important streams views?
Following are some important Streams views:
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 which allows you to move capture process to another database is called downstream capture.
Top 1000+ Bank Exams Question Papers with Answers Pdf More
1000+ SBI Computer Awareness Study Material More
Top 1000+ Preposition Questions for SSC Exams More
Preposition Quiz Questions and Answers for Bank Exams More
Computer Awareness Questions Asked in IBPS RRB PO Mains 2021-2022 More
Panchayati Raj Quiz Questions and Answers More
Computer Science Engineering Quiz Questions with Answers More
Current Science and Technology Questions for Competitive Exams More
TNPSC Economics Study Material in Tamil and English Pdf More
Microsoft Word MCQ Questions and Answers More