While playing around 220.127.116.11 db, I ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high.
Ran the sql using “gather_plan_statistics” hint and below lines in the execution plan were of interest –
| 34 | HASH GROUP BY | | 1 | 6 | 3 |00:00:58.68 | 129K| 54801 | 1160K| 1160K| 758K (0)| | 35 | VIEW | DBA_FREE_SPACE (more...)
Why you might want to think twice about using INSERT ALL.
One of those things I knew and then forgot.
So, let’s say you’ve got three tables or a partitioned table or something like that.
Let’s use regional tables for simplicity.
drop table t1_r1; drop table t1_r2; drop table t1_r3; create table t1_r1 (col1 varchar2(2) not null ,col2 number not null ,check( col1 in ('R1'))); create table t1_r2 (col1 varchar2(2) not null ,col2 number not (more...)
Sometimes love isn’t fair
A teenager, just emerging from an awkward growing phase drives a tendency to spew non sensical permutations of varying cringe worthy affections toward their love target. The data points behind the intent are solid. Let’s go Boolean now:
Intent of good = 1 ;
attracted to target = 1;
ability to provide for target = 1;
time available = 1;
prior or current committed relationship = 0.
So here (more...)
Oracle GoldenGate for Big Data 18.104.22.168.1 update is available
I am pleased to announce the general availability of Oracle GoldenGate for Big Data 22.214.171.124.1.
What’s new in Oracle GoldenGate for Big Data 126.96.36.199.1 ?
Oracle GoldenGate for Big Data can now write data in Avro Object Container Format (more...)
This is really messed up. I chose GoldenGate because I did not want to mess around with streams.
When using Integrated Capture or Delivery, then knowing streams is a prerequisites.
Apologies as the format is not pretty.
The QUEUE table was indeed missing and this is what I get for monkeying around.
To resolve the issue – exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
GGSCI (arrow.localdomain as ggs_admin@hawk) 3> unREGISTER EXTRACT e_hawk DATABASE 2016-05-23 19:16:32 ERROR OGG-08221 Cannot (more...)
Here’s a story of (my) failure prompted by a recent OTN posting.
The OP wants to use composite partitioning based on two different date columns – the table should be partitioned by range on the first date and subpartitioned by month on the second date. Here’s the (slightly modified) table creation script he supplied:
CREATE TABLE M_DTX ( R_ID NUMBER(3), R_AMT NUMBER(5), DATE1 DATE, DATE2 DATE, VC GENERATED ALWAYS AS (EXTRACT(MONTH FROM DATE2)) ) PARTITION (more...)
Alternate script prvtlmpg.plb (included in the Oracle GoldenGate installation directory) to the mining database to work around this limitation.
oracle@arrow:hawk:/u01/app/188.8.131.52/ggs01 $ ll prv* -rw-r-----. 1 oracle oinstall 1272 Dec 28 2010 prvtclkm.plb -rw-r-----. 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb -rw-r-----. 1 oracle oinstall 3263 May 27 2015 prvtlmpg_uninstall.sql oracle@arrow:hawk:/u01/app/184.108.40.206/ggs01 $
The other option in this (more...)
I typically don’t like to see WARNING if I can help it.
Goldengate 12c has some security features to allow/prevent unauthorized access.
Be careful. Incorrect IPADDR or PROG is used will prevent Pump Extract delivery to target server.
oracle@arrow:hawk:/u01/app/220.127.116.11/ggs01 $ tail -100 ggserr.log 2016-05-22 12:25:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr. 2016-05-22 12:25:07 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule (more...)
HCM Atom feeds provide notifications of Oracle Fusion Human Capital Management (HCM) events and are tightly integrated with REST services. When an event occurs in Oracle Fusion HCM, the corresponding Atom feed is delivered automatically to the Atom server. The feed contains details of the REST resource on which the event occurred. Subscribers who consume these Atom feeds use the REST resources to retrieve additional information about the resource.
For more information on Atom, (more...)
If videos aren’t your thing, you might want to read these articles, which the videos are based on.
- JSON Support in Oracle Database 12c Release 1 (18.104.22.168)
- Indexing JSON Data in Oracle Database 12c Release 1 (22.214.171.124)
- APEX_JSON Package: Generate and Parse JSON Documents in Oracle
The cameo in this video (more...)
On Monday night we obtained access to the SOA Cloud Service here at Flexagon, where we hope to use it for on-demand capacity. One of our goals with FlexDeploy is to make it easy to move components from one environment or instance to another, enabling a true “lift-and-shift” into the cloud. Since the SOA Cloud Service is built on top of the same underlying Oracle infrastructure, configuring it as a FlexDeploy target is (more...)
the past year billions more smart devices have been deployed by
Enterprises as they begin the journey to transform themselves. Knowing
where to start is one of the biggest challenges faced by any Enterprise.
That’s why we have created our unique Oracle IoT Discovery Workshop
which is helping Enterprises, like yours, to not only formulate
effective IoT strategies but then bring them to life.
Join us at our exclusive briefing webcast that will provide (more...)
Blurr the cloud lining with NetSuite: Introducing NetSuite Cloud Adapter on Oracle Integration Cloud Service by Rajesh Kalra
NetSuite is a leading SaaS business software suite for ERP/financials, eCommerce, and order management. NetSuite cloud applications are commonly used by many mid-market and enterprise level companies, to streamline operations and provide real time visibility for better and faster decisions.
Oracle has introduced an all new NetSuite cloud adapter, in the latest release of its iPaaS -Integration Cloud Service (ICS). This new addition to the catalog of cloud adapters provides agility for NetSuite (more...)
This blog post is more of a note for myself on configuring ASMLib.
ASMLib is an optional utility that can be used on Linux systems to manage Oracle ASM devices.
ASMLib consists of the following components:
An open source (GPL) kernel module package: kmod-oracleasm
An open source (GPL) utilities package: oracleasm-support
A closed source (proprietary) library package: oracleasmlib
On my Oracle VMBox, I performed the below steps –
1. Check the installed packages related to (more...)
You can, but what happens when you want to integrate that shiny new cloud app with your existing applications and data? That integration has its own term—hybrid cloud—and for most enterprises, it’s the new norm. More than 65% of enterprise IT organizations will commit to hybrid cloud technologies (more...)
OBIEE 12c has changed quite a lot in how it manages configuration. In OBIEE 11g configuration was based around system MBeans and the
biee-domain.xml as the master copy of settings – and if you updated a configuration directly that was centrally managed, it would get reverted back. Now in OBIEE 12c configuration can be managed directly in text files again – but also through EM still (not to mention WLST). Confused? Yep, I (more...)