数据库

Create and manage temporary, permanent, and undo tablespaces 关于tablespace的操作语句有三大类，分别是create tablespace、alter tablespace、drop tablespace 表空间如标题所说，总体也分为三大类，temporary tablespace 、system/sysaux/users t

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM  Notes about the exam     Exam participants work through nine skillsets that are based

Stripe data files across multiple physical devices and locations 如果在没有做条带的磁盘(即从存储到OS没有做raid)，那么就需要手工去做I/O的分布。切记，不应该将频繁使用的table和其index分开，这样会正大I/O； 针对tables、indexes、temp tablespace，首先调优SQL，其次如果真心无法再调优

1.1、Create the database 1.2、Determine and set sizing parameters for database structures 大概步骤： Step 1: Specify an Instance Identifier (SID)==>设置实例id，ORACLE_SID=orcl Step 2: Ensure That the Required