Recent Posts

APEX, SQL

Troubleshooting conversion errors

TweetShareSharePin0 SharesMy friend and Oracle maestro Daniel Ekberg wrote a post about ways to manage errors when converting data. Go read his post if you want to see how the errors you get can be better managed. I think he may be the person that first pointed out the feature to me that I want to show my use of. One common way to get data into APEX is to load a spreadsheet into a table. But often you get […]

SQL, Database, Oracle DB 23ai

23ai Syntactic sugar – IF [NOT] EXIST

TweetShareSharePin0 SharesIn the last post I talked about a form of syntactic sugar I’m not convinced we really needed. This post on the other hand is about one that I think I’ve needed since the first time I logged on to a SQL-based database. When you put together a test case it is often setup to create misc objects and populate them. The first time you run it it works fine but when you rerun it your create commands fail […]

APEX, Database, SQL Developer, SQLcl

23ai Select without FROM

TweetShareSharePin0 SharesNow that Oracle DB 23ai has been GA for a while I figure it is time to dig into it and talk about the features för DBA and developers that I find most interesting to talk about. Yes, you’ve read about some of them as info has seeped out during the beta-test and and pre-GA. I however think most people are only looking at it when it is GA as that is when they start looking at when and […]

Docker, Database, Property Graph, SQL

Your very first graph in Oracle Graph Server

TweetShareSharePin0 SharesHaving installed the Graph Server in the last post, lets set up and create your very first graph. This follows Oracles documentation. It however had different ways to do it and I struggled to figure out which would be the easiest. Having abandoned a couple for different reasons this is how I did it and I think it is pretty straight forward and uses the tool interactively as much as possible. We first need a user we’ll use to […]

Docker

Installing Graph Server in Docker

TweetShareSharePin0 SharesInstalling Graph Server is pretty straight forward but there are a few things to consider. This will show how to install in Docker, but you’ll be able to adopt for whatever deployment model you want to use. Begin with downloading the Graph SAerver package and a the latest and greatest of Java 11. https://www.oracle.com/java/technologies/downloads/#java11https://www.oracle.com/database/graph/downloads.html Now with this in place you unzip and put both rpms in the same directory. Create a “Dockerfile” in the same directory with this content. […]

Uncategorized

Graph server on ARM – a couple of findings

TweetShareSharePin0 SharesHaving installed this on my mac I ran into a few things worth pointing out for others. The software download will pull down a zip-file named x86 instead of the expected aarch64. That seems wrong so I try again. I made numerous attempts in different ways to get it to download a file named for the architecture I wanted. Finally giving up and wondering if it could be due to the contents being the same for both. It is, […]

Licensing, Database

Graph is included in the DB – just the DB?

TweetShareSharePin0 SharesQuite a few releases ago in 12c the new that the Graph and Spatial option was now included with the database license. Pretty neat, more stuff included is always nice. So in the database we can use the feature and even run queries against it. But then waht, we get a result back showing all the connections in a graph with data that does not conform to relational modelling. To understand it one has to view it graphically, or […]

Performance, DBA

Tuning a packaged solution using OCI-drivers

TweetShareSharePin0 SharesWe’ve all been there. You have an application bought from some vendor that has less than adequate knowledge about the Oracle Database. The solution underperforms even though the SQL itself looks OK. You dig into it and it turns out the solution retrieves a lot of data but each fetch gets too few rows from the database and thus the latency of getting more data is 99% of the time it takes. The result is of course that there […]

PL/SQL, SQL, Machine Learning

Looking for AI? You already have it!

TweetShareSharePin0 SharesThese days I meet many people who talk about how they have a project to find an AI-plattform to use on-premises. Using it in the cloud on Autonomous it is pretty obvious that you use one in a handful of AI-services Oracle has at your disposal there. The question is what you should use to build AI-services on the data in your on-prem Oracle database. You don’t need to get anything. This blog post assumes you have an Oracle […]

Database, Oracle Cloud, SQL

Ignoring errors on “alter session set”

TweetShareSharePin0 SharesThis tip is especially useful when migrating to autonomous. The reason is that to enable the magic of the the autonomous database there are things that cannot be done. One such thing is that there are a lot of session settings you cannot use. To see what APIs you can no longer use you can look at the documentation. If you look at alter session there are a number of “alter session set …” that are available. But many […]