MATERIALIZED VIEW - ARCHITECTURE

 MATERIALIZED VIEW - ARCHITECTURE





Comments

Post a Comment

Popular posts from this blog

Oracle GoldenGate Microservices Architecture - 1

Image
Data Replication techniques has gained importance in the market with the need of maintaing production data in other databases like Postgre, Mysql etc.. to avoid heavy license fee charged by top rdbms providers like Oracle, Sql Server .Goldengate is one of the most famous and popular software which can be used for data replication between homogenous and hetrogenous databases.  GoldenGate supports two types of architectures : Classic Architecture Microservice Architecture CLASSIC ARCHITECTURE It is first architecture supported by the Goldengate when it was introduced 20 years ago. Goldengate Classic architecture drawn many advantages in the market when customers are facing problems when replicating data between heterogenous databases. Classic Architecture has below components: Manager - Is the master process running in the Goldengate which takes care of all other slave                 process like Extract, Datapump, Replicat and Collector....
Read more

All About Oracle Database Block

Image
  INITTrans  Whenever a DML transaction wants to modify a block , it should inform the block by sending 'interested to modify' message to the block .Technically speaking, a dml transaction will always send message to the block , that it is interested to modify the block . This message is stored in ITL slots ,which is preallocated in the block header. Transactions whose entry is there in this ITL slots can only modify the block.This ITL slots are controlled by INITRANS and MAXTRANS values, the inittrans controls the minimum number of slots that will be allocated in the block header. Honestly speaking, the number of ITL slots is equal to number of DML transactions that can happen parallely at one time. Each ITL slot occupies 24 bytes of space in the block. Inittrans values is 1 for table and 2 for index by default. MAXTrans Maxtrans is the maximum number of ITL slots that can be allocated in the block . When the block runs out of this ITL slots and there is enough free space in ...
Read more

ORACLE CLOUD INFRASTRUCTURE(OCI) FOR ABSOLUTE BEGINNER'S

Image
CLOUD CONCEPTS   Today, we will discuss about the Oracle cloud Concepts . Like all the Cloud Technologies, Oracle cloud which is called as OCI offers variety of services with better SLA's and performance.OCI is considered as most robust cloud technology because of its high security and high availability. Lets discuss few cloud basic terms before jumping in to OCI Architecture. On Demand self service -- In cloud, the services are provisioned automatically without human interaction with service provider. Broad network access   -- The cloud services are accessed by broad network which follow standard mechanisms. Resource pooling            -- In cloud, all the services of provider are pooled at one place and this are allocated to multiple customers on their requirement. Rapid Elasticity              -- In cloud , services are scaled up and down automatically and sometimes without any impact to the running env...
Read more