不同表空间存储。
在系统比较空闲时nologging选项（如果有dataguard则不可以使用nologging）
大的sort_ared_size或pga_aggregate_target较大
5. 对raid10 和raid5有何认识
RAID 10(或称RAID 1＋0)与RAID 0＋1不同，它是用硬盘驱动器先组成RAID 1阵列，然后在RAID 1阵列之间再组成RAID 0阵列。
RAID 10模式同RAID 0+1模式一样具有良好的数据传输性能，但却比RAID 0+1具有更高的可靠性。RAID 10阵列的实际容量为M×n/2，磁盘利用率为50％。RAID 10也需要至少4个硬盘驱动器构成，因而价格昂贵。
RAID 10的可靠性同RAID 1一样，但由于RAID 10硬盘驱动器之间有数据分割，因而数据传输性能优良。
RAID 5与RAID 3很相似，不同之处在于RAID 5的奇偶校验信息也同数据一样被分割保存到所有的硬盘驱动器，而不是写入一个指定的硬盘驱动器，从而消除了单个奇偶校验硬盘驱动器的瓶颈问题。RAID 5磁盘阵列的性能比RAID 3有所提高，但仍然需要至少3块硬盘驱动器。其实际容量为M×(n-1)，磁盘利用率为(n-1)/n 。
五：综合随意类
1. 你最擅长的是oracle哪部分
pl/sql及sql优化
2. 喜欢oracle吗？喜欢上论坛吗？或者偏好oracle的哪一部分？
喜欢。PL/SQL比较得心应手。
3. 随意说说你觉得oracle最有意思的部分或者最困难的部分
我对数据库的备份/恢复和性能调优经验明显不足，自然觉得有些困难。
基于ORACLE的研究应该是个宽广的领域，所以我觉得还是有意思的。
4. 为何要选择做DBA呢
我对数据库的备份/恢复和性能调优经验明显不足，主要是缺乏环境和交流。
因此，算不上什么DBA。不过因此我更需要这样的机会。
不过就整个ORACLE 来说，一直从事与它相关的工作，感情还是颇深的。放弃可惜。而且就技术本身而言我觉得自己还是有学习和创新的能力，它的诸如数据仓库，数据挖掘之类的领域也很广。
六：Databases Questions & Answers
1. What are two methods of retrieving SQL
2. What cursor type do you use to retrieve multiple recordsets
3. What action do you have to perform before retrieving data from the next result set of a stored procedure
Move the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row. Before you can get to the first row, you would need to Move the cursor down by one row ( For ex: in java the first call to next makes the first row the current row; the second call makes the second row the current row, and so on).
4. What is the basic form of a SQL statement to read data out of a table
SELECT * FROM table_name;
5. What structure can you have the database make to speed up table reads
The question is not correct. “What structure can you have the database make to speed up table reads ” It is not clear what exactly the term “structure” means in this case. Follow the rules of DB tuning we have to:
1) properly use indexes ( different types of indexes)
2) properly locate different DB objects across different tablespaces, files and so on.
3) Create a special space (tablespace) to locate some of the data with special datatypes( for example CLOB, LOB and …)
6. What is a “join”
Joins merge the data of two related tables into a single result set, presenting a denormalized view of the data.
7. What is a “constraint”
A constraint allows you to apply simple referential integrity checks to a table. There are 5 primary types of constraints that are currently supported by SQL Server:
PRIMARY/UNIQUE – enforces uniqueness of a particular table column.
DEFAULT – specifies a default value for a column in case an insert operation does not provide one.
FOREIGN KEY – validates that every value in a column exists in a column of another table.
CHECK – checks that every value stored in a column is in some specified list
NOT NULL – is a constraint which does not allow values in the specific column to be null. And also it is the only constraint which is not a table level constraint.
8. What is a “primary key”
Primary Key is a type of a constraint enforcing uniqueness and data integrity for each row of a table. All columns participating in a primary key constraint must possess the NOT NULL property.
9. What is a “functional dependency” How does it relate to database table design
What functional dependence in the context of a database means is that: Assume that a table exists in the database called TABLE with a composite primary key (A, B) and other non-key attributes (C, D, E). Functional dependency in general, would mean tha