(Andrejus Baranovskis) One of the common use cases in enteprise applications is to track concurrent user changes.

(Hemant K Chitale) Reviewing my second blog post in this series, I found it strange that Partition P_100 (populated by Serial Inserts of 1 row, 100,000 rows, 500,000 rows and 500,000 rows) had such a High Water Mark.

(mdinh) I have been conversing with Liron Amitzi on twitter about his tablespace free SQL script.

(Dirk Nachbar) This is part 3 of the ALTER USER RENAME series

(David Fitzjarrell) Interesting questions can be posted in the Oracle database forums and one recent post generated a great deal of attention. A query and part of the execution plan were posted with the poster asking how to get rid of the table scan. The table has a primary key index so, on the face

(Maarten Smeets) Oracle provides ICS (Integration Cloud Service) as a simple means for citizen developers to do integrations in the cloud and between cloud and on-premises. On the Oracle Fusion Middleware Partner Community Forum I got a chance to get some hand-on experience with this product in one

(Martien van den Akker) To be able to use BAM12c together with BPM12c, you’ll need to enable process analytics. This means that only when that is enabled BAM12c will write the sample data to the proces cubes/star schema.

(Hemant K Chitale) Building on Posts 2 (Adding Rows) and 3 (Adding Partitions) where we saw Table Partitions using 8MB Extents ….. is there a way to “resize” Partitions to smaller Extents (and, maybe, lesser space consumed) without using Compression ?

(Anthony Shorten) The Oracle Functional/Load Testing Advanced Pack for Oracle Utilities is a service based automated testing solution based around the popular Oracle Application Testing Suite. The main focus of this product to allow implementations of Oracle Utilities products to adopt automated tes

(David Fitzjarrell) Oracle takes a rather simplistic view of the cost of deletes, which in most cases is fine. Small deletes, of say 1000 rows or less, really have no appreciable additional costs; larger deletes however can have additional overhead that isn’t taken into account by the optimizer when