Topic : Distributed Databases

Daily Activities of a Oracle DBA?


Answer :

1. Check the Databse availability
2. Check the Listerner availability
3. check the alert log filie for errors
4. monitoring space availablilty in tablespaces
5. monitoring mount point (see capacity planning document)
6. Validate Database backup or Archive backup
7. Find objects which is going to reach max extents
8. Database Health check
9. CPU; Processor; Memory usage

Show Answer Discuss

What are the benefits of distributed options in databases?


Answer :

Database on other servers can be updated and those transactions can be grouped together with others in a logical unit.
Database uses a two phase commit.

Show Answer Discuss

What is Distributed database ?


Answer :

A distributed database is a network of databasesmanaged by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.

Show Answer Discuss

What are the benefits of distributed options in databases ?


Answer :

Database on other servers can be updated and those transactions can be grouped together with others in a logical unit. Database uses a two phase commit.

Show Answer Discuss

What is Two-Phase Commit ?


Answer :

Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase; a Prepare Phase and a Commit Phase.

Show Answer Discuss