(Jeff Smith) Dealing with a complex data type?

(Guenadi Jilevski) In the article, you will have a look at the partial indexes available since Oracle 12c. The partial indexes enable us to index only certain partitions of a partitioned able and avoid indexing of the other partitions of the same table. The partial indexes can be either global or lo

(Iggy Fernandez) SQLT is a tool that collects comprehensive information on all aspects of a SQL performance problem. SQL tuning experts know that EXPLAIN PLAN is only the proverbial tip of the iceberg but the fact is not well recognized by the Oracle database community, so much evangelization is nec

(Maarten Smeets) Oracle Mobile Cloud Service is a mobile backend as a service. MCS does its magic by providing a lot of features to make implementing mobile services easy such as (among many others) authentication, logging/analytics, lookups and calling other services.

(Jeff Smith) Someone on the Forums (yes, we read and respond!) noticed they couldn’t add Bytes or Time to their plan displays in Oracle SQL Developer.

(Uwe Hesse) A useful enhancement in 12cR2 is that password files are automatically synchronized in a Data Guard environment:

(Zohar Elkayam) In some conditions, I need to find the top N queries for a specific user in the database.

(Ben Brumm) I explain what a primary key and foreign key is, as well as the differences between primary key vs foreign key in this article.

(David Fitzjarrell) Oracle has provided access to its wait interface for several releases and with each new release it expands the range of wait information available, so much so that it’s hard to not find something to examine.

(Jeffrey Kemp) If you have an Interactive Report with the Subscription feature enabled, users can “subscribe” to the report, getting a daily email with the results of the report. Unfortunately, however, this feature doesn’t work as expected if it relies on session state – e.g. if the query uses bind