Query optimization can feel like an overwhelming task. Where to start? In this blog post, we’ll discuss how to select which queries you really should optimize. This is a step that’s often skipped, but shouldn’t be!

(Martin Berger) datapatch is a nice new feature in recent Oracle database installations. It helps to ensure the databases objects match the binaries after any kind of patching and so avoid situations which can be an operational and support nightmare – and very hard to identify.

(Vikram Das) Recently I spent almost a full day struggling to make out, why an sftp connection would not work without password, after setting up ssh equivalence.

Query optimization can feel like an overwhelming task. Where to start? In this blog post, we’ll discuss how to select which queries you really should optimize. This is a step that’s often skipped, but shouldn’t be!

(mdinh) For most of you, this is probably trivial.

(Andrew Reid) We have some jobs which copy the datafiles from 1 database to another then recreate the control file to give the output database a new name. Some of these jobs are intelligent i.e. they query the input database to dynamically create the SQL to do the rename.

(Wilfred van der Deijl) Running an ADF application on a weblogic cluster is fairly simple. Just deploy the application to the cluster and your done.

(mdinh) For most of you, this is probably trivial.

(Andrew Reid) We have some jobs which copy the datafiles from 1 database to another then recreate the control file to give the output database a new name. Some of these jobs are intelligent i.e. they query the input database to dynamically create the SQL to do the rename.

(Wilfred van der Deijl) Running an ADF application on a weblogic cluster is fairly simple. Just deploy the application to the cluster and your done.