Oracle Database 19c Features

Dear DBA-Mates,

We would like to share one of most important information as all the customer are upgrading to 19c.

Hope his will be useful as reason why we need to upgrade 19c database from previous version of database specially 12c which I am seeing/doing. So be Ready!!!

Reasons to upgrade 19c:

1.Oracle lifetime support policy only follows their latest version

2. OS compatibilities as per DB versions

3. Security purpose as compared to old version. 

Some Older version History:

12c (2014): Oracle designed to work on the Cloud, the most notable features are the pluggable databases and multitenant architecture.

 

18c (2018): autonomous database, this self-driving database is self-securing and self-repairing, available for the Oracle cloud or on-site premises.

 

19c (Jan 2019): will be supported through 2023, extended till 2026.

latest version-19.3

 

Oracle Version 19C

The latest Oracle version, the 19C, was released in early January 2019. It's been noted as the long- term release for the 12.2 product family of Oracle databases. This particular version will be supported through 2023, with extended support available until 2026.

 

Some of the newest features in the 19C release include:

Query Quarantine -

Unlike with previous Oracle versions, 19C solves the problem of overloading system resources with query requests. This version provides automatic query quarantine to ensure that specific queries aren't running over and over.

 

JSON Support -

This version has simplified the syntax for JSON functions and allows users the capability to do partial updates of JSON. In addition, it provides SODA APIs for Node.js, C, Python, and Java.

 

Automatic Indexing -

19C offers a machine learning algorithm feature that provides constant index adjustment. This algorithm leads to enhanced system performance and more cost savings. After just a short amount of use, this database version will build indexes that allow for more efficient plans for each dataset.

 

Hybrid Partitioned Tables -

This 19C feature permits database administrators to manage tables both inside and outside the database with ease. The partitions inside the database can easily be managed alongside partitions that are in read-only data stores outside of the database on the premises or on the Cloud.

 

Active Data Guard -

This new feature works to prevent downtime and data loss during database repairs and upgrades. It allows for incidental updates to be run while a synchronized physical replica or standby is maintained.

Some more useful link:

How to change database DB name using NID utility

Stuck Thread in WebLogic Error and solution

What is PDB and CDB in oracle 12c

ORA-01110 data file 1: system01.dbf recovery

Cloud Service Models in cloud computing

Dear DBA-Mates,

As per last commitment/promises, we are back with next topic Cloud Service Models.

Here, we would like to explain it in simple and short notes for quick references. This is one of the basic and important which should be clear for any cloud concepts. So, tried to clear in simple ways, hope this will be useful for all.

Cloud Service Models:  Means the Services provided by the Cloud companies.

Please find the below main Cloud Service Models:

1.   IaaS: Infrastructure as a service

In this Service model, we will get infrastructure template by cloud provider company and remaining management, configuration part will be taken care by the clients.

Eg. in aws:  EC2 -- virtual machine (only this will be provided by Cloud provider with resources as per demand)

We Manage: Data, Apps, Runtime, Middleware, O/S.  (Total is 5)

Provider Manage: Virtualization, Server, Storage, Networking.  (Total is 4)

 

2.   PaaS: Platform as a Service

In this Service model, Cloud provider company will provide configured platform and client only need to deploy their apps, codes etc…

We Manage: Data, Apps (total is 2)

Provider Manage: Runtime, Middleware, O/S, Virtualization, Server, Storage, Networking. (Total is 7)

 

3.   SaaS:  Software as a Service

In this Service model, Cloud service provider company will provide direct software to use. Client/user will use direct software through internet from anywhere in the world.

In Shorts:

Ready to use software. -- We will only login on internet and will use apps.

Example: Gmail, Facebook etc... web software, web services in software form.

We Manage: Data (total is 1)

Provider Manage: Apps, Runtime, Middleware, O/S, Virtualization, Server, Storage, Networking. (Total is 8) 

Some other Services model:

4. Database model:

In this model service provider will install database and provide services

5. Storage Models etc...

6. Data Models

Some more useful link:

How to improve oracle database performance tuning

R12.2 Adop Phases in Oracle EBS

How to change sysadmin password FNDCPASS in R12.1.3

ADADMIN, ADCONFIG and ADMRGPCH

AD Utilities for Oracle Apps DBA

AWS Cloud Computing Concepts

Dear DBA-Mates,

As we all are knowing that cloud is hot in market in which AWS is one of the most important. So, I would like to share some important knowledge in short and easy way which can be learn in short time and will help in career.

So, let’s start and grow together!!!

Cloud Computing:

Suppose, we have to start any business then we have to setup an infrastructure and then we need Human power to manage that infrastructure.

Also, here infrastructure like servers where you can develop your software and test your software which was very costly and everyone was not able to effort it.

Earlier disadvantages:

1. More expenses for setup and resources

2. Less time to focus on business.

 

For example: If you have to open a shop then you have to buy land then build room/house which is very costly and everyone can't effort.

So, people take shop on rent and they run their business.

Same way cloud also works here...

 

Here, Computation means calculation.

Cloud computing example like Electric Supply -- You pay what you use.

We can use scale-up and scale-down means resources can be increase or decrease as per requirements.

Cloud Computating:

It enables on-demand services like compute, storage, networking etc... which needs to develop and deploy a software and can be access through internet in the world anywhere.

Features:

Scalable, Pay as You use, Flexible, Cost Effective, smooth services,

Secure and Disaster Recovery. (It depends how you want manage with permissions and access.

It's up to you how much access/permissions you want and how much you to give to providers).

Cloud Service Models <<click here

Some more useful links:

What is PDB and CDB in oracle 12c

SQL Tuning Advisor steps and details

How to change database DB name using NID utility

TKPROF Concepts with Syntax and Real time example