Below are some interesting conceptual points regarding Oracle Multitenant CD-PDB Architecture which can prove useful for DBA who is new to Oracle multi-tenant architecture. This…
Leave a CommentExpert Oracle Posts
Cassandra is a distributed database system and it runs on multiple nodes at once. The nodes use a peer-to-peer communication protocol to exchange any information.
Some key points regarding Cassandra architecture/functioning:
- Table rows are stored in tables, each with a mandatory primary key
- Data gets first written to log file for durability and then somewhat similar to RDBMS databases, write the data to cache and when cache is full it write the data finally to disk
- Automatically partition the data and replicate it.
- At regular interval, it compacts the data in the database
- Cluster nodes are chosen randomly to fetch the data as per client need
Leave a Comment
Oralce/MYSQL database administrators are well aware of term named ACID
ACID stands for: Atomicity, Consistency, Isolation, Durability and it is at the foundation of RDBMS success.
ATOMICITY: If one part of transaction fails, the entire transaction will fail to maintain integrity of database
CONSISTENCY: Database will always be in a consistent state both at the beginning and at the end of a transaction
ISOLATION: No transaction has access to any other in-flight/unfinished transaction
DURABILITY: Database records the transaction in persistent storage/data files when it completes. Power/disk failure will not impact the completed transaction.
Leave a Comment
The word Cassandra was taken from the name of ancient Greet prophet Cassandra.
Apache Cassandra is a distributed NoSQL database system. It is a distributed database system. It is NOT RDBMS system like Oracle. It is NoSQL database.
High availability and linear scalability are some key benefits of Cassandra database. Cassandra is designed for high-volume, low-latency cloud applications.
Leave a Comment
As they say “Necessity is the mother of invention”. There would have been no RDBMS kind of databases like Oracle if there was no computers.
Similarly there would have been no need of NoSQL kind of databases if there was no Internet explosion, no Facebook/social media, no cell phones etc. etc. All these new “trends” generated such huge data at such fast pace that RDMBS was simply not able to cope up. NoSQL helped in solving this problem of this new/huge/versatile/fast generating data.
Leave a Comment
To organize your Oracle Cloud resources you will create couple of compartments. Your goal of creating compartment is to have ease of management, security, isolation of resources.
When your tenancy is provisioned, a root compartment is created for you. Your root compartment holds all of your cloud resources.
Before we plan to create a new compartment under our root compartment we should understand some key points and best practices related to compartments.
Some key points that you keep in mind related to compartments are:
Leave a Comment
Let us look at the Oracle Cloud Console in this post. Go to https://cloud.oracle.com/en_US/tryit and sign up for the Free Oracle Cloud Promotion. Please note you will need to add your credit card number but it will not be charged. There is no charge unless you choose to “Upgrade to Paid” from “My Services” console page.
Once your trial account is created you will become a tenant in Oracle Cloud Infrastructure. Oracle will send you a Welcome email which will have userid/password detailed to login to your “tenancy”.
Oracle Cloud Infrastructure supports the latest desktop versions of Google Chrome, Microsoft Edge, Internet Explorer 11, Safari, Firefox, and Firefox ESR. Note that private browsing mode is not supported for Firefox, Internet Explorer, or Edge. Mobile browsers are not supported.
Leave a Comment
Cloud infrastructure is the most basic products delivered by cloud computing companies through the infrastructure as a service (IaaS) model. You can create your own IT infrastructure complete with processing, storage and networking resources. Cloud Infrastructure companies provide you flexibility in infrastructure design so these infrastructure setups can be easily set up, replaced or deleted as opposed to a physical one, which requires manual work.
Leave a Comment
This post will cover the SQL Tuning Health Check script basics and how you can use it to collect the key information regarding a poorly performing SQL. SQLHC helps you on focusing on specific SQL and checking Cost-based Optimizer (CBO) statistics, schema object metadata, configuration parameters and other elements that may influence the performance.
Unlike SQLT, this tool SQLHC do not require any code to be installed in the database to provide recommendation. SQLHC uses the SQL_ID of a statement that has already been executed and is in memory to generate the report so it do not actually execute the SQL all lover again. SQLHC works 10g and above. SQLHC is also RAC aware
6 CommentsBlock corruptions are one of the common source of database outages. A database block is corrupted when its content has changed from what Oracle Database expects. Correcting block corruptions can prove to be a lengthy and costly exercise and requires good expertise 0n the DBA part.
Block Corruption can happen at Logical level or Physical level. Also, such corruption can impact a single block or huge number of blocks in the database.
5 Comments