

			System management for Oracle DBAs

Welcome to the AppsDBA.com web site

This site is dedicated to providing integrated system management solutions and information for the Oracle DBA.

You will find real scripts, real utilities and real code created and used on real systems. You won't find regurgitated documentation and contrived examples, and there is no advertising!

What is system management?

System management is a methodical approach to managing Oracle systems and includes the following topics:

	Technical Architecture
	Configuration Management
	Operational Management
	Workload Management
	Performance Management

Oracle Management Tool Suite

The Oracle Management Tool Suite has just been released as an Open Source project on Sourceforge.net! The orautil project is available at orautil.sourceforge.net, and is composed of the following utilities:

orasetup	-	An environment setup utility that replaces corenv/orenv
dbcontrol	-	A utility that starts/stops and checks Oracle databases and other dependent products.
ascontrol	-	A utility that starts/stops and check Oracle Application Server products.
logdelete	-	A utility that manages database status log files.
chkdberr	-	A utility that checks database status log files for errors.
dbora	-	An enhancement of Oracle's dbora file to start and stop Oracle products during machine reboots.
stby_maint	-	A utility that helps manage Data Guard envrionments.
bkctrl	-	A backup utility that supports many types of Oracle backups including RMAN based backups.
Sysmon	-	A workload monitoring utility
Spacemon	-	A segment space managment utility

Workload Characterization

Characterizing workload is the process of identifying classes of workload, measuring those classes and then calculating the costs of those classes of workload. The purpose of workload characterization is to be able to allocate available capacity to the classes that are most important to the business. Check out the AppsDBA paper Oracle Workload Characterization.

"Conventional wisdom is opinion that has been repeated enough over time to become accepted as fact. While sometimes it can be fact, most times it is not." - Tom House, The Picture Perfect Pitcher, 2003

Site Links

Utilities

workmon

sqlmon

resource profiler

Scripts

fnd_cp_ovlp_bymgr.sql

fnd_pgm_RP.sql

fnd_cp_time.sql

Site Information

OpenSource software now available

Database configuration information

Technical articles

Improved version of Tom Kyte's Runstats utility

Click here to check out the AppsDBA blog.