Oracle Apps DBA training material

Oracle Apps DBA training material

A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information.

A database administrator (short form DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database.

Below are some general DBA Scripts and tutorials available for download:

1. General DBA Scripts

• Show database uptime in days and hours
• Create database user like an exiting user (with exact privs)
• Switch from one database user to another without password (su.sql)
• Dynamically ZIP large process trace files
• Tabular display of redo-log archiving history (logs/hour)
• List control file structures with usage limits
• Log all database errors to a table
• Demonstrate database and schema level triggers
• Limit resources using the Database Resource Manager
• Log Miner - extract undo statements from log files
• Database cursor usage (open_cursors parameter)
• On-line table reorganizaton using the DBMS_REDEFINITION package
• Create a Primary key column on a table were this is not yet available

1. DBA Training Tutorials

• Oracle9i DBA Fundamentals 1
• Oracle9i DBA Fundamentals 2
• Oracle DBA Cloning Scripts