(Richard Foote) In the previous post, I discussed how storing date values within a character data type is a really really bad idea and illustrated how the CBO can easily get its costings totally wrong as a result. A function-based date index helped the CBO get the correct costings and protect the in
Tag: Oracle
Linux User-Group Console
(Michael McLaughlin) This post shows you how to add the menu option and GUI to set users and groups. It’s quite a bit easier than mastering all the command-line syntax. It makes setting up the required user and group accounts for an Oracle Enterprise or MySQL database solution much easier.
MERGE vs UPDATE/INSERT revisited
(connormcdonald) I wrote a few years back that for single row operations, MERGE might in fact have a large overhead than the do-it-yourself approach (ie, attempt an update, if it fails, then do an insert).
Fixed Table x$ktfbue has not statistics
(Anand) While playing around 12.1.0.2 db, I ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high.
Datatypes for DATES
(connormcdonald) Richard Foote has written a post about not using the DATE datatype for storing dates.
Oracle JET Handling ADF BC 12.2.1 REST Validation Event
(Andrejus Baranovskis) I already had a post about how to handle ADF BC validation messages in Oracle JET – Handling ADF BC 12.2.1 REST Validation in Oracle JET. There is an improvement I would like to share. JET submits data to ADF BC REST and there happens validation.
Integration Cloud Service (ICS): Execution Agent proxy issue: NumberFormatException
(Maarten Smeets) Integration Cloud Service (ICS) offers an Execution Agent which you can download and install on-premises. This provides a local ICS instance. The Execution Agent is useful in several situations.
Oracle SGA memory allocation on startup
(Frits Hoogland) Recently I have been presenting on what running on a large intel based NUMA system looks like (OTN EMEA tour in Düsseldorf and Milan, and I will be presenting about this at the Dutch AMIS 25th anniversary event in june).
Let me START WITH sequences
(connormcdonald) It’s always cool that you can learn stuff every single day, even on the most simple of topics.
Options For Pre-EM13c Target Software and Non-Supported OS in EM13c
(Kellyn Pot’Vin-Gorman) Per Oracle documentation, you’re able to upgrade from EM12c to EM13c, including the OMR, (Oracle Management Repository) to DB12c and the OMS, (Oracle Management Service) to EM13c, but leave the agent software at a version of 12.1.0.3 or higher, leaving upgrades of the agents
