数据库培训[杨宝秋].pptVIP

ORACLE数据库基础 ;议程;议程;关于Oracle;看两张图片;Oracle版本历史;Tasks of an DBA;议程;安装流程;准备工作;System Requirements;Setting Environment Variables;Preinstallation Checks;Oracle Universal Installer;Inventory and UNIX Group Name;orainstRoot.sh;File Locations;Install Type;Prerequisite Checks;Starter Database;Passwords and Summary;Installation ; root.sh ;Creating an Oracle Database;Database Configuration Assistant;Creating a Database;Database Identification;Management Options;Passwords and Storage;File Locations and Backup Recovery;File Location Variables;Content and Initialization Parameters;Database Storage;Creation Options and Create;议程;Password file;Control Files;Redo Log Files;Tablespaces and Datafiles;Segments, Extents, and Blocks;Oracle Memory Structures;Oracle Processes;Connecting to an Instance;议程;What Is SQL*Plus?;What Is SQL?;使用 SQL;SQL Processing Phases;SQL Processing: Parse;LIBRARY CACHE LATCHES;Oracle Optimizer;Top Database Performance Issues;议程;启/停数据库;Starting Up a Database;Shutting Down the Database;Initialization Parameter Files;Alert Log;Tablespace management;Space Management in Tablespaces;Creating Tablespaces;Adding Data Files to a Tablespace;Dropping Tablespaces;表空间统计;User management;Creating a New User: ;Dropping a User;Grant privilege;Undo management;Undo Data;Storing Undo Information;Monitoring Undo;Administering Undo;Configuring Undo Retention;Ora-01555;Monitoring and Resolving Lock Conflicts;Locks;Locking Mechanism;Enqueue Mechanism;Lock Conflicts;Deadlocks;查看锁sql;Database Backups;Terminology;Terminology;Recovery Manager (RMAN);备份示例;备份脚本示例;A