Leveraging Web Search Engines
Working as a recognised expert at something is a little…strange, I find.
I had an assignment this week to go visit a client, have a look at a performance issue and find out the root cause. I was also to at least come up with suggested resolutions with the ideal aim of giving them a proven fix they could implement. All to be done in two to three days. This is pretty standard fayre when (more...)
This Log Buffer Edition covers some nifty blog posts from Oracle, SQL Server and MySQL.
- Real Application Testing report On Premise vs. Oracle Public Cloud
- Foreign Keys and Library Cache Locks
- IN/EXISTS bugs by Jonathan Lewis.
- Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action.
- Oracle Cloud : First Impressions
- Hidden Tricks (more...)
I’ve been saying for some time I should do some more entry level content, but it’s been kind-of hard to motivate myself. I mostly write about things I’m learning or actively using, so going back and writing entry level content is not something that usually springs to mind.
Recently I’ve got involved in a number of “grumpy old man” conversations about the lack of SQL knowledge out there. That, combined with a few people at work (more...)
I’ve just responded to the call for items for the “IOUG Quick Tips” booklet for 2015 – so it’s probably about time to post the quick tip that I put into the 2014 issue. It’s probably nothing new to most readers of the blog, but sometimes an old thing presented in a new way offers fresh insights or better comprehension.
A histogram, created in the right way, at the right time, and supported (more...)
There’s so many ways to proceed
To get the knowledge you need
One of the best
Stands out from the rest
COLLABORATE16 – indeed!
Why not be part of the show
By sharing the stuff that you know
Got something to say
For your colleagues each day
Call for papers –> let’s go
I believe many of you would agree that regardless of how insignificant you believe your corner of the Oracle technology may be, (more...)
In this post I would like to describe a behavior of Oracle Database that, at least for me, isn’t obvious at all. Actually, it’s something that I can’t explain why it works in that way.
Let’s start by setting the scene by describing the schema I’m using for the following tests. As you can see from the image, there are three tables: one table (PARENT) that is referenced by two other tables (CHILD1 and CHILD2). (more...)
All seasonal Oracle Apps DBAs know that Autoconfig is the master utility that can configure the whole E-Business Suite Instance. In E-Business Suite releases 11i, 12.0 and 12.1 running Autoconfig recreated all the relevant configurations files used by Apache server. If the context file has the correct settings, then configuration files should include the correct setting after running Autoconfig. This is not the case anymore in Oracle E-Business Suite 12.2. Some of (more...)
Well holiday is now over (hence the lack of blog posts for a while) and it's back to the normal day to day work.
An interesting post though to shake off the post holiday blues (inspired by an oracle forums question).
The basic problem was that they wanted to take a full schema export but the dictionary table containing the sequences (SEQ$) has a block corruption and the job keeps failing.
How do i therefore (more...)
Looking forward to speaking at
Please come join me !
I lived in Portland between 2006-2008 and love city. It will be fun being back.
8:15 – 9:00 Keynote “EBS Strategy and Roadmap” – Vanessa Paskill
|9:15 10:15||Practical Tips for Oracle Business Intelligence Applications 11g Implementations (Michael Raney, Rittman Mead)||Lessons learned while Integrating Procurement Cards with Internet Expense (Ashish Nagarkar, AST (more...)|
Customers have been waiting for a Standard Edition release for version 188.8.131.52. Then, in July, a support engineer leaked that there will be a whole new type of “Edition”, called “Standard Edition 2″ to replace both “Standard Edition” and “Standard Edition One”. The respective MOS Note disappeared shortly after the accidental publication. Now today the release finally became official and can be downloaded via OTN. The “SE2″ is priced exactly as the (more...)
Amazon has just released their RDS Migration Tool, and Pythian has recently undertaken training to use for our clients. I wanted to share my initial thoughts on the tool, give some background on its internals, and provide a walk-through on the functionality it will be most commonly used for.
There are many factors to consider when evaluating cloud service providers, including cost, performance, and high availability and disaster recovery options. One of the most critical (more...)
So one of the things I like to do is test out a lot of my python gaming code, (as far as for the coding and syntax) on my Oracle Virtualbox image of my Raspberry Pi. Another great thing about building games on the Raspberry Pi, is a built in module called Pygame. Well, that doesn’t exist on the Raspberry Pi image and it really limits what we can do when it comes to the (more...)
Last night was Oracle Midlands event #11 with Chris Antognini.
The lead up to this event was not the best for me. I had been on the verge of a headache all day. By 14:00 I gave up, went home and went to sleep for a couple of hours. It wasn’t great, but it was just enough to take the edge off, so when the time came, I felt sort-of OK to head out for (more...)
Although EM12c R5 (184.108.40.206) was released about 2.5 months ago, I couldn’t find time to upgrade our EM12c system until now. I have decided to dedicate my day for upgrading our EM12c. I’m not planning to write a step by step document because it’s already documented well by other bloggers. I’ll just share my notes if I encounter any problem.
I have probably told several times that EM12c should have some (more...)
Here’s a simple data set – I’m only interested in three of the columns in the work that follows, but it’s a data set that I use for a number of different models:
execute dbms_random.seed(0) create table t1 nologging as with generator as ( select --+ materialize rownum id from dual connect by level <= 1e4 ) select trunc(dbms_random.value(0,1000)) n_1000, trunc(dbms_random.value(0,750)) n_750, trunc(dbms_random.value(0,600)) n_600, trunc(dbms_random.value(0,400)) n_400, trunc(dbms_random.value(0,90)) n_90, trunc(dbms_random. (more...)
In the last week, I had couple of my customer ask me the same question: how can we move our data files between disks with minimum downtime?
This is actually a really good question. When we want to move a database around (let’s say to a new storage or a new disk device) we will need to do it when the files are closed (offline or database down) in order to keep them consistent. We (more...)
Here’s a thought that came to me while I was writing up a note about identifying redundant indexes a few minutes ago. Sometimes you end up supporting applications with unexpected duplication of data and indexes and need to find ways to reduce overheads. Here’s some code modelling a scenario that I’ve seen more often than I like (actually, just once would be more often than I’d like):
create table t1 nologging as with generator as (more...)