A Recipe for Summoning the RBO Monster (even in Oracle 12c): On Delete Cascade, Function-Based Index and Missing Table Statistics
The last version of Oracle in which CHOOSE was officially supported as an OPTIMIZER_MODE parameter value was 9.2.
This is what the documentation of Oracle 9.2 says about it:
The optimizer chooses between a cost-based approach and a rule-based approach based on whether statistics are available.
If the data dictionary contains statistics for at least one of the accessed tables, then the optimizer uses a cost-based approach and optimizes with a goal (more...)
· New Features in Oracle SOA Suite 12.2.1 Written by SOA architect and Oracle ACE Associate Sandra Flores, this article presents an overview of key new features in Oracle SOA Suite 12.2.1. Read the article.
· Where is SOA Going? Oracle ACE Director Luis Weir and ACEs Rolando Carrasco and Arturo Viveros, the authors of Oracle API Management 12c Implementation (Packt Publishing) share their insight on the evolution of service oriented (more...)
Wishing everyone a very happy and prosperous 2017. May all your dreams come true and …..
Work Hard, Stay Positive !!
Filed under: Oracle
"ORA-16047 – DGID mismatch between destination setting and target database" while configuring dataguard.
From alert.log on primary database:
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
Sat Dec 31 08:29:30 2016
FAL[server, ARC3]: Error 16047 creating remote archivelog file 'sauxmes'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance auxmes - Archival Error. Archiver continuing.
Error 16047 for archive log file (more...)
I published a blog post called “Investigating IO Performance on Amazon RDS for Oracle” recently, and soon after posting it I received several questions asking if IO worked the same way on EC2 instances. My immediate though was it did, mostly because RDS for Oracle is basically an EC2 instance with Oracle Database on top of it, where the configuration is fully managed by Amazon. But as always, it’s better to test than (more...)
Loading Data into Oracle Cloud ERP R10 using the new LoadAndImportData operation by Angelo Santagata
As part of Oracle ERP cloud release 10 a new SOAP function has been made available to our customers which greatly simplifies the loading of ERP data using the batch oriented SOAP Services.
This article aims to give the reader, details of this new SOAP Service and how it helps in loading data files into Oracle ERP cloud.
Assuming the input file has been already produced, loading the data into Oracle ERP cloud service (more...)
It seems that some teams have been relying on a side effect of whitelisting to circumvent the default MAF behaviour, which is to display the contents of the web link directly in the current WebView. In earlier releases of MAF, if you did not (more...)
I was waiting the latest PSU for Oracle Database 18.104.22.168 on the Oracle Database Cloud Service, and today I noticed that it’s available. So let’s see how we can update our Oracle Databases in the cloud.
First we go to the database home to see if any updates is available. As you can see, in the administration box, there is an available patch. We click on it to see the details of (more...)
Let’s say I’ve got a partitioned table, and because New Year’s eve is coming around, I certainly don’t want to be called out at 12:01am because I forgot to add the required partition for the upcoming year .
Since 11g, I can sleep easy at night by using the INTERVAL partition scheme. Here’s my table
SQL> create table t ( x date, y int ) 2 partition by range ( x ) 3 interval ( numtoyminterval(1,'MONTH')) (more...)
If you are using Oracle JET to develop hybrid mobile apps and recently updated to Cordova CLI v6.4.0, you may have noticed that your custom app icons and splash screens are not being included in your app when deployed to Android devices.
This is a known issue with Cordova Android v6.0.0 that has been addressed in the recent v6.1.0 release. To upgrade to this version, follow these steps:
- Change (more...)
The upcoming SLOB 2.4 release will bring improved data loading error handling. While still using SLOB 2.3, users can suffer data loading failures that may appear–on the surface–to be difficult to diagnose.
Before I continue, I should point out that the most common data loading failure with SLOB in pre-2.4 releases is the concurrent data loading phase suffering lack of sort space in TEMP. To that end, here is an example of (more...)
It shows a list of pending changes and also changes colour for changed file name:
Changes can be committed into local repository through informative wizard:
File changes are displayed in very clear way, easy to understand them:
All local changes can be pushed to Oracle Developer Cloud Service Git (or other repository):
Select a branch (more...)
After a lot of reading up on HTML and (more...)
I was doing some clean Oracle Linux 6 and 7 installs today and look what I noticed in the yum repository for OL6.
Available Packages oracle-database-server-12cR2-preinstall.x86_64 1.0-1.el6 public_ol6_latest oracle-rdbms-server-11gR2-preinstall.x86_64 1.0-13.el6 public_ol6_latest oracle-rdbms-server-12cR1-preinstall.x86_64 1.0-14.el6 public_ol6_latest
And for OL7.
Available Packages oracle-database-server-12cR2-preinstall.x86_64 1.0-2.el7 ol7_latest oracle-rdbms-server-11gR2-preinstall.x86_64 1.0-4.el7 ol7_latest oracle-rdbms-server-12cR1-preinstall.x86_64 1.0-5.el7 ol7_latest
A quick look at the repos and it first (more...)
The Oracle Applications User Experience (OAUX) team has loads of new content that we’re eager to share
The Oracle Applications User Experience (OAUX) team has loads of new content that we’re eager to share. Beginning with Oracle Voice, Oracle’s platform on Forbes.com, Group Vice President Jeremy Ashley describes in a recent post how Oracle is addressing specific HCM trends and issues in our cloud application services while keeping that “suite” perspective. What else did we write about in the past month?
LOOKING TO THE ENTERPRISE FUTURE: The OAUX team reports (more...)