In today’s video we give a demonstration of Simple Oracle Document Access (SODA) for SQLcl. SODA is a feature of Oracle REST Data Services (ORDS), but this allows to access the document store directly from SQLcl.
In today’s video we give a demonstration of Simple Oracle Document Access (SODA) for PL/SQL. SODA is a feature of Oracle REST Data Services (ORDS), but this PL/SQL interface for SODA was introduced in Oracle Database 18c.
The star of today’s video is the son of Dan Iverson. Dan, not his son, is an Oracle ACE focusing on PeopleSoft and Oracle Cloud Architect. He’s also in Army National Guard, which means he’s already prepared for the zombie apocalypse! 🙂
I wanted to try something with Oracle 18c Data Guard, so I thought I might as well create a hands-off build of it using VirtualBox and Vagrant, much as I did with my recent hands-off RAC build.
I did the 18c build and figured I might as well do 12cR2 and 12cR1 builds too, as they were pretty similar. I could have done them as a single build with a few tweaks to sort out the differences, but I couldn’t be bothered. 🙂
Having played around with Flashback Data Archive in 11g, I figured I would get through the 12c enhancements pretty quickly. I didn’t account for the fact I’m a donkey and can’t see the wood for the trees. Luckily, I know some people who aren’t stupid and they gave me a nudge in the right direction, allowing me to spot my silly mistake. Thanks Bjoern and Connor! 🙂
So after lots of wasted time, here is the article.
For the most part, it’s an evolution, but the new bits are pretty darn cool. I guess a lot of people will focus on two main things:
It is now a free feature, provided you don’t use compression, available in all versions. The change to use no compression by default has been back-ported to 184.108.40.206, so it’s free there too, which is nice!
The contents of contexts can now be stored in the flashback archive, so you can have access to the USERENV and custom context values that were set in the session when the DML was processed. This makes it possible to replace all those crappy old audit triggers with FDA!
There’s some other stuff in there that’s kind-of nice too. I think it’s worth checking it out, especially at its new price. 🙂
I’ve spent the last few weeks in discussion with Vodafone about what I believe is a scandalous bill for roaming data charges. Vodafone agreed to reduce the bill by 25%, but this still represents daylight robbery.
Fast forward a few weeks and the BBC’s Watchdog program highlighted several cases similar to mine, where people had been charged ridiculous sums of money for trivial amounts of data transfer. All the people mentioned in that program had their bills reduced by 100%.
Vodafone should apply the same discount to all people in the same circumstances, not make a big deal about a couple of high profile cases then exploit the rest of us.
I would like to take this opportunity to pass on a few bits of advise for anyone dealing with Vodafone, or any other mobile phone network for that matter.
Do not deal with the regular call center. Go straight for the cancellations department and start your conversation with the phrase, “I want to cancel my contract.” As soon as you do this you will speak to someone who can actually make a decision. Invariably they will offer you something to keep you on your contract. This may be a bill adjustment or a new phone etc. I’m not saying you will get the perfect answer, but it’s a start.
Write emails to every consumer show, ombudsman and regulatory body you can. Someone like Watchdog may pick up your case and shame the company into doing the right thing. I’m convinced if I had written to Watchdog one month earlier I would have had my bill reduced to nothing. As it is I’m Billy Anonymous and Vodafone are happy to ignore me.
Be as big a pain in the butt as you can. They are exploiting you. The least you can do is give them a hard time about it.
Vote with your wallet. Once this whole affair is over I will never put money into Vodafone’s pockets again.
I’m sure all networks are guilty of this sort of behavior, but I can only speak about my experience of Vodafone. After 10+ years of being a satisfied Vodafone customer, I can safely say I think they’ve now dropped off the bottom of my customer satisfaction chart!