Oracle DBA

Database Administration has grown over the years from the mere management of a few tables and indexes to a complex interlocking set of responsibilities ranging from managing database objects to participating in enterprise wide decisions on hardware, software and development tools. In order to fully perform these functions the modern Oracle DBA needs a large skill set. Over the next few hours we will discuss the skills needed and specifically how they apply to an Oracle DBA....

Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material.The Oracle DBA Checklists Pocket Reference is divided into three major sections covering the main areas of an Oracle DBA's responsibilities: Database management. Describes how to maintain existing databases (with a checklist of daily, weekly, and monthly activities), prepare new databases for production, and back up and recover databases (with checklists for how to recover tables, data files, index files, control files, rollback segments, and...

Fast, easy automation for every Oracle 9i and 10g DBA! Quick access to real-world examples. Installation, database creation, management, monitoring, tuning, and backup/recovery. Oracle Universal Installer (OUI), Oracle Net Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA). The fast, practical Oracle 9i/10g automation reference for every DBA! Master scripting for both Oracle 9i and Oracle 10g! Use Oracle Universal Installer to create response files for automating any installation. Use Oracle Network Configuration Assistant (NetCA) to configure network components during installation. Use Oracle Database Configuration Assistant (DBCA) to create and clone databases, and to reverse engineer them into templates and scripts...

Oracle DBA Guide to Data Warehousing and Star Schemas is the definitiveguide to maximizing the performance, flexibility, and manageability ofany Oracle 8i/9i data warehouse. Legendary Oracle data warehouse expertBert Scalzo offers hard-won lessons and proven techniques for designing,constructing, tuning, and maintaining star schema data warehouses inreal production environments. Coverage includes: planning hardware andsoftware architectures; star schema design; data loading; queryoptimization; partitioning; administration; and much more....