Below is some basic information on how database level parameters are managed between CD and PDB databases in Oracle multitenant architecture: Changing parameters for CDB…
Leave a CommentAuthor: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
Below script can be used to get details of running concurrent requests in your Oracle EBS environment. It gives all useful details from V$SESISON too.
1 Comment From the user and application perspective, the data dictionary in each container in a CDB is separate, as it would be in a non-CDB.
For example, the DBA_OBJECTS view in each PDB can show a different number of rows. This dictionary separation enables Oracle Database to manage the PDBs separately from each other and from the root.
Leave a Comment
Oracle Multitenant database can provide few good benefits if we plan carefully and specially by having a non-traditional approach. In the starting it may seem intimidating to the seasoned DBAs as this architecture need some learning and practice. Few of the key benefits which Oracle describes are mentioned below:
Leave a CommentThe multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).
This feature is available in Oracle Database 12c or later releases so you must install or upgrade to Oracle Database 12c or later releases. The database compatibility level must be set to 12.0.0 or later to utilize the multitenant feature.
Leave a Comment
AWS uses public–key cryptography to encrypt and decrypt login information.
Using Public–key cryptography, AWS process will encrypt the data and then the recipient uses the private key to decrypt the data.
The combination of public and private keys are known as a key pair. You will use this key pair to securely access your instances using a private key. You can create a key pair using the Amazon EC2 console or the command line. After you create a key pair, you can use it when you launch your instance.
Steps to create key pair are straight forward.
Continued from the previous post..
More key AWS services are listed below:
STORAGE
Amazon Simple Storage Service (Amazon S3)
- object storage service that offers scalability, data availability, security, and performance
- can use it to store and protect any amount of data for a range of use cases, such as websites, mobile applications, backup and restore, archive, enterprise applications, IoT devices, and big data analytics.
- designed for 99.999999999% (11 9’s) of durability, and stores data for millions of applications for companies all around the world.
Leave a Comment
There are simply so many AWS services that it is not possible to put all in this post so we will focus on the key AWS services which are used more frequently.
Every year AWS add more new services to its portfolio. AWS services can be categorized into various key categories:
COMPUTE
Amazon EC2
- web service that provides secure, resizable compute capacity in the cloud
- allows you to obtain and configure capacity with minimal friction
- reduces the time required to obtain and boot new server instances (called Amazon EC2 instances) to minutes, allowing you to quickly scale capacity, both up and down, as your computing requirements change.
- pay only for capacity that you actually use
- EC2 instance types:
Few more terms and discussion topics specific to Amazon Web Services (AWS) are listed below:
AWS Regions
Simply put a physical location in the world where AWS has Availability Zones
AWS Availability Zones
- Availability zones are part of a region
- Availability Zones consist of one or more separately located data centers, each with redundant power, networking, and connectivity, housed in separate facilities.
- So if you want to make your application highly available then plan to distribute among different availability zones
Leave a Comment
There are some common terms and topics which are true/applicable for any cloud based vendor. Below we will discuss some of these terms in simplest form.
Cloud Computing
Computing when used as a Noun means “the use or operation of computers”
Cloud in the technological term means some location away from your premise. Your premise is termed as “on-premise”
So, roughly speaking, the definition of “Cloud Computing” can be => “The use or operation of computers (servers, storage, network components etc.) which are stored somewhere else”
In more sophisticated language, Cloud computing is the on-demand delivery of compute power, database storage, applications, and other IT resources through a cloud services platform via the Internet with pay-as-you-go pricing
Leave a Comment