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 […]

Bug, DBA, Oracle, Security

Is your database secure? Are you sure? Are you *really* sure?

TweetShareSharePin0 SharesA friend and at the time co-worker at Kentor AB found this bug. He found the bug and had the tenacity to track down and prove that it was a bug and not just a flaw in the logging mechanism where this first was indicated to occur. Today is the day when I can finally speak about a bug I asked for a peer review on over a year ago. I had to pull that blog post offline when […]

Partitioning, DBA, EXA, Oracle, Performance

Improving data move on EXADATA V

TweetShareSharePin0 SharesWrap-up This is the last post in this series and I’ll not introduce anything new here, but rather just summarise the changes explained and talk a bit about the value the solution delivers to the organisation. Let’s first review the situation we faced before implementing the changes. The cost of writing the log-records to the database was that all the parallel writing from many different sources was such that it introduced severe bottlenecks to the point that the logging feature […]

Oracle, Partitioning, Performance, DBA

Improving data move on EXADATA IV

TweetShareSharePin0 SharesReducing storage requirements In the last post in this series I talked about how we sped up the move of data from operational to historical tables from around 16 hours down to just seconds. You find that post here. The last area of concern was the amount of storage this took and would take in the future. As it was currently taking 1.5 TB it would be a fairly large chunk of the available storage and that raised concerns […]