Thursday, January 10, 2008

Security, Performance, PL/SQL, RDBMS


In the ‘I Told You To Not Wake that Sleeping Dog’ Department

A British television personality set out to prove that all these losses of personal computer data are ‘much ado about nothing’.

Well, that was a sad story, because he decided to prove his point by publishing his own data, and an enterprising member fo the TV audience used that data to take a batch of money from his account and transfer it to charity to prove his or her point. Read about the whole thing here.


A good link to a paper from University of Arizona on database forensics at Paul M. Wright’s blog.


Christian Bilien has a great little article on tracking down missing memory (containing all kinds of grotty technical detail).


Using PL/SQL Associative Arrays

ODP.NET developers can use PL/SQL as an API to the data in the database and use associative array binding to reduce network round-trips. The result is a reduced workload for both the network and Oracle Database, which means faster performance and better scalability for your applications.

Read the article.


I don’t know how I missed posting a link to this list of the Seven Deadly Habits of a DBA before.

Expensive Calculator

In the early days of the mini-computer (i.e. before PCs), someone came up with a very simple editing program. You couldn’t realliy call it word processor, because it basically just printed things you typed on paper. They called the program Expensive Typewriter.

Well now you can relive those days of heady misuse of technology thanks to Tanel Poder and his article:

How to use Oracle as an Expensive Calculator.

No comments:

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.