Part I Basic Database Administration

Database administrators have specific responsibilities and must understand how to complete database administration tasks.

• Getting Started with Database Administration
  To get started with database administration, you must understand basic database concepts, such as the types of database users, database security, and privileges. You must also be able to complete basic tasks, such as submitting commands and SQL to the database and creating a password file.
• Configuring Automatic Restart of an Oracle Database
  Configure your Oracle database with the Oracle Restart feature to automatically restart the database, the listener, and other Oracle components after a hardware or software failure or whenever your database host computer restarts.
• Managing Processes
  Oracle Databases uses several processes so that multiple users and applications can connect to a single database instance simultaneously.
• Managing Memory
  Memory management involves maintaining optimal sizes for the Oracle Database instance memory structures as demands on the database change.
• Managing Users and Securing the Database
  Establish a security policy for every database.
• Monitoring the Database
  It is important that you monitor the operation of your database on a regular basis. Doing so not only informs you of errors that have not yet come to your attention but also gives you a better understanding of the normal operation of your database. Being familiar with normal behavior in turn helps you recognize when something is wrong.
• Diagnosing and Resolving Problems
  Oracle Database includes an advanced fault diagnosability infrastructure for collecting and managing diagnostic data, so as to diagnose and resolve database problems. Diagnostic data includes the trace files, dumps, and core files that are also present in previous releases, plus new types of diagnostic data that enable customers and Oracle Support to identify, investigate, track, and resolve problems quickly and effectively.