(Jeff Smith) Kris (no, not THAT Kris) asks…

(Brendan Tierney) When you install R you also get a set of pre-compiled datasets. These are great for trying out many of the features that are available with R and all the new packages that are being produced on an almost daily basis.

(Natik Ameen) Question: What is the cause of the error “ORA-01110 data file %s”? How do I resolve this?

(Guenadi Jilevski) In the article we will review the prerequisites for the CBO to perform a star query transformation. We will use the SH samples schema. We will look at two cases with and without a bit map join index.

(Jeff) My colleague asked me yesterday how to enable copy and paste in the command line SQL*Plus window on Windows 7 – a simple enough task…

(Andrejus Baranovskis) Our ADF performance audit tool is growing and getting more advanced with each release. Current major update v 5.0 brings ADF Click History integration and allows to track ADF UI client request time. This allows to understand, how long it takes to execute action from user persp

(Zohar Elkayam) Here’s a weird error message for my collection…

(Iggy Fernandez) When tuning a SQL query, I rely on a SQLT report because it has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, recently I came across a case where the SQLT report was not enough.

(Natik Ameen) Question: What is the cause of the “ORA-00918 column ambiguously defined” error? How do I resolve this?

(Jeff Smith) SQL Developer has a DBMS Output panel you can open and add to your desktop. You then add a connection you want to poll, and then you enable polling. It’s about 4 clicks. If you want to increase the default buffer size from 20,000 characters, then that’s a few more clicks and keystrokes.