Category Archives: Oracle

Not Only SQL

Not every DBA works with NoSQL. However, every DBA (and DBA manager for that matter) should know what it is, or rather what they, are. Rather than try to explain NoSQL myself I’ll recommend the following. The first is a … Continue reading

Posted in Oracle, PostgreSQL, SQL Server | Leave a comment

The Human Brain Project ..and other memory matters.

First off, apologies for neglecting this site even more than usual. I blame life. Well, that plus DIY. And a polecat. But I won’t go into details – this isn’t facebook after all. Anyhow, the human brain project. I first … Continue reading

Posted in DNA, Oracle | Leave a comment

Avoiding Analytic Functions

I’m a big fan of analytic functions in Oracle and I use them now and then ..but probably not enough. I know that a lot of experienced programmers use them less than me, using the excuse that all this malarkey … Continue reading

Quote | Posted on by | Leave a comment

Another BASH

Not a linux shell this time, but an alternative to ASH (and S-ASH). Where I currently work I don’t have the luxury to work with The Oracle Diagnostic and Tuning Packs. It’s perhaps not that surprising as they are a bit … Continue reading

Posted in Oracle | Leave a comment

Virtual Box

Another freebie I guess. I don’t know if anybody has played around with this before but it might be useful should you be sad enough to want to play with Oracle or Linux at home :-). Anyhow, Oracle Virtual Box … Continue reading

Posted in Oracle | Leave a comment

More Free Stuff

I expect most of you know that there is a free version of TOAD (Tool for Oracle Application Development) for Oracle available? I seem to remember that when Quest bought TOAD, the guy who wrote it insisted on this always … Continue reading

Posted in Oracle, Uncategorized | Leave a comment

Free Oracle Book

A free book by the legendary Tom Kyte, courtesy of Redgate As the link says this freebie won’t be around for long. N.B. This link was originally posted here: http://www.freelists.org/list/oracle-l I would recommend people subscribe to this if they work … Continue reading

Posted in Oracle | Leave a comment

Same User Database Links

I’m not sure how many people know this but it’s possible to create a database link without specifying a username or password. If you do this then the link will take the username and password from the currently connected user. … Continue reading

Posted in Oracle | Leave a comment

dbms_output oddities in Oracle 11.1

You’ve all seen countless scripts that show you how much space is being used in each tablespace, for example: but generally speaking they fail to take into account the fact that some of the data files in a tablespace might … Continue reading

Posted in Oracle | Tagged | Leave a comment

Locked Oracle Stats

Oracle datapump is pretty darn impressive, except in a few areas (e.g. having to use oracle diectories and having such a ridiculous name) but it did something a little unexpected to me today. I was creating a new database populated … Continue reading

Posted in Oracle | Leave a comment