Oracle Virtualization and Cloud Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Understanding enhancements to block cleanouts in Exadata part 2

In part 1 of the series I tried to explain (probably a bit too verbose when it came to session statistics) what the effect is of delayed block cleanout and buffered I/O. In the final example the “dirty” blocks on disk have been cleaned out in the buffer cache, greatly reducing the amount of work to be done when reading them.

US President talks about Data Science

Check out the video of US President talking about Data Science and the first Chief Data Scientist of the USA talks about his mission.

Oracle Database In-Memory Advisor Released

Oracle Database In-Memory option was released with Oracle
Database 12c (12.1.0.2) and the In-Memory Advisor (IMA) has been much awaited
since then. The Oracle Database In-Memory is designed to achieve the following
goals:

How will the BI industry progress in 2015? [VIDEO]

Transcript

Hi, welcome to RDX! Nowadays, almost every company uses business intelligence tools. Whether measuring return on investment or identifying your most popular products, BI can be an integral part of your operation.

But how will the technology progress in 2015? For one thing, it’s likely that new iterations of relational databases will receive integrated analytics functions. SQL Server is one particular solution that has become more compatible with Power BI, Microsoft’s signature BI application.

Alexandria PL/SQL Utility Library moved to GitHub

The PL/SQL Utility Library, codenamed "Alexandria", now has a new home at GitHub. This will make it easier to collaborate on the project. If you want to contribute, just fork and submit a pull request.

Rocky Mountain High

As I headed to Denver to attend the Rocky Mountain Oracle Users Group’s (RMOUG) training days, I was pretty excited to get to warmer weather. Typically people don’t say that they are going to Denver to warm up but as I entered my car in the morning it was -22 C. This would be my first visit to RMOUG […]

Error in invoking target 'rat_on part_on dm_on olap_on sdo_on'

Today while i was browsing on Oracle Fourms i found Threads related to 11gR2 Installation , the OP faced an error like the below :-

Introducing the Official LinkedIn APEX Group

Once upon a time I had a laugh on facebook when someone posted an image showing multiple groups dedicated to stopping duplicate groups, oh the irony.

Recently I've been trying to share my blog posts via LinkedIn but I'm always unsure which of the seven APEX groups I'm a member of I should post to.

RETURNING BULK COLLECT and database links

Looks like the nice PL/SQL facility for returning a set of updated rows is restricted when it comes to database links
(This tested on 12.1.0.1)

Merge, Right?

"There are no wrong roads to anywhere."
- Norton Juster, The Phantom Tollbooth

Oracle can do some, well, strange things when fixing issues caused by the optimizer. For 10g releases up to 10.2.0.x Oracle chose to silently ignore a message and eliminate an outer join on the MERGE statement under certain conditions. Let’s examine this and see exactly what Oracle implements.
Occasionally in a 10046 trace file generated from 10g releases prior to 10.2.0.x and procesed by the tkprof utility you may see something similar to this:

view counter