Anyone who has used Oracle for a while will be familiar with the Parent/Child locking "issue" when it comes to tables and indexes on foreign keys. For many years you’d hear people crying "bug" etc but thankfully most now know the reason, and accept it as sensible behaviour.
But lets take a look at a slight variation on that theme.
Lets start with a table called "LOC" which will be our parent table in (more...)
I’m not in favour of calling books a “must-read”, but if you want to get your own book commercially published, I have to say you must read Write the Perfect Book Proposal: 10 That Sold and Why, 2nd Edition.
The main force of this book is that it explains the publishing industry from the inside: What a publisher is looking for. The authors honestly explain what the publisher will and will not do, and that (more...)
I’ll be going to the UKOUG Tech 14 conference in Liverpool in December to give one of my favorite presentations: “APEX or ADF? From Requirements to Tool Choice”. I’m also leading the Development Tools roundtable, which is always lively at the UKOUG conference. If you want to discuss your options as a developer in the Oracle world, UKOUG Tech 14 is the place to be.
APEX or ADF? From Requirements to Tool Choice
Quick, how many different Web Service specifications are there?
- less than 20
- between 20 and 40
- more than 40
I was in doubt whether the answer would be 1) or 2) – after all, there is a lot of WS-* stuff. Turns out the answer is 3) – there are currently 50 web service specifications.
A technology with 50 specifications is unlearnable. The basics of web services is simple and useful, but the IT industry (more...)
This was going to the be the immediate follow up to my previous post, but 126.96.36.199 came out and I got all excited about that and forgot to post this one :-)
Anyway, the previous post showed how easy it is to convert between nested tables and associative arrays. The nice thing in 12c is that this is no longer needed – you can query the associative arrays directly
One of my favourite security "tricks" used to be the following:
SQL> [create|alter] user MY_USER identified by values 'impossible';
Looks odd, but by setting the encrypted value of someone’s password to something that it is impossible to encrypt to, means you’ll never be able to connect as that account. (Think schema’s owning objects etc).
I hear you ask: "Why not just lock the account?"
Well…in my opinion, that’s a security hole. Let’s (more...)
Oracle Database 188.8.131.52 has been released on 22 July 2014.
Following are some of the new features and options:
• In-memory column store
• Attribute clustering on disk
• Oracle Flashback archive capabilities for pluggable databases
• Rapid Oracle home provisioning
• Centralized security key vault capabilities
• Storage and query capabilities for nonrelational data
• Advanced Index Compression
• Oracle Big Data SQL
• Oracle JSON Document Store
I was recently advising a transition project where a customer was switching support and maintenance supplier. This means that one organization must take over a system that has been maintained by another organization for a number of years.
A lot of information is lost in these transitions because knowledge of the problem domain has been accumulated in the heads of developers over many years. This loss cannot realistically be mitigated.
But sometimes, specific information about (more...)
Well, I finally passed the Oracle Certified Professional (OCP) 12c upgrade exam, 1Z0-060. I got 86% right on the new features section and 78% correct on the general DBA section. So, that means I missed roughly 7 questions on each section which was more than I expected because I felt good about all of my answers.
I’m happy with the three resources I used which are:
- Self Test software – $99
- Matthew Morris (more...)
This is an excellent book with an encyclopedia-like approach to Oracle performance tuning, concentrated around the optimizer. It doesn’t cover architectural changes in the database in the newer releases, like the new redo mechanism with the private strands or the new implementation of the latches and pins. In my opinion, Oracle performance is more than just the optimizer.
Also, the book is very long and without the sections for new features in 12c, which makes (more...)
Today the official program is online for DOAG conference 2014 in Nuremberg. My presentation is confirmed “The Dirty Dozen – ADF Migration to 12c in the IKB”.
I will speak over our experiences with following
- provide user software
- install servers
- iterative test migrations
- migration plannig
- real migration
- and the problems and pitfall’s we find on our way
If you speak german and you are interested in some of this, you should come and attend my (more...)
Hi Oracle Security Folks, The July Oracle Security Alert is out. My part is smaller than last quarter as just an In-Depth Credit, but Mr David Litchfield makes a triumphal return with some excellent new research. http://www.oracle.com/technetwork/topics/security/cpujul2014-1972956.html There is a CVSS 9 and a remote unauthenticated issue in this patch so worth installing this one. [...]
I’ve been following the discussion on the new In-Memory option in the Oracle 184.108.40.206.0 database. As far as I can see, it’s very easy for a developer to start using this feature, which will cost your company $23,000 per CPU at the next Oracle license audit.
But the most interesting part is actually not the cost – it’s the discussion. Oracle expert Kevin Closson stated that there was a problem (more...)
There is a serious problem with export/import utilities between versions.
The first command, executed on Oracle 220.127.116.11, Linux x86_64 was:
[oracle@oradb tmp]$ expdp system directory=tmp dumpfile=oe.dmp schemas=oe
Directory tmp was created as /tmp
Result was the following:
Export: Release 18.104.22.168.0 – Production on Mon Jul 28 22:57:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
Connected to: Oracle Database 11g (more...)
One of the great things about working in IT is that you can often win an argument simply by being right. Not because of who you are or because you are more eloquent than others, but because the facts support your position. Almost every IT person I have ever met respects facts.
In order to win arguments this way, you of course need some facts to work with. And that’s where too many people fail. (more...)
I received an interesting question as a comment on another post (which I’ll approve as soon as I post this one) and I thought it was interesting enough to add a completely separate post on my thoughts. In essence, the comment was along the lines of this: “With so much content and articles do you […]
Observing tourists around me, I’ve noticed that the regular selfie doesn’t cut it anymore. The essential travel accessory for the modern self-absorbed traveller is a selfie stick:
Of course, the whole selfie concept is the opposite of a traditional tourist snapshot: Not “see what I saw,” but “see me”. But while you are at it, why not make yourself a spectacle while you take the picture. Hence, the selfie stick.
The picture is pretty much (more...)
The quarterly PSU and any one-off patches are installed with the opatch utility for your management servers. If your environment consists of a single OMS, executing opatchauto apply will execute all of the tasks required to install the patch on the management server and provide you with SQL to update the repository database. When you have more than one server, that same command runs an analysis of your environment and generates detailed sequential instructions you (more...)
If you want to know about FND Debug log configuration in R12, this below document id is useful for you
How to enable and retrieve FND debug log messages (Doc ID 433199.1)
[appltrng@ebsdev bin]$ frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/PERWSDOR.fmb userid=apps/Ace321b output_file=/u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx module_type=form batch=no compile_all=yes
Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block…
No compilation errors.
Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block…
No compilation errors.
Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block…
No compilation errors.
Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block…
No compilation errors.
Created form file /u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx