(dna2) This is a small tool for creating and executing queries. The main purpose of this article is to create an Oracle query tool with syntax coloring. This article is written using Visual Basic 2005 Express Edition and requires Microsoft NET Framework v2.0 to run.

(Sreeram Surapaneni) Oracle Database 10g’s mantra is simpler, more automated database management. We DBAs cannot help but get excited about all the new technology that Oracle routinely releases. With the release of Oracle’s Volume Manager and File system built into the Database kernel (ASM) that ent

(Pankaj Borole) This script will find user information, object count (as per object_type), roles assigned, and system privileges.

(Steve Callan) The new server using Red Hat is up and running, Oracle RDBMS software has been installed, a new instance is running with all of the new features you can possibly imagine (at long last, run_fast=true is available), and “all” that’s left to do is migrate the source database (or schema)

(Charles Garry) Opinion: The open-source database community is too resilient and diffuse for even Oracle to subvert, despite the sinister conspiracy theories swirling around the recent buyouts of Innobase and Sleepycat Software.

(John Kanagaraj, Arun Kumar and Richard Stroupe) Many of the new features in Oracle Database 10g add new functionality, while others remove minor limitations that used to exist before or change the way a particular action was done. (pdf)

(Ron Hardman) We predict potential outcomes based on actions every day. If I speed in my car, I have a much higher likelihood of being pulled over by the police than if I observe the speed limit. Choosing a burger and fries every day at lunch rather than a more nutritious meal is likely to lead to p

(Scott Robinson) Tables are everything to IT database managers in ERP database environments. The organization of database tables, their relationships, and the manner in which they are managed are a fair indicator of the overall quality of performance you can expect from the system.

(Charles Babcock) Oracle has taken the plunge into enterprise search, an area that has businesses trying to strike a balance between improved information access and fears of employees viewing and disclosing sensitive data.

Oracle Database 10g’s Automatic Storage Management (ASM) delivers previously unattainable levels of storage management efficiency through highly automated, application-centric rules and policies that reduce many hands-on tasks to the point of elimination. Oracle customers shared their experiences wi