News, views, tips and tricks on Oracle and other fun stuff

Oracle Database 12c: Interactive Quick Reference

12c DB Architecture

Comments Off on Oracle Database 12c: Interactive Quick Reference | Filed in Oracle | Tags: ,

External Table Preprocessor Feature in Oracle Database

Here is a great use case of the preprocessor feature with external tables in Oracle RDBMS.

Here are a few more use cases and resources about this little known feature:

Are you using this feature in your production environment?

Comments Off on External Table Preprocessor Feature in Oracle Database | Filed in Oracle | Tags:

Oracle Database 11g Interactive Quick Reference

Via Harald van Breederode:

Just a quick note about the Oracle Database 11g Interactive Quick Reference That was released today to the public. This Interactive Quick Reference, created by Oracle University and the Server Technology Curriculum group, is your Essential Guide to Oracle Database 11g Release 2. This interactive quick reference includes an architecture diagram, a comprehensive list of background processes and an extensive list of DBA views organized by product feature areas.

Nicely done! Wish the columns in the DBA views had comments though.

Comments Off on Oracle Database 11g Interactive Quick Reference | Filed in Oracle | Tags: ,

What really happens when you navigate to a URL

As a software developer, you certainly have a high-level picture of how web apps work and what kinds of technologies are involved: the browser, HTTP, HTML, web server, request handlers, and so on.

In this article, we will take a deeper look at the sequence of events that take place when you visit a URL. More…

2 Comments | Filed in Links | Tags: ,

A Sneak Preview of The New OTN Special Edition Web Site

Back in early October, Justin blogged about a new project called “OTN, Special Edition”. He also mentioned that it might be called “MyOTN – Beta Edition”.

…Imagine a completely RSS-based version of OTN that allows you to filter your view based on tag (topic) or contributor, for Website content as well as discussion forum threads… Think of it as an “interactive” search process, with the relevant keywords being supplied to you, instead of the other way around.

That’s how Justin described the new project. As a teaser, he posted three low resolution screenshots and did not provide a link to the new OTN site.

Well, I was lucky enough to stumble upon the “OTN, Special Edition” demo URL. I will not publish the URL because it is not hosted on and it will most likely change when OTN goes public with its Special Edition. But, I have recorded a screencast of the new OTN site. I have also taken a few high resolution screenshots. All I can say is that it is really cool.

otnse-sshot-0.png otnse-sshot-1.png otnse-sshot-11.png otnse-sshot-3.png otnse-sshot-4.png

Click on a thumbnail to view a larger size screenshot

2 Comments | Filed in Oracle, Technology | Tags: , ,

Quick Reference Cards

Quick Reference Cards is a web page containing a collection of PDF documents that you can reference when working on many technologies like Oracle, Java, SQL, XML, and many other categories.

Comments Off on Quick Reference Cards | Filed in Technology | Tags:

Google Guide: Help with Searching

Google Guide: Help with Searching: If you’re like many people, you use only a small number of Google’s services and features. The more you know about how Google works, its features and capabilities, the better it can serve your needs.

Just as the best way to learn how to sail is to sail, the best way to learn how to search with Google is to search with Google. Consequently this Google tutorial contains many examples and exercises designed to give you practice with the material presented and to inspire you to find amusing or useful information.

In Google Guide you can learn:

  • How to select terms and search (more) effectively
  • How Google interprets your query
  • What’s included with your results
  • How to search using Google’s special tools and shortcuts
  • What to do when you can’t find the answer you want
  • When Google added services, features, and options (Google’s Feature History)
  • How Google works
Comments Off on Google Guide: Help with Searching | Filed in Interesting | Tags: ,