(Pavel Descoteaux) This script provides datafile location and storage information for the connected database. The script works with UNIX, Linux, or Windows. Simply run this procedure with DBA Administrator privileges so that all SYS objects can be queried.

(Lewis R Cunningham) There have been a lot of blogging about the new Oracle features like SQL Tuning Advisor, SQL Access Advisor, AWM, the scheduler, etc. Here are a few items that I haven’t heard much about but are nifty little time savers. These are the kinds of things that make life just a little

(Ryan Naraine) Enterprise software giant Oracle has released a fix for an incomplete database server patch after a private security research outfit discovered that the underlying vulnerability was never addressed.

(Arup Nanda) The Self-Managing Database becomes even more so with an Automatic Storage Management command-line tool, direct-attached SGA access, support for online partition redefinition, and more.

(Steven Swafford) Are you are a developer who works with an Oracle database? Have you been using SQL Plus or any of the other third-party tools for performing everyday database tasks, when what you really desire is a way to access your database within the Visual Studio .NET IDE? Steven Swafford has

(Mark Brunelli) The newly unveiled Oracle Database 10g Release 2 offers enhanced automated features designed to ease the burden of statistics collection and analysis. SearchOracle.com caught up with Mark Townsend, Oracle’s senior director of database product management, to discuss these new features

(Rich Schwerin) Working vacation. Concise tax code. Bipartisan cooperation. Simplified Enterprise JavaBeans (EJB). Pop quiz: Which one isn’t an oxymoron? If you chose EJB, you must be familiar with the goal of EJB 3.0—to simplify the development of Java applications and standardize the persistence a

(James Koopmann) The spelling is so easy and even rolls off our lips with simplicity. The fact of the matter is this language has caused more agony than one can imagine. I get dozens of emails and forum posts every week, wanting to know how to extract or insert data from a RDBMS. Developers I have w

(Lewis R Cunningham) I finally got a chance to take a brief look at Beta 2 of EnterpriseDB. The first thing I did was try the same procedures that I created in my last look, EnterpriseDB – My First Look. Everything compiled and when I ran it, I got the same error as in beta 1.

(Scott Stephens) Expression Filters are a new feature that was introduced with Oracle 10g. Unfortunately, the number of examples and information about this feature are still hard to find.