ORACLE DATABASE 10G ADMINISTRATION
CONTENTS PART 1 ? ? ?BACKGROUND, DATA MODELING, AND UNIX/LINUX ?CHAPTER THE ORACLE DBA’S WORLD THE ORACLE DBA’S ROLE DIFFERENT DBA JOB CLASSIFICATIONS TYPES OF DATABASES BACKGROUND AND TRAINING THE DAILY ROUTINE OF A TYPICAL ORACLE DBA SOME GENERAL ADVICE ?CHAPTER RELATIONAL DATABASE MODELING AND DATABASE DESIGN RELATIONAL DATABASES: A BRIEF INTRODUCTION THE RELATIONAL DATABASE MODEL RELATIONAL DATABASE LIFE CYCLE REVERSE-ENGINEERING A DATABASE OBJECT-RELATIONAL AND OBJECT DATABASES ESSENTIAL UNIX (AND LINUX) FOR THE ORACLE DBA OVERVIEW OF UNIX AND LINUX OPERATING SYSTEMS UNDERSTANDING THE UNIX SHELL(S) OVERVIEW OF BASIC UNIX COMMANDS NAVIGATING FILES AND DIRECTORIES IN UNIX WRITING AND EDITING FILES WITH THE VI EDITOR EXTRACTING AND SORTING TEXT SHELL SCRIPTING DEALING WITH UNIX PROCESSES UNIX SYSTEM ADMINISTRATION AND THE ORACLE DBA DISKS AND STORAGE IN UNIX RAID SYSTEMS NEW STORAGE TECHNOLOGIES PART 2 ? ? ?ORACLE DATABASE 10G ARCHITECTURE, SCHEMA, AND TRANSACTION MANAGEMENT ?CHAPTER INTRODUCTION TO THE ORACLE DATABASE 10G ARCHITECTURE ORACLE DATABASE STRUCTURES ORACLE PROCESSES ORACLE MEMORY STRUCTURES A SIMPLE ORACLE DATABASE TRANSACTION DATA CONSISTENCY AND DATA CONCURRENCY BACKUP AND RECOVERY ARCHITECTURE THE ORACLE DATA DICTIONARY AND THE DYNAMIC PERFORMANCE VIEWS TALKING TO THE DATABASE ORACLE UTILITIES SCHEDULING AND RESOURCE-MANAGEMENT TOOLS AUTOMATIC DATABASE MANAGEMENT COMMON MANAGEABILITY INFRASTRUCTURE EFFICIENT MANAGING AND MONITORING SCHEMA MANAGEMENT TYPES OF SQL STATEMENTS ORACLE SCHEMAS CREATING AND MANAGING TABLESPACES ORACLE TABLES SPECIAL ORACLE TABLES ORACLE INDEXES MANAGING DATABASE INTEGRITY CONSTRAINTS USING VIEWS USING MATERIALIZED VIEWS USING THE SQL ACCESS ADVISOR USING SYNONYMS USING SEQUENCES USING TRIGGERS VIEWING OBJECT INFORMATION ORACLE TRANSACTION MANAGEMENT ORACLE TRANSACTIONS TRANSACTION PROPERTIES TRANSACTION CONCURRENCY CONTROL ISOLATION LEVELS AND THE ISO TRANSACTION STANDARD ORACLE’S ISOLATION LEVELS IMPLEMENTING ORACLE’S CONCURRENCY CONTROL USING UNDO DATA TO PROVIDE READ CONSISTENCY FLASHBACK ERROR CORRECTION USING UNDO DATA FLASHBACK USING THE DBMS_FLASHBACK PACKAGE FLASHBACK TRANSACTION QUERY DISCRETE TRANSACTIONS AUTONOMOUS TRANSACTIONS RESUMABLE SPACE ALLOCATION MANAGING LONG TRANSACTIONS PART 3 ? ? ?INSTALLING ORACLE DATABASE 10G, AND CREATING AND UPGRADING DATABASES ?CHAPTER INSTALLING THE ORACLE DATABASE 10G RDBMS INSTALLING ORACLE FOLLOWING THE OPTIMAL FLEXIBLE ARCHITECTURE PERFORMING PREINSTALLATION TASKS A FINAL CHECKLIST FOR THE INSTALLATION AFTER THE INSTALLATION UNINSTALLING ORACLE UPGRADING TO ORACLE DATABASE 10G ROUTES TO ORACLE DATABASE 10G UPGRADE METHODS AND TOOLS UPGRADING WITH THE DBUA UPGRADING MANUALLY AFTER THE UPGRADE CREATING AN ORACLE DATABASE GETTING READY TO CREATE THE DATABASE CREATING THE PARAMETER FILE CREATING A NEW DATABASE USING A SERVER PARAMETER FILE (SPFILE) STARTING UP AND SHUTTING DOWN THE DATABASE FROM SQL*PLUS PART 4 ? ? ?CONNECTIVITY AND USER MANAGEMENT ?CHAPTER CONNECTIVITY AND NETWORKING ORACLE NETWORKING AND DATABASE CONNECTIVITY NETWORKING CONCEPTS: HOW ORACLE NETWORKING WORKS ESTABLISHING ORACLE CONNECTIVITY THE ORACLE CLIENT THE INSTANT CLIENT THE LISTENER AND CONNECTIVITY NAMING AND CONNECTIVITY ORACLE AND JAVA DATABASE CONNECTIVITY USER MANAGEMENT AND DATABASE SECURITY MANAGING USERS THE DATABASE RESOURCE MANAGER CONTROLLING ACCESS TO DATA AUDITING DATABASE USAGE AUTHENTICATING USERS ENTERPRISE USER SECURITY DATABASE SECURITY DOS AND DON’TS USING SQL*PLUS AND ISQL*PLUS STARTING A SQL*PLUS SESSION EXITING SQL*PLUS SQL*PLUS AND SQL COMMANDS KEY SQL*PLUS “WORKING” COMMANDS COMMANDS FOR FORMATTING SQL*PLUS OUTPUT AND CREATING REPORTS CREATING COMMAND FILES IN SQL*PLUS EDITING WITHIN SQL*PLUS KEY SQL*PLUS DATABASE ADMINISTRATION COMMANDS USING SQL TO GENERATE SQL ISQL*PLUS PART 5 ? ? ?DATA LOADING, BACKUP, AND RECOVERY ?CHAPTER LOADING AND TRANSFORMING DATA AN OVERVIEW OF EXTRACTION, TRANSFORMATION, AND LOADING USING THE SQL*LOADER UTILITY USING EXTERNAL TABLES TO LOAD DATA TRANSFORMING DATA USING ORACLE STREAMS FOR REPLICATION AND INFORMATION SHARING USING DATA PUMP EXPORT AND IMPORT INTRODUCTION TO THE DATA PUMP TECHNOLOGY PERFORMING DATA PUMP EXPORTS AND IMPORTS MONITORING A DATA PUMP JOB USING THE DATA PUMP API TRANSPORTABLE TABLESPACES BACKING UP DATABASES BACKING UP ORACLE DATABASES EXAMINING THE FLASH RECOVERY AREA THE RECOVERY MANAGER (RMAN) BACKING UP THE CONTROL FILE THE ORACLE BACKUP TOOL USER-MANAGED BACKUPS DATABASE CORRUPTION DETECTION ENHANCED DATA PROTECTION FOR DISASTER RECOVERY DATABASE RECOVERY TYPES OF DATABASE FAILURES THE ORACLE RECOVERY PROCESS PERFORMING RECOVERY WITH RMAN TYPICAL MEDIA RECOVERY SCENARIOS CLONING A DATABASE TECHNIQUES FOR GRANULAR RECOVERY FLASHBACK TECHNIQUES AND RECOVERY USING RESTORE POINTS REPAIRING DATA CORRUPTION AND TRIAL RECOVERY TROUBLESHOOTING RECOVERY ERRORS PART 6 ? ? ?MANAGING THE OPERATIONAL ORACLE DATABASE ?CHAPTER AUTOMATIC MANAGEMENT AND ONLINE CAPABILITIES THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR (ADDM) AUTOMATIC SHARED MEMORY MANAGEMENT AUTOMATIC OPTIMIZER STATISTICS COLLECTION AUTOMATIC STORAGE MANAGEMENT AUTOMATIC SPACE MANAGEMENT ONLINE CAPABILITIES OF ORACLE DATABASE 10G MANAGING AND MONITORING THE OPERATIONAL DATABASE TYPES OF ORACLE PERFORMANCE STATISTICS SERVER-GENERATED ALERTS THE AUTOMATIC WORKLOAD REPOSITORY (AWR) ACTIVE SESSION HISTORY (ASH) THE MANAGEMENT ADVISORY FRAMEWORK WORKING WITH THE UNDO AND THE MTTR ADVISORS MANAGING THE ONLINE REDO LOGS MANAGING DATABASE LINKS COPYING FILES WITH THE DATABASE SERVER MAPPING ORACLE FILES TO PHYSICAL DEVICES USING THE ORACLE SCHEDULER USING ORACLE ENTERPRISE MANAGER ORACLE ENTERPRISE MANAGER OEM ARCHITECTURE AND COMPONENTS OEM DATABASE CONTROL OEM GRID CONTROL MANAGING ORACLE DATABASES ON WINDOWS AND LINUX SYSTEMS ORACLE DATABASE 10G AND WINDOWS ESSENTIAL DIFFERENCES BETWEEN MANAGING ORACLE ON WINDOWS AND UNIX INSTALLING ORACLE DATABASE 10G ON A WINDOWS SYSTEM THE WINDOWS REGISTRY MANAGING ORACLE ON WINDOWS SYSTEMS UNINSTALLING ORACLE ON WINDOWS ORACLE AND LINUX PART 7 ? ? ?PERFORMANCE TUNING ?CHAPTER IMPROVING DATABASE PERFORMANCE: SQL QUERY OPTIMIZATION AN APPROACH TO ORACLE PERFORMANCE TUNING OPTIMIZING ORACLE QUERY PROCESSING QUERY OPTIMIZATION AND THE ORACLE COST-BASED OPTIMIZER WRITING EFFICIENT SQL HOW THE DBA CAN HELP IMPROVE SQL PROCESSING SQL PERFORMANCE TUNING TOOLS USING THE EXPLAIN PLAN THE SQL TUNING ADVISOR A SIMPLE APPROACH TO TUNING SQL STATEMENTS PERFORMANCE TUNING: TUNING THE INSTANCE AN INTRODUCTION TO INSTANCE TUNING AUTOMATIC PERFORMANCE TUNING VS DYNAMIC PERFORMANCE VIEWS TUNING ORACLE MEMORY EVALUATING SYSTEM PERFORMANCE MEASURING I/O PERFORMANCE MEASURING INSTANCE PERFORMANCE A SIMPLE APPROACH TO INSTANCE TUNING PART 8 ? ? ?THE DATA DICTIONARY, DYNAMIC VIEWS, AND THE ORACLE-SUPPLIED PACKAGES ?CHAPTER THE ORACLE DATA DICTIONARY USING THE STATIC DATA DICTIONARY VIEWS USING THE DYNAMIC PERFORMANCE VIEWS USING ORACLE PL/SQL PACKAGES OVERVIEW OF THE ORACLE-SUPPLIED PL/SQL PACKAGES DBMS_FILE_TRANSFER DBMS_MONITOR UTL_COMPRESS UTL_MAIL DBMS_TDB DBMS_JOB DBMS_APPLICATION_INFO DBMS_CRYPTO DBMS_SESSION DBMS_SYSTEM DBMS_OUTPUT DBMS_REPAIR DBMS_OUTLN AND DBMS_OUTLN_EDIT DBMS_SPACE DBMS_SPACE_ADMIN DBMS_PROFILER DBMS_ERRLOG UTL_FILE UTL_SMTP DBMS_SHARED_POOL DBMS_WM DBMS_RLMGR ORACLE PACKAGES IN EARLIER CHAPTERS BACKGROUND, DATA MODELING, AND UNIX/LINUX P A R T