A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading the “New Features” guide, so I did. After writing about the major features, here are some smaller ones, but still important enough to know.
If you’ve read my post about 12.2 new features and liked it, you will like this one as well. I’ve recently looked at presentations from OOW16, and found one by Keith Laker from Oracle. Keith, as principal PM for analytic SQL, talked about DWH features in 12.2, and they are great.
I’d like to thanks Keith for uploading the presentation. I will review some of the feature from the presentation, and will only mention the them without a deep explanation. There is a link to the original presentation below.
Lately I wrote a post about 12.2 new features. In the post I didn’t list sharding (probably one of the biggest features in this version), as I wanted to dedicate an entire post for it. In this post I will cover this option , but please note, as 12.2 is only released for the cloud and no one can install it and play with it, all the information is based on presentations I’ve seen at OOW and a chat I had with one of the developers in the demo ground. There might be some inaccuracies or mistakes in the post.
As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool version, the downside is that is currently available on Oracle cloud only. We are all waiting for the on-premise release so we can install and play with it.
I just found out an interesting information regarding Golden Gate license, it seems to include license to full use of Active Data Guard and XStream. Continue reading
This is the post that will complete my Real Application Testing series (for now at least). In this post I’ll talk about the DB Replay.
As I explained before, RAT allows us to perform all kind of tests before making a change to the production database. The first component is the SPA which is a “unit testing” for SQL statements in order to see how the change affects the SQLs. The second component is the DB Replay which I’ll discuss here. Continue reading