- Powered by
- WordPress
-
Smart Scan enhancements in Oracle Exadata 12c-inline LOBs
As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details. To…
-
If you use swingbench take note of sbutil
This is going to be a very short post for a change. I have used Swingbench extensively and really love the tool. Many thanks to Dominic Giles! Recently he announced a new tool on his blog that you can use to inflate your data volume. So instead of using the “-scale” argument when executing oewizard…
-
Additional information on Oracle 12c big table caching
Teaching is on the things I like doing, and currently I am investigating the Oracle 12c features around caching data in the various memory areas. Since the In-Memory (cost) option has been discussed by other far more knowledgeable people I would like to share some findings about the big table caching here. Some Background In…
-
Exadata Fast Data File Creation
This post is the result of some testing I performed on Exadata data file creation. You may know that Exadata offloading incorporates SQL optimisations as well as some infrastructure work. For quite some time Exadata allowed the DBA to create data files a lot quicker than on traditional systems. This has been documented before, for…
-
Little things worth knowing: Is there a penalty in establishing a connection to Oracle using the MAA connection string? Part 2
In the very lengthy previous post about the MAA connect string I wanted to explain the use of the MAA connection string as promoted by Oracle. I deliberately kept the first part simple: both primary and standby cluster were up, and although the database was operating in the primary role on what I called standby…
-
Little things worth knowing: Is there a penalty in establishing a connection to Oracle using the MAA connection string?
Sorry for the long title! I had a question during my session about “advanced RAC programming features” during the last Paris Oracle Meetup about the MAA connection string. I showed an example taken from the Appication Continuity White Paper (http://www.oracle.com/technetwork/database/options/clustering/application-continuity-wp-12c-1966213.pdf). Someone from the audience asked me if I had experienced any problems with it, such…
-
Little things worth knowing: what does opatchauto actually do?
I recently applied system patch 20132450 to my 12.1.0.2.0 installation on a 2 node RAC system on Oracle Linux 7.1. While ensuring that OPatch is the latest version available I came across an interesting command line option in opatchauto. It is called “-generateSteps”. So this could be quite interesting so I wanted to see what…
-
Little things worth knowing: direct path inserts and referential integrity
This is another post to remind myself that Oracle evolves, and what I thought I knew might no longer be relevant. So double-checking instead of assuming should become a habit! Today’s example: direct path inserts. I seemed to remember from Oracle 9i that a direct path insert ignores referential integrity. This is still confirmed in the 9i…
-
Little things worth knowing: exp/imp vs expdp and impdp for HCC in Exadata
Do you know the difference between exp/imp and expdp/impdp when it comes to importing HCC compressed data in Exadata? If not, then follow me through two examples. This is on 11.2.0.3/11.2.3.3.1 but applies to all database releases you can have on Exadata. The task at hand is to export a table (which happens to be non-partitioned…
-
Understanding enhancements to block cleanouts in Exadata part 2
In part 1 of the series I tried to explain (probably a bit too verbose when it came to session statistics) what the effect is of delayed block cleanout and buffered I/O. In the final example the “dirty” blocks on disk have been cleaned out in the buffer cache, greatly reducing the amount of work…
