Thanks to the prep-work done by Andy Colvin, who continuously and boldly goes where no man has gone before, one of our Exadata systems in the lab is now fully upgraded to 18.104.22.168. It comes fully equipped with the matching cellos to support all the cool new features. Exciting times!
I have been managing data in different databases for a long time to appreciate how critical it is for the client to get the results out of their data as fast as possible. It's all about the returning (more...)
Actually, this is a follow up post from my performance deep dive into tablespace encryption. After having investigated how tablespace encryption works, this blogpost is looking at the other encryption option, column encryption. A conclusion that can be shared upfront is that despite they basically perform the same function, the implementation and performance consequences are quite different.
Column encryption gives you the ability to choose to encrypt per individual column, that’s kind of obvious. However, (more...)
There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post.
First, I’ll create four tables with two indexes:
create table t1 as select rownum n1, rownum n2 from dual connect by level <= 1000000; create table t2 as select rownum n1, rownum n2 from dual connect by level <= 100; create table t3 as select rownum n1, rownum n2 (more...)
If a Goldengate replicat process fails then occasionally on the restart it skips the correct RBA and ‘loses it’s position’. The relative byte address (RBA) is the location within the trail file to indicate the current transaction.
The old school method was to calculate which RBA was the correct one and then restart the replicat. However there is a new command on the block now (pun intended) and I will demonstrate how the two methods (more...)
Working on the new eDB360 repository I came across this “ORA-00997: illegal use of LONG datatype” while trying to CTAS on the following DBA views:
All these views above include at least a LONG column, which raises the ORA-00997 while trying to do something like: CREATE TABLE edb360.dba#constraints AS SELECT * FROM dba_constraints.
I found several blogs explaining reason and some providing some hints, like using (more...)
This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Compiling views: When the FORCE Fails You
Goldengate 12c Troubleshooting XAGENABLE
A performance Deep Dive into Tablespace Encryption
EBS Release 12 Certified with Safari 10 and MacOS Sierra 10.12
Oracle Database 12c (22.214.171.124.0) on VirtualBox
A Single-Parameter Date Range in SQL Server Reporting Services
Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot
Justify the (more...)
There are a number of tiny details that I can never remember when I’m sketching out models to test ideas, and one of those is the PL/SQL block name. Virtually every piece of PL/SQL I write ends up with variables which have one of two prefixes in their names “M_” or “G_” (for memory or global, respectively) but I probably ought to be formal than that, so here’s an example of labelling blocks – specifically, (more...)
Oracle RAC with DBFS running as oracle
Goldengate12c running as ggsuser using DBFS and XAGENABLE
Monitoring is running as monitor
ERROR: Transparent Integration with XAG is Enabled but CRS/XAG is not Available (Doc ID 2240440.1)
Modify GLOBALS per Doc ID 2240440.1
$ cat GLOBALS
setenv (GRID_HOME='/u01/app/12.1.0/grid') XAGENABLE
Oracle GoldenGate Command Interpreter for Oracle Version 126.96.36.199.160823 OGGCORE_188.8.131.52.0OGGBP_PLATFORMS_160805.1058_FBO Linux, x64, 64bit (more...)
This is a run through of a performance investigation into Oracle tablespace encryption. These are the versions this test was performed on:
$ cat /etc/oracle-release Oracle Linux Server release 6.8 $ /u01/app/oracle/product/184.108.40.206/dbhome_1/OPatch/opatch lspatches 24315824;Database PSU 220.127.116.11.161018, Oracle JavaVM Component (OCT2016) 24006101;Database Patch Set Update : 18.104.22.168.161018 (24006101)
In this test I created an encrypted tablespace:
SQL> create tablespace is_encrypted datafile size 10m autoextend (more...)
I am not sure if there is a way to have EM display the actual commands it uses to check and alert errors.
It would be nice to be able to verify using the same syntax.
Examples of errors I was paged for:
Message=ora.net2.network has 1 instances in OFFLINE State Key Value=resource_ora.network.type_ora.net2.network
Message=ora.host01_2.vip has 1 instances in OFFLINE State Key Value=resource_ora.cluster_vip_net2.type_ora.host01_2.vip
Of course, crsctl (more...)
How many times have you had a developer come to you and say, “I just did a bad thing in the database. Can you recover from what I just did?”
With Delphix virtualization, we make this pretty easy to address from the user interface with a simple slider to recover from a PIT before the catastrophic mistake, but today, we’ll discuss how to do this from the (more...)
In preparation for an upcoming talk about Oracle 12.2 I am planning on getting my feet wet with the Oracle 12.2 Sharding option. It seems to be a very interesting subject to get into, but like all new subjects, they can be intimidating at first due to their complexity. So why not use the instructions someone has already written down?
"'Why is it,' he said quietly, 'that quite often even the things which are correct just don't seem to be right?'" -- Norton Juster, The Phantom Tollbooth
A YouTube video is currently being promoted in the database community regarding joins, including the variety of joins available in most database engines (the engine referred to in the video is Oracle). A very good discussion ensues covering inner, left outer, right outer, full outer and cross (more...)
Losts have changed for me since my last blog post. A new job and new responsibilities, which will include presenting more at conferences on the conference circuit and a few roadshows that are planned in the near future.
Back in the fall of 2016, when most of the Call for Papers open, I had a great idea for introducing people to Oracle GoldenGate. This idea is walk everyone through the progression of replication technology from (more...)