Oracle

Oracle, Oracle Cloud

Creating an Oracle Base DB service

TweetShareSharePin0 SharesYou may already have one or two free autonomous databases at OCI. Why then would you want a lower tier database offering, a database that is not autonomous? It turns out there are many reasons why you may want this. No matter what your reason is, setting it up is pretty easy. One thing before you start though, you canot stop it to stop spending money. You have to then terminate the service and later recreate it if you […]

Oracle, PL/SQL, SQL

Using package variables in SQL

TweetShareSharePin0 SharesI often want to use the constants defined in packages also in my SQL. It has in the past never worked and it for the most part still does not. If I have a a package like this to simplify my code for what department it is I’m looking at. This now allows using dept_info.c_accounting in PL/SQL instead of just hardcoding 10 and having to remember what department 10 is. This is how we usually use PL/SQL and especially […]

Oracle, Performance

When views causes havoc

TweetShareSharePin0 SharesViews are great. They simplify design, makes code look more elegant and hides complexity. They also enables reuse by putting complex code in just one place instead of in every accessing piece of code. But… There once was a large project that has been churning away for a long time. The performance of having more than one user on the system was horrendous. But it was chalked up to misconfiguration. I am asked to spend a day giving said […]

DBA, Oracle

Quick note on MT and applications II

TweetShareSharePin0 SharesTalking about Multi Tenant and applications, one has to talk about the different options for sharing. It is one of the great features of multi tenant. It is a way to let one PDB – the application root –  have data that can be used from other PDBs. There are three kinds that allow you to get different features of the sharing. Metadata Data Extended Data Lets review each kind and why and how you’d use it. Metadata This allows […]

APEX, Oracle, Docker

Your very own development environment

TweetShareSharePin0 SharesEveryone should have their own local development environment. No matter if you write Java and that just means IDE and JDG, or if you work with databases. Not having it reduces your learning a lot. I have yet to meet a really sharp database expert who does not have a local personal environment. It also goes the other way around, you can usually guess if a person has it or not. Yes, you can get a database by just […]

Blogging, Oracle, ThanksODC

ODC Appreciation Day: Old Blog Posts

TweetShareSharePin0 SharesFIrst of all, kudos to  Tim Hall. This is one of the great times of the year when all these thankful blogs are posted in a day. If you read nothing else in the blogs all year, picking some of them would not be a bad choice. Speaking of which, I will talk about being thankful for blogs in general. No, not about the new ones explaining all the new features we get in new versions. While that is […]

Database, Oracle, OOW

Database is the marquee feature again

TweetShareSharePin0 SharesSo every year before and during Oracle Open World we all complain about how data and database is brushed to the side. This year it is the feature. It is the one thing the big sign on Moscone West screams. “The Autonomous Database” Here is a picture from showing it. It is all about database. Every year there is talk about how Oracle needs to return to data and databases. Now that they do, I think we should be […]