Learning is not a spectator sport

When it comes to hardware, the Fusion Apps installation guide is surprisingly non-committal: 4.2.1 Hardware Requirements Consult an Oracle Fusion Applications sizing-certified representative to obtain specific, customized system hardware requirements Some googling suggests that Fusion Apps is going plonk the following on your system: – several databases – many many WebLogic servers and the general Read more

Lots of goodies in 11gR2 GoldenGate. The big one seems to be “Integrated Capture”, which seems to be a moving of the capture processing closer to the database (did anyone say “Streams” :-)) The benefit of that is that lots of the boutique data types and compression etc, are all now supported by Goldengate. More Read more

A thoroughly enjoyable day at the first day of ACE director briefings. Of course, all of this stuff is Non-Disclosure so I cant really reveal any of the content, but as soon as OpenWorld is complete, then many of those restrictions will be lifted and we can all bask in the features that are coming. Read more

….is going to be the next release. [which is about all I can say at the moment] How cool is that …     Read more

Check out the execution plan differences here. The fully qualified date (2nd one) gets it right, and note that the optimizer gains the partition start / stop information. SQL> select fds.fin_account_num, 2 sum(fds.sales) as sales from whs.fin_day_summary fds 3 where activity_date >= to_date(’30-08-12′,’dd-mm-yy’) – 390 4 and activity_date <= to_date('30-08-12','dd-mm-yy') 5 and fds.fin_account_num is not Read more

If you’re at OpenWorld…then get some awesome additional content AND beer AND real life stories   ALL FOR FREE !   http://oaktableworld.com/ Read more

When you see this SQL> with xyz 2 ( 3 select 1 my_alias from dual 4 ) 5 select * from xyz; ( * ERROR at line 2: ORA-32033: unsupported column aliasing your first thought might be that there is something wrong with the column alias “my_alias”. In fact, it got nothing to do with Read more

If you are in Melbourne this week, hopefully you’ve registered for the InSync conference (www.insync12.com.au), which is the main user group conference in Australia. I’d love you to come share in my year long journey with Oracle clusterware and RAC upgrades on Tuesday afternoon. Pop in and say hi… Read more

A client has been seeing this error when holding sessions open over HS for lengthy periods of time (greater than an hour or so). Some workarounds that have worked are: when possible, issue, alter session close database link, and re-open it for subsequent queries   Set INBOUND_CONNECT_TIMEOUT_<listener_name>=0 in listener.ora Set SQLNET.INBOUND_CONNECT_TIMEOUT=0 in sqlnet.ora Read more

“Back in the day”, bitmap indexes on tables meant any kind of DML was going kill you either for the concurrency, or the performance. The concurrency issue still applies, but with each version of Oracle, the cost of maintaining bitmaps is still significant but might still be acceptable for you We can see some simple Read more

This is a package that you can call, that does not exist in the database. I found this out after reading about its usage, and then running a DESCRIBE, and of course, finding nothing. Then I hunted through the familiar $ORACLE_HOME/rdbms/admin directory, looking for it….alas to no avail. Why is it not there ? Because Read more

I think this feature came around ages ago (10.2?) but I’m still always impressed by it every time I use it. You can run EXPLAIN on a CREATE INDEX command SQL> explain plan for create index IX on MY_TABLE ( bet_account_num ); Explained. ————————————————————————————– | Id | Operation | Name | Rows | Bytes | Read more