Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..
Oracle 18c 新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Well.. Oracle 18c.. one release more.. ? Uhmm perhaps not.. Oracle 18c has a that kind of air of.. “Starting now.. it’s when Oracle Cloud Database will mark a real strong beginning..”
I have been playing with Oracle Databases in Cloud from some years ago when all this was barely starting.. when it was more the concept of “Cloud Computing” as a whole.. I’m talking about when the Cloud Computing model was originally designed to be implanted “On-prem”, basically with an arrange of some servers.. software.. resources ( CPU.. Memory.. etc ) and all that could be managed by Enterprise Manager to built your own Cloud infrastructure but “On-prem”, that was around year 2013.. the service of Public Cloud was not still available in that time.. In that time we started to know concepts of “Pay-as-you-go..”.. “Chargeback..” and things like that.. the real concept of that first commercial proposal was really a model of “Cloud Computing”
In that time the concept of Oracle Database Cloud was extreme far from what it’s nowadays.. of course.. the product.. the concept was getting mature.. getting shape..
A couple of years later the first Public Cloud services appeared in the market.. year 2015.. Uhmm.. this was really a more close image of what we were having in mind about Oracle Database Cloud.. of course.. it was product that was changing all time.. and getting mature.. at the beginning even you could not choose the database character set.. the wizard interface had more steps.. and so on.. it was like a child opening his/her eyes to the world.. and we could enjoy how all that was growing..
Little by little more Oracle Database Cloud Services were starting to be available as per we have now:
All these lastly mentioned does not include the future new Oracle Database Cloud Services that will be available starting with Oracle 18c.
So.. continuing with the subject.. Oracle Database Cloud services were still changing/evolving.. even its web interface, pricing model, etc until the last months.. so.. it can be said the product was still modeling itself.. but internally we can consider it already a strong product.
So, according to my point of view, all that was a process to see how the product had interaction with real people.. with real customers.. with real companies.. All that was the preparation way to present finally the king product.. “Autonomous Database Suit of Services on Oracle18c..”, which is a great mix of all learned with Oracle Cloud Database Services and all years making better and better the auto-performance tuning techniques.. ( AWR, ADDM, Advisors.. etc )
So, I consider Oracle 18c and all its new feature a real “before and after” related to Cloud Databases..
Oracle 18c as every release.. has many new features.. that can be suitable for some kind of companies and others not too much.. as always.. perhaps a small company for sure will not be interested in autonomous database running in a powerful Exadata and so on.. Perhaps new “Startup” companies could be very interested in the regular “Oracle Database Cloud Service” to have a cheap and fast IT infrastructure.. not thinking as before how costly could be to establish an own data center.. etc..
So, the point it’s.. Oracle 18c as every release has new features for everyone..
The objective of this article is to name/to introduce them briefly before we can get the real production release starting December 2018.
Then, Let’s talk briefly technically of What’s news in Oracle Database 18c..
The figure you will see now is the Lifetime Support Commitments and Plans for current and future Oracle Releases.
*Oracle Database 19c is expected to the long term support release.
Always check MOS Note 742060.1 for the latest schedule.
As you can see between all that information, we will have extended support of 12.2 until 2025 and Oracle 18c will start on December2017. There are a lot of people in fear for the future for DBAs related to Autonomous Database & Oracle 18c, if you want to read my point of view about that subject go here:
#10 Oracle 18c: “Oracle 18c and its impact on DBAs”
Now, Let’s highlight briefly some of what we have today and what we will have in Oracle Database 18c
Performance
Today:
Oracle Database 18c:
Low Latency Memory Transactions
Non Volatile Memory Support
In-Memory Column Store Improvements
Memory Optimized Access for OLTP Workloads
Example: Read Joel’s Balance
Ultra-Fast key-based lookup:
New low latency client protocol with direct access to data engine
Performance benefits:
Memory Optimized Access for IoT Workloads
Example: Write Temperature Reading
New streaming ingest:
Performance:
2x faster throughput than conventional
Multitenant
Today:
Container managed database virtualization
Manage Many as one
Software as Service
Oracle Database 18c:
Example of
RMAN
https://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/
Oracle Data Guard
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
RAC
Availability
Today:
Comprehensive HA and disaster recovery functionality
Oracle Golden Gate for heterogeneous replication
Scale out and fault isolation with Oracle Database Sharding
Oracle Database 18c:
Zero Impact Grid Infrastructure Patching
Sharded RAC
Sharding improvements
Sharded RAC
Higher performance for shard-aware RAC applications
Affinitizes shards to RAC instances
Requests that don’t specify sharding key still work transparently
Gives Sharded Database performance with minimal application changes
Security
Today:
Security In-Depth
Key Vault
Audit Vault Database Firewall
Security Assessment Tool
Oracle Database 18c:
Integration with Active Directory
Per PDB Key storage
Password-less schema creation
Data Warehousing and Big Data
Today:
The most advanced analytics engine available today
Easily analyze data held in Hadoop with Big Data SQL
Big Data Appliance
Oracle Database 18c:
In-Memory for external tables
Automatic propagation of nologged data to standby
More Machine Learning algorithms
Polymorphic Table Functions
Alter Table Merge Partition Online
Approximate Query Improvements
Development
Today:
Application Express 5.1
SQL Developer & SQLCl
Comprehensive Language support
JSON
Oracle Database 18c:
Improved JSON Support
Property Graph Improvements
Rolling patches for OJVM
Private Temporary Tables
Private Temporary Tables
Transient tables useful for reporting applications
Global temporary tables
Persistent, shared (global) table definition
Temporary, private (session-based) data content
Private temporary tables (18c)
Temporary, private (session-based) table definition
Temporary, private (session-based) data content
Database Instance Management REST API
List the pdbs in the exadata database container: https://myserver.mydomain.com/ords/databases/exadata/pdbs
Official Docker Support
Oracle Database is fully supported on Docker for
** Oracle RAC is not supported on Docker “CURRENTLY” but in Oracle 18c Oracle RAC support is coming
MOS Note: Oracle Support for Database Running on Docker (Doc ID 2216342.1)
Oracle 12.2.0.1 & 12.1.0.2 images are available on Oracle Container Registry
Docker build files also available at
New Installation Approaches
Zip file, TAR File, Docker Image, Virtual Box, VM (Ravello, BMC, Vbox)
Oracle Installation via RPM
Oracle Database 18c XE
If you want to be updated with all our articles send us the Invitation or Follow us:
Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
or Join our LinkedIn group: Oracle Cloud DBaaS
Follow us in Enmotech LinkedIn Page: https://www.linkedin.com/company/1856106/
Author Bios:
Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com
Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
About the author