(Neil Chandler) One of the major problems with interval-based partitioning is the statistics. Partitions appear dynamically as-needed based upon data being inserted or udpated, and any partition magically appearing isn’t going to have any statistics.

(Kellyn Pot’Vin) There is a flurry of excitement about Enterprise Manager 13c and I’m blown away by how many customers are looking not just to install and test out the new release, but have plans already underway to upgrade to it.

(stewashton) At last, here is the first complete solution to the problem of dividing a table into 12 chunks with equal numbers of blocks. James Su and I proposed this solution on OTN, but without the “filtered_extents” optimisation.

(connormcdonald) You might be thinking that FIRST_ROWS is pretty much the same as FIRST_ROWS_1, since they are both after the first row. However, there are some important distinctions to make here.

(Natik Ameen) Are you moving you OCR and Voting disks from one storage to another? Read the step-by-step instructions on how to to move these files to a different diskgroup.

(Lucas Jellema) This article describes my first steps with the fairly new Oracle Application Container Cloud [Service]. At this point in time, Oracle Application Container Cloud includes Oracle Java SE Cloud Service, which lets you deploy Java applications to the Oracle Cloud, and Oracle Node Cloud

(Richard Harrison) This past week the topic of archiving came up – the thing that everyone talks about but no-one does….

(Hemant K Chitale) In the previous blog, I demonstrated creating an empty table with BASIC Compression and then populating it.

(connormcdonald) I’ve been doing a series on Analytics here but if you need to group data into ranges, you don’t necessarily need a fancy analytic.

(Randolf Geist) The following is probably only relevant for customers that run Oracle on big servers with lots of cores in single instance mode (this specific problem here doesn’t reproduce in a RAC environment, see below for an explanation why), like one of my clients that makes use of the Exadata