Oracle Database 19c: The best upcoming features..!!
By Rodrigo Jorge
Hi Readers
In the Oracle Open World 2018 event that happened in San Francisco last week, from October 22nd to 25th, much has been said about the trends and strategy paths that Oracle is taking in both OCI and in Oracle Database.
As we DBA’s are always excited about the upcoming features, We will share below some of the main things that I’ve spotted on OOW. Please note that this can change, and we don’t even have a beta release yet.
First of all, it was very clear that Oracle’s main focus for the 19c database will be stability. This will be the final release for the “12cR2” family. So it was repeated multiple times: “don’t expect to see many new features in this release“, what in my opinion is really great.
Since 12.1.0.1, Oracle has been implementing a lot of core changes in Oracle Database (like multi-tenancy, unified audit, etc) and it’s still very hard nowadays to find a stable 12 release to recommend. 12.1.0.2 is my favorite one, however many bugs are unfixed and it lacks a secure PDB layout (PDB escape techniques are pretty easy to explore). 18c will probably be ignored by all as it was a “transition” release, so I hope that 19c becomes the real stable one, as 11.2.0.4 was for 11g release family. Let’s see…
This is indeed the most important and one of the coolest features I’ve even seen in Oracle DB. Once this kind of automation is implemented and released, it will open doors to many other product automations (like automatic table reorganization, automatic table encryption or anything you can imagine).
The automatic indexing methodology will be based on a common approach to manual SQL Tuning. Oracle will capture the SQL statements, identify the candidate indexes and evaluates the ones that will benefit those statements. The whole process is not something simple.
Basically, Oracle will first create those indexes as unusable and invisible (metadata only). Then, outside the application workflow, oracle will ask the optimizer to test if those candidate indexes improve the SQL performance. In case the performance is better for all statements when indexed is used, it will become visible. If performance is worse, it remains invisible. And if it only performs better for some statements, the index is only marked visible for those SQLs (via SQL Patch, maybe).
The automation will also drop the indexes that become obsoleted by the newly created indexes (logical merge) and also remove the indexes that were created automatically but have not been used in a long time. Everything is customizable. For more details, we need to wait for the Beta Release!
to read the rest of the article, click here:
We hope the content could be useful for your Oracle DBA Tasks!
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/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c) Released..!!
Hi Readers
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c) was released on October 19, 2018. To download, follow this link:
Steps to install..!
https://oracle-base.com/articles/18c/oracle-db-18c-xe-rpm-installation-on-oracle-linux-6-and-7
We hope the content could be useful for your Oracle DBA Tasks!
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/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Generate SSH Key Pairs to Access Oracle Linux instances in the Oracle Cloud Infrastructure..!!
Hi Readers
Introduces Secure Shell key pair generation and demonstrates how to generate a SSH key pair to use when remotely connecting to Oracle Cloud Infrastructure instances.
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Can two Oracle sessions be blocked when accessing DIFFERENT rows.. ?..!!
By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
By Connor McDonald @connor_mc_d
Hi Readers
MERGE is a great SQL command to capture both update and inserts in a single command. But how to diagnose and solve the problem when MERGE crashes with “ORA-30926: unable to get a stable set of rows in the source tables” And what the hell is a “stable set of rows” anyway ?
to watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
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/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Replication Done Right..!!
Whether it is a cloud, an on-premises, or a hybrid environment, the question asked most often is “What is the right solution to protect my data from failures – with the least amount of downtime and data loss?” Well, one choice that comes to mind is to replicate the data to another physical site. This means all the data changes are physically copied to a remote location using some application-agnostic replication technology. You can then activate the remote site in the event of a primary failure. So far so good. Which means “replication” is the solution which fits the bill. The default replication choice is to just replicate all the changes happening to the data at the storage level. Simple enough. Right?
Not really. For most common deployments using generic storage-based replication, the replication simply stops at the storage level. It never gets deeper. When the replication happens at the block level, the storage system has no clue about the type of data it is replicating. It just replicates whatever you throw at the storage, faithfully. There is both a good and a really bad aspect to this method.
Peeling back some layers you will find that you opened a big can of worms. To start with, what if you accidentally delete a file? Guess what, that deletion gets replicated and the file is lost in the remote site too. What if there is a logical corruption on your production database? That too gets replicated faithfully. What if you want to offload your read-only analytical queries or reporting to the remote site while the replication is going on? Good luck with that, as mirrored copies of data are ‘dark’. The point is, while application agnostic storage replication seems to be easy, it just adds complexity when replicating databases that store your mission critical data.
To look at it in another way, take the database server as an example. The IO changes in the memory usually traverse through various layers – from memory to HBA to a storage switch to a storage controller and finally to an actual disk. All pieces of the stack have their own firmware. A software bug or any issue with any component in the stack can result in data corruption – which the storage is not aware of and it does not care about either. The corrupted data is replicated. I am not making this up, but there are real-world use cases. See the following:
to continue reading the article, click the link down below:
https://blogs.oracle.com/maa/replication-done-right
We hope the content could be useful for your Oracle DBA Tasks!
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/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Flashback Database and Archived Redo..!! By Connor McDonald @connor_mc_d
By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
