Users are always complaint about siebel erp integration performance issue when they are doing push the approval data to erp r12. It will take approximately 2 to 4 minutes.
So I took the awr reports from both database and crosschecked both with some interval, the siebel database performance is good but erp database saying there is integration related packages sql elasped time little bit more.
So i just went to siebel application and look the all components group log (more...)
In the previous parts (here and here) of the series we looked at some aspects of nested loop I/O optimizations, but we have left out the most important question (from the practical point of view): how these methods are doing time-wise? Which one(s) is(are) faster, and how much savings are they offering compared to the non-optimized plan? We will turn to these questions now.
First of all, if we simply run everything with (more...)
Delphix support helped me resolve an issue yesterday and the experience gave me the idea of writing this post about several general computer issue troubleshooting tips that I have learned down through the years. Never mind that I ignored these lessons during this particular problem. This is more of a “do as I say” and not a “do as I do” story. Actually, some times I remember these lessons. I didn’t do so well this (more...)
I based this blog post on information that I learned from this Oracle Support document:
Runinstaller And Emctl Do Not Work After Upgrading HP-UX 11.31 To 11.31 Update3 (Sep 2008) (Doc ID 780102.1)
My situation was slightly different from what Oracle’s note describes so I thought it would be helpful to document what I found.
In my case I am cloning an Oracle 10.2.0.3 home on to a fully (more...)
HCM Data Loader (HDL) data ready to load into Oracle HCM Cloud is in pipe separated text file format, however most people will create and manipulate these files in MS Excel as it’s the handy swiss-army-knife for data manipulation that almost everyone is familiar with.
The way that we’ve worked is that we create template files containing the sheets and columns corresponding to the fields that the client is using, which the client then populates, (more...)
We are excited to post the first in our Oracle Forms 12c guest series and introduce our first contributor and a loyal member of the Oracle Forms Community, Holger Lehmann. If you’re a Forms guru and want to contribute click here for more information
We also have an awesome upcoming Oracle Forms 12c webinar with Michael :WEBINAR: ORACLE FORMS 12C: NEW FEATURES UNVEILED AND EXPLAINED – Register here!
Oracle Forms 12: New Runtime Options (more...)
In the previous part of this mini-series we looked at differences in multiblock read behavior for different nested loop optimization mechanisms depending on degree of ordering of the data. In this post I’ll continue to explore the subject, but this time we’ll focus on decision-making process: what factors (other than the obvious ones — like optimizer hints and/or parameters) affect the specific choice of a mechanism?
Previously, we saw that in all nested (more...)
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
The Fusion Tipster Blog
So, according to the summary, the most popular post was Introducing OTBI-E, followed by What’s Coming in Taleo 14B, and then the posts on specialisation. Of those, only the former was written in 2015, with the other two coming from 2014. The other popular posts written in 2015 (more...)
Next Tuesday at 11:20 am at Oracle headquarters there will be a panel discussion on SQL. You can participate whether you are there or not as we are collecting questions ahead of time and will video the panel to be posted later. The panel’s participants will be
In my last blog I talked about trying out Jenkins. In this blog post I want to talk about the new Jenkins plugin for Delphix.
Delphix plugin is easy to add. Just navigate to “Manage Jenkins” in the top left
Then click on “Manage Plugins”
Then type in “delphix” in the search bar and then click on the “Delphix Jenkins plugin” to install
Now we can access Delphix APIs through the Jenkins (more...)
Jenkins seems to be the top code build, integration and QA automation tool to support continuous delivery.
Jenkins allows me to kick of jobs on a schedule or ofter certain events and Jenkins will keep track of the status of the jobs and the results.
To get Jenkins installed, I read wiki.jenkins-ci.org and then read biouno.org to try my first Jenkins example.
I installed Jenkins on one of the VMs from the “landshark” demo environment for (more...)
Here is another graph that I created in Python with Pyplot:
This is onewait.py on my github repository. Note that I blanked out the database name in the example graph to hide it.
This is a graphical version of my onewaitevent.sql script. It queries the AWR looking at a particular wait event per hour. You look at the number of wait events in an hour to see how busy the system was and then (more...)
Wow, this is big – a Yes SQL conference !
Finally ! It’s here ! Yes SQL ! the conference!
At Oracle headquarters !
Send me your questions!
Have questions about SQL? about No SQL? about Yes SQL? About how Oracle is faring in the industry with SQL? I’ll be moderating a SQL panel discussion with
- Andy Mendelsohn (Executive Vice President for Database Server Technologies)
- George Lumpkin (Vice President, Product Management)
- Bryn Llewellyn (Distinguished Product Manager)
- Steven Feuerstein (Developer Advocate)
Nested loop join appears like the simplest thing there could be — you go through one table, and as you go, per each row found you probe the second table to see if you find any matching rows. But thanks to a number of optimizations introduced in recent Oracle releases, it has become much more complex than that. Randolf Geist has written a great series of posts about this join mechanism (part 1, (more...)
Last year was very eventful at FOEX, which kept me occupied and kept me from blogging. Thankfully I managed to attend a few conferences and stay in touch with the community through Twitter and Slack on apex.world.
FOEX is growing a lot and needed a new website design, so we had a brainstorming meeting and decided to again build it in APEX.
Last week we finally decided everything for the website was ready (more...)
Here’s where I’ll hang out in the following months:
26-28 January 2016: BIWA Summit 2016 in Redwood Shores, CA
10-11 February 2016: RMOUG Training Days in Denver, CO
25 February 2016: Yorkshire Database (YoDB) in Leeds, UK
6-10 March (more...)
What would you think if you receive a complaint about plan regression with the following information (from SQL real-time monitoring report) about the good plan:
| Elapsed | Cpu | IO | Concurrency | Fetch | Buffer | Read | Read |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes |
| 99 | 64 | 36 | 0.00 | 6 | (more...)
Sometimes you want to know what’s inside a certain block. Of course, the most straightforward way to do it is by dumping block contents using ALTER SYSTEM DUMP DATAFILE contents and analyzing it. However, “straightforward” doesn’t mean “simple”. Block dumps represent its contents in binary format which is hard to read. Sure, there are various utilities (like utl_raw) that can help you convert everything to the human-readable format, but it’s going to be a tedious (more...)
Year 2015 was a very good one for me, even though not exactly in a way I expected it to be. I didn’t get to blog as much as I wanted to, and I didn’t get as many interesting performance troubleshooting to do as years before that. But there was lots of other interesting experiences — e.g. designing, running and analyzing all sorts of sophisticated performance tests for a candidate hardware platform.
Of course, (more...)
Terminal applications like iTerm2 are a great way to improve your efficiency when connecting to a remote host on your Mac. As I started making my own shortcut keys I hit the wall.
When I have an OEM agent to check, I’ll log into the box, sudo to the binary owner, go the agent bin directory, and execute emctl status agent.
Here’s the wall: Shortcut keys from iTerm could change directory and execute a command, (more...)