SQLTXPLAIN and the AWR Warehouse- Part II

I finally have a moment to look into my “hacked” SQLT XPRECT/XTRACT runs and see if the changes I made were enough to run properly with the AWR Warehouse. The answer is yes and no… and...
0 comment

Using the Oracle Grid Infrastructure Agents for GoldenGate on Oracle restart

I was testing Oracle Goldengate on a non-clustered Oracle 12.1.0.2 database with ASM. With ASM, you need to have the grid infrastructure installed. The cluster ware for the single node install is called...
0 comment

Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable

I’ve updated some of my ASH scripts to use these 4 arguments in a standard way: What ASH columns to display (and aggregate by) Which ASH rows to use for the report (filter) Time range start Time...
0 comment

ANSI expansion

Here’s a quirky little bug that appeared on the OTN database forum in the last 24 hours which (in 12c, at least) produces an issue which I can best demonstrate with the following cut-n-paste: SQL>...
0 comment

ASH

There was a little conversation on Oracle-L about ASH (active session history) recently which I thought worth highlighting – partly because it raised a detail that I had got wrong until Tim Gorman...
0 comment

To patch or not to patch?

Mary Ann Davidson wrote a great piece on her security blog today, which basically talked about focusing on the important vulnerabilities, not necessarily the ones that get the most press. Added to that,...
0 comment

12c MView refresh

Some time ago I wrote a blog note describing a hack for refreshing a large materialized view with minimum overhead by taking advantage of a single-partition partitioned table. This note describes how...
0 comment

UKOUG System Event : I’ve got a paper selected.

I’ve just found out I’ve got a paper selected for the UKOUG System Event on May 20th. Check out my badge. I was a spectator at last year’s event. At first glance you might think much...
0 comment

Oracle Linux 7.1 Preinstall Packages available for 11gR2 and 12cR1

Every so often I have a nose around the contents of the Oracle Linux public yum repositories and guess what I found in the OL7.1 base and OL7 latest repositories. oracle-rdbms-server-11gR2-preinstall-1.0-3.el7.src.rpm oracle-rdbms-server-11gR2-preinstall-1.0-3.el7.x86_64.rpm oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.src.rpm oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64.rpm Yeeeeeaaaaahhhhhh! The...
0 comment

Oracle Linux 7.1 Preinstall Packages available for 11gR2 and 12cR1

Every so often I have a nose around the contents of the Oracle Linux public yum repositories and guess what I found in the OL7.1 base and OL7 latest repositories. oracle-rdbms-server-11gR2-preinstall-1.0-3.el7.src.rpm oracle-rdbms-server-11gR2-preinstall-1.0-3.el7.x86_64.rpm oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.src.rpm oracle-rdbms-server-12cR1-preinstall-1.0-3.el7.x86_64.rpm Yeeeeeaaaaahhhhhh! The...
0 comment