databasejournal.com databasejournal.com

Oracle's Block Browser and Editor tool

In a prior article on Oracle’s Block Browser and Editor tool (BBED), the installation of the tool was covered. In this article, we’ll look at starting a session using a simple database and see how to view data. The database used in this example is minimal in terms of structure. Use dbca to create a general purpose database and pick a sample schema such as SCOTT to practice on. This simplifies what you have to find. The...

databasejournal.com databasejournal.com

Oracle Invisible Indexes and Index Usability

Within the many development shops I’ve worked in, it has been my observation that many of the decisions to create an index in production have not always been soundly rooted in explain plan analysis or even looking at application code. More often than not, someone just thinks a column or set of columns look good enough for an index to be placed on them. This is a completely off-the-cuff reaction to hunches and folklore. What often...

databasejournal.com databasejournal.com

Leveraging Oracle 11g Data Guard for Database Backup and Recovery

Synopsis. Oracle Data Guard makes it possible to back up a production database using a valid physical standby database as the target for the backups, and those same backups can be used to restore and recover a production database. This article – the fourth in this ongoing series – demonstrates how Oracle Database 11g expands these features to virtually guarantee against any data losses while simultaneously offloading the...

databasejournal.com databasejournal.com

VMware and Oracle Setup Examples - Part 2

In the last article, covering the installation of Oracle9i on Windows 2003 Server on VMware Workstation, we saw how a virtual machine application could make creating what appears to be an odd environment fairly easy to accomplish. Why spend time building an Oracle9i environment, you may ask. The fact is that not every business using Oracle has moved out of the relative dark ages with respect to versions of the RDBMS. If you have the...

databasejournal.com databasejournal.com

Oracle Concepts: Splitting Hairs

How many times have you heard the phrase, “Same thing, but different?” In Oracle, there are many concepts where this applies. Physical files, for example, can be the same, but how they are used is different. RMAN operations can delete, but the type of backup item deleted can be different. Replaying database operations can be the same, but different as to how that is performed. The point of this article is to not really split...

databasejournal.com databasejournal.com

Joining Disparate Data in an Oracle Database

What if you have two data sources, such as flat files or table data, and have to merge or join them together? If there is a common attribute, such as customer ID, the solution should be pretty obvious: join the related attribute, and in this example, the customer ID suffices. What if the sources have nothing in common? The only requirement is that a record in source 1 gets matched up to a record in source 2. Further, it doesn’t...

databasejournal.com databasejournal.com

Intro to Oracle's Automatic Workload Repository (AWR)

Introduction For those of you who've used the longstanding statspack, you'll find a lot that is familiar with AWR.  and for those new to this method of performance tuning, you'll be happy to learn about all the additions that make AWR better, and easier to work with. Improvements Over Statspack The old statspack had to be installed manually.  Although not a complicated setup, having AWR already there makes it that much...