From stateful to stateless PL/SQL
I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little
Tag: autonomous
Easy data access from Excel #JoelKallmanDay
I suspect Joel would have kittens if he knew I would use the appreciation day to talk about Excel instead
Juice up your JSON on Autonomous
As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and
Awesome DATE / TIMESTAMP enhancement in Autonomous Database
Date management is a commonly encountered issue when customers want to move their database to a cloud environment. If you
SQL trace on your cloud database
There are so many great performance monitoring tools that have come along in the Oracle Database since 10g – things
Much ado about (paying) nothing
A couple of days ago, we announced some more free goodies to Oracle Cloud. As most readers will know, we
When can I use SQL Macros?
One of the very cool features we’ve been talking about for 20c is SQL Macros. But you no longer need
How to control resource usage on Autonomous
When you connect to your Autonomous Database, you get to choose from some predefined services. The services available depends on
Upgrading…Its Time!
Gough Whitlam was an Australian politician who rose to power in the 1970s with the campaign slogan “It’s Time!”. Politics
Autonomous Transaction Processing – your slice of the pie
I grabbed the following screen shot from a slide deck I’ve been giving about Autonomous Transaction Processing (ATP). It shows
Learning is not a spectator sport 