Business Intelligence Publisher – The “Other” Oracle Reports
:
BI Publisher is a tremendously powerful reporting tool. It is based on a widely accepted standardized open source language (XML, it is feature rich in terms of what it can produce and it empowers users to query, view, and format their own reports. Read on to learn more.
Product Review – Toad Data Modeler 3
:
Quest Software has hit the ball out of the park with its Toad Data Modeler 3 (TDM) application. Ease of use, a huge amount of functionality, and an outstanding support base all combine to make TDM a superb product. Read on to learn more…
Product Review: Oracle PL/SQL Tuning
:
Books on PL/SQL, like books on other topics related to Oracle, range from the just so-so to what can be
called bible status. With respect to PL/SQL, tuning included or not, Tim Hall’s book is one of those high return
on investment purchases.
Making Database Administration Easier with Freeware
:
Cygwin, an OpenSSH application, helps relieve the stress of more commonly seen administration problems, including not being
able to get a GUI tool (e.g., Oracle Universal Installer) to display and not being able to have it display at the correct location.
Product Review: HyperBac for Oracle
:
A relatively new product called HyperBac provides an excellent alternative to Oracle 10gR2 compressed backupset methodology without the need to modify any RMAN backup, restoration, and recovery scripts. This article provides an overview of HyperBac features that nicely complement Oracle 10gR2's enhancements to database backups and exports.
Quest
Code Tester for Oracle : Steve Callan reviews Quest Code Tester for
Oracle, a new product from Quest that allows developers to generate test code
from user descriptions, then run tests with the press of a button.
Review:
Oracle Performance Tuning for 10gR2, Second Edition : Steve Callan
offers an indepth look into Gavin Powell's Oracle Performance Tuning for 10gR2,
Second Edition. The first article of this series covers Identifying Tools,
Explain Plan, Other tools and Performance views.
Product
Review: EMS SQL Manager : SQL Manager for Oracle is an affordable
compromise between Quest’s TOAD and Oracle’s SQL Developer. Read on to find out
why Steve Callan gives this product two thumbs up.
Quest
Software and Toad for Oracle : Join Steve Callan for a peek into Quest
Software's database development and administration tool, Toad for Oracle.
Trees
and Hierarchies in Oracle : An excellent book by Joe Celko (Joe Celko's
Trees and Hierarchies in SQL for Smarties) shows several means of arranging
hierarchical data. This article combines the familiar emp table and some of the
examples shown in Celko's book.
Monitoring
Oracle 10g RAC with Quest Spotlight on RAC – Part I : Tarry Singh
offers a peek into Quest Spotlight on RAC, now out of beta and soon to go GA.
SoRAC provides detailed diagnostic information by drilling down individual
instances and merging the appropriate calculations into one interface.
Making
the Case for CASE Tools : Many DBAs find themselves working with
someone else's database design. Unless you are involved with building or
designing a new application or database from scratch, when else would you have
the opportunity to use a CASE tool? One of the points to take away from having
read this article is that a CASE tool can also be used after the fact. CASE
tools are an invaluable resource for a DBA and knowing how to use one (or more)
of them can make your job easier.
Database
Modeling Using Visio : One of Visio's key features is its ability to
reverse engineer a database. Part 2 of this series looks at doing exactly that,
using the sample schemas Oracle provides.
If you have an interesting
column / article / short note etc., that you would
like to share with the rest of the DBA world, please
send it to webmaster@dbasupport.com.
