(Dbaharrison) Today we had a strange issue when doing a standby switchover related to NLS – we had built the standby with the exact same NLS_SETTINGS in the spfile as the primary – see list below

(Emil Kleszcz) In this entry I would like to share my experiences using Oracle Java Cloud Service, especially securing the application environment.

(John Brady) A general rule of thumb with queries in Oracle is to use just one query when you can and leave it to the Optimizer to work out the best possible execution plan i.e. decomposing one query into multiple separate queries can end up making the database do more work than it needs to.

(Andrejus Baranovskis) You can end up into long lines of JavaScript code when implementing more complex use cases in JET. This will complicate maintenance and make code hardly readable.

(Hemant K Chitale) Most default installation guides for Grid Infrastructure will have you creating a DATA Disk Group during the install. This results in the OCR, the Vote Disk and MGMTDB being created in the same DATA Disk Group.

(amitzil) When user A creates a procedure and grants execute permissions to user B, user B can execute the procedure (obviously), but he can also see the code (in ALL_SOURCE view).

(mwidlake) Way back in 2004 I was working at the UK side of the Human Genome project. We were creating a massive store of DNA sequences in an Oracle database (this was one of two world-wide available stores of this information, for free & open use by anyone {* see note!}).

(Ben) In this article, we look at the Oracle COS function and see some examples.

(Abhinav Shroff) This blog will help you understand deployment of Dropwizard application on Oracle Application Container Cloud Service using Developer Cloud Service.

(mdinh) This is a quick and dirty note to self about Doc ID 1387859.1 which may be incorrect for Single Instance Database with Oracle Restart.