I have a couple scripts for plans comparing:
But they have dependencies on other scripts, so I decided to create a standalone script for more convenient use without the need to download other scripts and to set up the sql*plus environment.
I’ve tested it already with firefox, so you can try it now: http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active_standalone.sql
SQL> @plans_active (more...)
Today I was asked about strange problem: xmltable does not return data, if xquery specified by bind variable and xml data has xmlnamespaces:
SQL> var x_path varchar2(100);
SQL> var x_xml varchar2(4000);
SQL> col x format a100;
3 :x_xml :=q'[
4 <table xmlns="http://www.w3.org/tr/html4/">
PL/SQL procedure successfully completed.
2 i, x
3 from (more...)
It is indeed that sample as switching a knob to turn it on. To enable it you will have to set a reasonable among of...
This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. Goodness knows I do – a few weeks ago I had to analyse 2,304 of them in one (long) day. But for anyone (more...)
After much anticipation the new Release 1 of Oracle 12c (184.108.40.206) is finally available! Get it here: http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html What does this mean: Oracle’s ground breaking In Memory Database is now available! As they say…this is BIG. Get more details about In Memory here: http://www.oracle.com/technetwork/database/in-memory/overview/index.html I am very excited about the possibilities of what we can […]
My client Teradata bought my (former) clients Revelytix and Hadapt.* Obviously, I’m in confidentiality up to my eyeballs. That said — Teradata truly doesn’t know what it’s going to do with those acquisitions yet. Indeed, the acquisitions are too new for Teradata to have fully reviewed the code and so on, let alone made strategic decisions informed by that review. So while this is just a guess, I conjecture Teradata won’t say anything concrete (more...)
The ability to deploy Java inside the Oracle database led somebody to conclude that the source isn’t visible in the data catalog. Then, that person found that they were wrong because the Java source is visible when you use a DDL command to
COMPILE the Java source. This post discloses how to find the Java source and how to prevent it from being stored in the data catalog.
For example, (more...)
Today I noticed strange thing in predicate section of execution plan for simple query with regexp_like, where was not specified 3rd parameter “MODIFIER”:
SQL> select * from dual where regexp_like(dummy,'.');
SQL> select * from table(dbms_xplan.display_cursor);
SQL_ID 97xuqf9cmjsta, child number 0
select * from dual where regexp_like(dummy,'.')
Plan hash value: 272002086
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
The world around us is changing and new stuff in the Oracle database arena is nowadays released on patch level. Although not many new features...
Replicating data can be a time consuming process to setup. Fortunately, Oracle GoldenGate provide a few tools to help ease the complexity of setup. One of these tools is the “macro”. Macros are used to simplify and automate the work associated with setting up and replicating data. So what exactly is a macro? Oracle defines a macro as:
A macro is a built-in automation tool that enables you to call a stored set of processing (more...)
Following on from my earlier blog post on setting up Pluggable Database as a Service (PDBaaS) in EM 220.127.116.11, this post will cover how you actually use the Self Service Portal to create on demand an empty pluggable database within the container database I created for that earlier post. You’ll no doubt be pleased to […]
Recently, I’ve been doing some work with a client where tokens need to be used. It came to my attention that the basic usage of tokens is misunderstood. Let’s see if I can clear this up a bit for people reading.
In Oracle GoldenGate, tokens are a way to capture and store data in the header of the trail file (more info on trail headers here). Once a token has been defined, captured and (more...)
If only I could do the following…(but it seems that it isn’t supported yet)… That is…based on the first “Loading XML documents into an Oracle...
What if you could build a personalized student center for at-risk students? What if this center could invite the student in and provide him or her with a clear pathway to success? Good news! Oracle provides you with the tools to do this as part of the Campus Solutions suite and another Oracle customer experience solutions.
You define your criteria for what constitutes an at-risk student--skipping a term, grades below a certain level, attendance, etc. (more...)
For some time now I have preferred Oracle SLOB as my tool for generating I/O workloads using Oracle databases. I’ve previously blogged some information on how to use SLOB for PIO testing, as well as shared some scripts for running tests and extracting results. I’ve now added a whole new landing page for SLOB and a complete guide to running sustained throughput testing.
Why would you want to run sustained throughput tests? Well, one (more...)
In March and May of this year, we successfully offered the first Oracle Massive Open Online Course (MOOC), Develop Java ME Embedded Applications Using a Raspberry Pi to hundreds of Java developers. The feedback from the MOOC has been extremely positive, and we will likely run additional MOOCs in the future.
Today I am pleased to announce that the materials that were presented in the MOOC are now available as a free, public, self-paced course (more...)