I’ve just installed 12c (I’m a little slow off the mark) and during the installation process I hit the screen below and thought, “That’s a good idea.”
However, near the end of the installation I noticed that the ASM instance numbers did not match up with the numeric identifiers (more...)
Creating a new table in Oracle SQL Developer
You may not spend a lot of time creating tables in your database, but if you are performing that task, you don’t want your tool to slow you down. And while many of you may design your tables in a modeling solution (more...)
Preparing for OpenWorld, I’m updating all my demos to 12c. Unfortunately, my conclusion so far is that nothing works.
The BC tester (now renamed ADF Model Tester) crashes JDeveloper and doesn’t take bind variables. A simple ExecuteWithParams example ignores my parameter value. The list goes on…
Oracle tries to imply (more...)
I have finished now my work on integrating last PMD version 5.0.5 into JDeveloper.
This is available now for JDeveloper 220.127.116.11 upwards, 11.1.2.x. and 12.1.2. There is no new functionality, as the most work intensive part was the rewriting for (more...)
Working on the chapter that covers best ways of manipulating with object collection. Of course, if you talk about pagination of the rowset, it is very tempting to test Oracle 12c new feature - OFFSET…FETCH.
Unfortunately, immediately got an issue. It seems to me that passing a variable to FETCH (more...)
I Know That's Not A Fair Question
Is 12c faster than 11g? Yeah, I know that's not a fair question. But I do want to know if 12c can process 1000 buffer gets
faster than 11g... don't you?
I want to know how much CPU time is consumed when Oracle (more...)
As we promised in our previous post, we are starting a blog series describing all of new Optimizer and statistics related functionality on Oracle Database 12c. We begin the series with an in-depth look at adaptive plans, one of the key features in the new adaptive query optimization framework. (more...)
Just as with the new Oracle 12c lock types it’s time to take a quick look at the new enqueue waits in 12c. Oracle 18.104.22.168 had a total of 304 enqueue waits. 12c has a total of 418. A lot of work seems also to have happened (more...)
As stated in my previous post, it’s time for me to revisit some of my posts and check the relevance for 12c. Let’s start with the one on locks. As posted in late 2010 there are 202 different lock types in Oracle 11g. It’s actually 205 in 11.2.0. (more...)
As I discussed previously in Part I, the space occupied by orphaned row entries associated with asynchronously maintained global indexes is not automatically reclaimed by subsequent DML operations within the index. Hence the need to clean out these orphaned index entries via the various options discussed in Part II. However, (more...)
In Part I, I discussed how global indexes can now be asynchronously maintained in Oracle 12c when a table partition is dropped or truncated. Basically, when a table partition is dropped/truncated with the UPDATE GLOBAL INDEXES clause, Oracle simply keeps track of the object numbers of those table partitions and (more...)
It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good friend Aman Sharma. I would also take this opportunity to (more...)
I previously looked at how global index maintenance was performed when dropping a table partition prior to Oracle Database 12c. Let’s see how things have now changed since the introduction of 12c. Let’s start by creating the same partitioned table and global indexes as previously: If we look at the (more...)
This post is more like a reminder to myself on how to do this (I have a bad memory…)
By default EM Express is configured for a non-CDB or for a CDB depending on what you selected during a 12C installation and the default URL is https://hostname:5500/em
You can confirm (more...)
There's been some mentions of this feature on Oracle-base
, but here's an example of what excites me.
If you deal with nested arrays/tables in SQL, then you quickly bump into an impedance match. You can't readily get that embedded list into horizontal columns.
I'll use the example (more...)
Original Post can be viewed at MGMTDB: Grid Infrastructure Management Repository
MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being stored in berkley database but starting Oracle database 12c it is configured as Oracle Database Instance. In 11g, .bdb files (more...)
One of the first things I noticed about 12c is the movement of the panes from the view menu to the window menu. I sometimes get a bit too aggressive in closing a lot of the little panes. When I want to get them back later, I just use the (more...)
Original Post can be viewed at 12c: Exporting Database Views as Tables
Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with the same columns as the view and with (more...)