We use the terms DDL and DML in our DBA life with Oracle all the time. The first stands for Data Definition Language and it is about Data Definition changes. The latter is about manipulation with your data itself, and stands for Data Manipulation Language. When we speak about replication of our data by replication tools between Oracle databases, we generally either enable DDL, work only replicating DML, or do it for both together. In (more...)
As soon as an application becomes even moderately complex, CQRS and an Event Sourced architecture start making a lot of sense. The talk is focused on: - the challenges and tactics of separating the write model (more...)
As part of our communities we do offer free PaaS accounts (only for partners in Europe, Middle East and Africa. In case you are not part of EMEA please contact your local partner manager):
· Java Cloud Service & Application Cloud Container Service & Mobile Cloud Service (more...)
I am starting Oracle 12c learning series, where I am planning to publish multiple articles on Oracle 12c new features. I hope these articles will be helpful to DBAs aspiring for OCP 12c certification and also others who are planning to implement these features in there databases.
This is a very long post about ADO – Automatic Data Optimization, which is one of the ILM strategy to manage aging data. So please be patient while reading this article. This article provides end-to-end details (more...)
Are you as a mobile developer looking for that key component that allows you to capitalize on all the affordances provided by the cloud?
Join us for the new partner webcast, taking place on Thursday, July 21st , 10 am CEST (9am BST/11am EEST).
- Oracle Mobile Cloud Service (MCS): Why Do We Need Mobile Backend Platform?
- New Features and Updates
- Location Based Services
- Client SDKs
- Summary – Q&A
Software performance is always a hot topic!
Join us for this week’s JD Edwards Technical Task Force session where JDE Software Architect, Chris Papineau, will discuss methods and tools used for diagnosing and resolving performance issues.
Oracle Mobile Cloud Service 2017 Developer Essentials Exam (1Z1-346) is available in beta testing!
This certification covers topics such as: Fundamentals, Mobile Backends, Platform Features, Connectors, Custom APIs, Analytics, and Management.
Up-to-date training and field experience are recommended. Take the exam for free while in beta testing!
Request a beta voucher via the OPN Beta Certified Specialist Exam Voucher Request Form! We advise partners that are planning to become specialized in this area to have (more...)
Be advised that on January 31st, 2017 Oracle Transportation Management and Oracle Trade Management Specializations will be retired due to reaching end of service life for Premier Support.
We advise you to pursue alternative specializations for the products of your interest, developed in line with Oracle’s portfolio of SCM products.
Attend our July edition of the SOA & BPM Partner Community Webcast live on July 26th 2016 at 16:00 CET.: What’s new in Oracle BPM and Process Cloud Service? Digital Process Apps made Simple
During this session, we will be joined by Sujan Balachandran, Product Manager for Oracle BPM and Process Cloud Service (PCS).
The session will cover:
- Empower Business User using BPM Composer
- What is Business Architecture? How can it help Enterprises organize (more...)
Before LATERAL and CROSS APPLY were added (exposed to us) in 12c, a common technique to do correlated joins was using the TABLE/MULTISET technique.
For example, we might have had a couple of tables:
SQL> create table t as 2 select object_type, min(created) min_dte, max(created) max_dte 3 from dba_objects 4 where owner = 'SCOTT' 5 group by object_type; Table created. SQL> select * from t; OBJECT_TYPE MIN_DTE MAX_DTE ------------------- --------- --------- INDEX 09-OCT-13 09-OCT-13 TABLE (more...)
I previously had my Nexus 5, but over the time, Bluetooth stopped working and that was a good excuse to try this phone.
Also I was so excited because at SXSW I had a long talk with the Nextbit (@ (more...)
Service Oriented Architecture (SOA) integrations with Oracle E-Business Suite
can either be custom integrations that you build yourself or prebuilt
integrations from Oracle. For more information about the differences between the two options for SOA integrations, see this previously-published certification announcement.
The prebuilt BPEL business processes in Oracle E-Business Suite Release 12.2 are:
- Oracle Price Protection (DPP)
- Advanced Supply Chain Planning (MSC)
- Oracle Transportation Management: Oracle Warehouse Management (WMS)
- Oracle Transportation Management: Oracle (more...)
So some unknowing fool gave me full access to a fridge of Starbucks caffeinated beverages, which should be against the law in this fine country. Needless to say, my ability to type approximately 180wpm has offered me the opportunity to catch up and blog about what it’s like almost a month in employed with Delphix.
In just the last two weeks, a number of conference sessions have come (more...)
"You see, to tall men I'm a midget, and to short men I'm a giant; to the skinny ones I'm a fat man, and to the fat ones I'm a thin man." -- Norton Juster, The Phantom Tollbooth
Someone in one of the Oracle forums asked the following question:
How to estimate datafile size of tablespace when it is almost full? Could someone please explain?
which is ambiguous to say the least, since no (more...)
I can't remember having encounterd this problem in 11g, and this week I struggled with it with one of my customers. The perception of the DBA there was that in 11g the server did start up, but (more...)
No-one under a certain age (or outside of the UK for that matter) will remember the often disturbing TV series 'tales of the unexpected' https://en.wikipedia.org/wiki/Tales_of_the_Unexpected_(TV_series). I don't know why i mention it now really other than as a tenous link to a very basic demonstration of the expect (/usr/bin/expect) unix utility that has been around for a very long time and can actually prove very useful - here is an example of (more...)