Category: 12c New Features

Aug 31

Oracle 12c Upgrade Issues

I’m in the middle of testing for my company’s Oracle 12c production upgrades coming in September. Thankfully, I have a lot of good testbeds to fine-tune the upgrade process before proceeding to production. So far, things have been pretty smooth, even much better than my 11.2.0.3 to 11.2.0.4 upgrades a year ago. I thought I’d outline …

Continue reading

Aug 18

Video: Oracle 12c IDENTITY Column Performance on RAC

I’m trying to branch out a bit and craft a few videos. This one is my first attempt and I discuss the new 12c IDENTITY column performance, specifically for Oracle RAC databases. It provides results buying levitra from canada from its first dose. IF you can’t consume tablets: Then kamagra also comes in oral on …

Continue reading

Aug 13

ORA-27038 on 12.1.0.2 RAC Upgrade

I am upgrading a 2-node Oracle RAC testbed from Oracle 11.2.0.4 to Oracle 12.1.0.2. This is a simple testbed and the database is virtually empty. I’m using the DBUA to perform the upgrade. Should be simple, right? After the database is upgraded, the DBUA is trying to move the RAC configuration to the new home. …

Continue reading

May 15

SEC_CASE_SENSITIVE_LOGON Deprecated in 12c

I’m working on getting my companies databases upgraded to Oracle 12.1.0.2 before our 11.2.0.4 databases lose free Extended Support in Jan 2016. One of the “gotchas” for us is that the SEC_CASE_SENSITIVE_LOGON parameter is deprecated in 12c. It’s still there, but who knows for how long. Before I arrived at this company, they upgraded to Oracle …

Continue reading

Jan 23

SEC_CASE_SENSTIVE_LOGON in 12c

Oracle 12c deprecates the SEC_CASE_SENSITIVE_LOGON parameter. It is still there for backwards compatibility. But Oracle would like to see everyone use case sensitive logons in the future. The one thing that did surprise me was when I recently upgraded a test db from 11.2.0.4 to 12.1.0.1 using the DBUA. At the end of the DBUA, …

Continue reading

Nov 13

InMemory DUPLICATE Confusion in Oracle RAC

Most people are probably aware of the new Oracle 12.1.0.2 feature, the InMemory database option. When using this option on Oracle RAC, the DBA can specify the DUPLICATE clause to have an object be duplicated among the InMemory column store in all instances. This clause is for Oracle’s Engineered Systems like Exadata. However, in non-Engineered …

Continue reading

Aug 01

Oracle In-Memory Cost

Just read an interesting post by James Morle on the “true cost” of Oracle’s new In-Memory database option. It’s a good read.   Fishes in the form of sardines, get free viagra salmon, etc. are vital sources of Omega 3 fatty acids. A few problems can also be caused cialis 20 mg by the use …

Continue reading

Nov 19

12c Deprecated Features

Everyone likes to talk about the new exciting features in Oracle 12c. But what will be going away that you need to start preparing for? I haven’t seen much discussion in this area yet so I figured I would blog about it. You can view the list of deprecated features in the 12c Upgrade Guide, …

Continue reading

Oct 16

No more SPU

I meant to blog about this awhile back but I got sidetracked. Last month, Oracle announced that for Oracle 12c, it would no longer be offering two types of patches every quarter in the Cumulative Patch Update (CPU). Currently for 11g, you can get a Security Patch Update (SPU) which contains just security fixes or …

Continue reading

Oct 04

Another 12c Optimizer White Paper

Yesterday, I blogged about a good white paper I found from Maria Colgan of Oracle Corp relating to the CBO. I also discovered another good paper. This one discusses all of the CBO-related enhancments for Oracle 12c. You can find this paper here. Optimizer with Oracle Database 12c This one is a really good read. …

Continue reading