18.2 was released a few days ago, so I thought I’d throw it against my 18c instance and see how things played out. This was just a single instance database, running with a single pluggable.
If you run TKPROF without arguments, you get a complete list of its arguments with a short description for each of them (here the output generated by version 18.1.0):
One of the potentially cool new features introduced in Oracle Database 18c is the Memoptimized RowStore, designed to improve the performance and scalability of key-value based queries. A new pool in the SGA called the Memoptimize Pool can be configured to store specific heap tables that you may wish to optimize, in a manner not […]
In the past I already shared with you the scripts I use to download the Oracle Database documentation. The aim of this short post is to reference the scripts I just wrote for 18c.
Happy downloading as well as happy reading!
One of the cool things in 18c is the ability to merge partitions without causing a service interruption. Here’s a video demonstration of that in action:
This is just an accompanying blog post to let you grab the scripts for the demo so that you can try this yourself on livesql.oracle.com, or any of the Oracle Cloud services that will be running 18c in the near future.
Yup…it’s arrived!
New name obviously, because we’ve jumped to our new naming model to align with the calendar year as opposed to version number. You might be thinking “So what?” but it’s a significant change in the way we getting software to customer. Mike Dietrich blogged about this at length here so I won’t repeat what has been said, but in TL;DR form:
More frequent releases, with smaller amounts of change per release
In this way, the approach lets us focus more of solidifying existing features, and being able to quickly respond to bugs that arise.
So 18c is more an incremental release on 12.2 (in fact, internally it was referred to as “12.2.0.2” for most of it’s build cycle) focussed on stability and hardening of existing features.
Yeah, if you hadn’t seen that one coming, hmmm, what can I say… Lot’s of…
Performance feedback is one of the adaptive query optimizer features introduced in Oracle Database 12c. The aim of this short post isn’t to explain how it works, but to simply warn you about a buggy behavior in its configuration.
The parameters that control performance feedback in 12c are the following:
So far, so good.
Recent comments
1 year 45 weeks ago
2 years 5 weeks ago
2 years 9 weeks ago
2 years 10 weeks ago
2 years 14 weeks ago
2 years 36 weeks ago
3 years 4 weeks ago
3 years 33 weeks ago
4 years 18 weeks ago
4 years 18 weeks ago