In yesterday’s blog post, I wrote about creating a table with an IDENTITY value. But the Oracle 12c new feature that I like better is allowing a sequence to be the number generator for the default value of a column. To see what I mean, look at this example: SQL> create sequence test_seq; Sequence created. …
Category: Oracle
Jul 30
12c IDENTITY columns
I live and work close to a Microsoft facility. As such, many of our current employees are former Microsoft employees that come from a SQL Server background. SQL Server lets you create a table with an IDENTITY column. Oracle 12c now lets you do the same. This should help those who are making the transition …
Jun 27
Oracle 12c Top New Features
I figured I would give my top new features for the recently released Oracle 12c database. I think one of the most interesting new features is the Pluggable Database, but it seems like everyone is talking about that. So I’ll focus on other new features that I am interested in. This list is in no …
Jun 21
CSV in SQL Developer…
…and other formats as well. I came across this in a recent AskTom article where you can quickly generate output from a query in CSV format using SQL Developer. The way I have always done it, is to enter the SQL statement in my SQL Worksheet. Then hit Run Statement (CTL-Enter). Right click on the …
May 21
ORA-16205 Upgrading to 11.2.0.3
I am trying to upgrade all of our databases from 11.2.0.2 to 11.2.0.3 this year. My first upgrades were on a 2-node RAC primary with 2-node RAC standby database in a testbed. There isn’t much to this database as it is just a starter database. But this let me test out the upgrade on RAC …
Apr 17
Auto Generating Response File
I am working on upgrading multiple databases to the Oracle 11.2.0.3 version. Before the upgrade, I need to install this version on multiple machines. We’ve known for a long time that you can generate a response file and use this for a silent install, speeding up the installation. The way I’ve always created my response …
Mar 21
.patch_storage
I got an alert from Enterprise Manager that my C: drive on one of my database servers was running short on space. The disk device is 20GB is size and had less than 1GB free. I removed old log files, but this still did not free up enough space. In looking around, I saw that …
Jan 31
EM 12c Adjusting Threshold Values
On a test system, I’ve been getting frequent alerts from Enteprise Manager 12c Cloud Control that my host is running low on swap space. Since this is a test system, and since I know my swap space is just fine, I decided to increase the Warning threshold from 80 to 87%. In doing so, I …
Jan 24
Tasklist
I’m sure that someone reading this will ask, “how did you not know that?”. But sometimes the simplest things come to us late in the game while others knew it early on. I’ve been patching Oracle on Windows since the Windows NT days. Everyone who patches Oracle on Windows knows that OPatch will often balk …
Jan 22
Trailing Zero
I had a developer ask me an interesting question recently. He was working on a problem where numeric values were stored in a table but when he queried that table in PL/SQL Developer, it would show trailing zeroes after the last digit. He wondered if this was contributing to the problem he was trying to …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
