-
It's alive! It's alive!
Craig Mullins explains why the mainframe is here to stay, despite rumors otherwise.
-
DBA certification
Craig Mullins tells you why you should, or shouldn't, care about DBA certifications.
-
Self-managing database systems
Craig Mullins opines on "self-managing" database systems and their impact on the DBA.
-
The data explosion
Craig Mullins looks at what is fueling the massive explosion in data in enterprise environments.
-
Morphing of database administration
Craig Mullins discusses some of the trends and issues that will impact data management professionals in 2005.
-
On becoming a DBA
Craig Mullins offers advice for anyone who wants to be a DBA.
-
Guide to Oracle freeware and shareware
This list of free and low-cost tools and utilities will help Oracle DBAs and developers do your job better.
-
Reusing a prepared software stack
Lots of production downtime can be eliminated by using a prepared software stack for upgrading. This tip explains how.
-
Upgrading Oracle: Linux vs. Windows
An ITKnowledge Exchange member asked about moving Oracle from RISC/Unix to either Windows or Linux, and fellow techies jumped in on the conversation.
-
Hardware and Oracle performance
This article will explore recent advances in hardware and show how the Oracle pro can leverage these new technologies to improve the performance of their databases.
-
Partitioned table details
This PL/SQL block displays the details of a given partitioned table.
-
Predictable Oracle apps tuning, part 3
The conclusion of this three-part tip covers memory, data dictionary fragmentation, the FND_STATS histogram and other miscellaneous tuning considerations.
-
Predictable Oracle apps tuning, part 2
Part 2 of this tip on Oracle applications tuning covers the v$sqlarea view, Statspack, index counts, CPU and user involvement.
-
Understanding Oracle features
Guru Don Burleson's guide to understanding the features and options in the various editions of the Oracle DBMS.
-
Simple way to measure consumed resourc
This SQL*Plus script offers a way to measure consumed resources in V$tables.
-
Predictable Oracle apps tuning, part 1
Perfomance issues with Oracle apps stem from a variety of often unexpected causes. This tip highlights a few misconceptions about tuning and outlines a management approach.
-
Using MTS
Here's how the multi-threaded server feature can be used to support thousands of concurrent database sessions.
-
How to control DDL commands
This tip offers a mechanism to control unauthorized DDL commands against Oracle databases.
-
Case study of an applications upgrade
Here's a simple case study of upgrading Apps 10.7SC on Sequent Dynix to 11.5.7 on Solaris.
-
Performance war
Columnist Craig Shallahamer compares Oracle performance tuning to the wars of old and offers a lesson to young DBAs about how to survive the bloodshed.
-
Script writing rules for Hyperion Financial Management
Accountants hate having to play with scripts. In this tip, TopDown Consulting explains how to build script rules so that accountants don't have to.
-
Domain-specific Oracle master data management
Oracle master data management products are starting to merge various data management hubs, which is a help in particular vertical industries.
-
The basics of Oracle database availability
Database expert Jeff McCormick introduces some basic Oracle database availability concepts such as uptime and mean time between failures.
-
Oracle application performance management done right
Being proactive with your Oracle application performance management is crucial to stemming system slowdowns, according to this tip.