05 2015 档案

Basic Memory Structures

摘要：Basic Memory StructuresThe basic memory structures associated with Oracle Database include:System global area (SGA)The SGA is a group of shared memory... 阅读全文

posted @ 2015-05-29 14:36 seasonzone 阅读(236) 评论(0) 推荐(0) 编辑

States of Integrity Constraints

摘要：States of Integrity ConstraintsAs part of constraint definition, you can specify how and when Oracle Database should enforce the constraint, thereby d... 阅读全文

posted @ 2015-05-18 13:46 seasonzone 阅读(212) 评论(0) 推荐(0) 编辑

Merging into a Table: Example

摘要：Merging into a Table: ExampleThe following example uses the bonuses table in the sample schema oe with a default bonus of 100. It then inserts into th... 阅读全文

posted @ 2015-05-15 14:59 seasonzone 阅读(210) 评论(0) 推荐(0) 编辑

oracle 单独开始一个事物的写法。

摘要：SET TRANSACTION NAME 'Update salaries';SAVEPOINT before_salary_update;UPDATE employees SET salary=9100 WHERE employee_id=1234 # DMLROLLBACK TO SAVEPOI... 阅读全文

posted @ 2015-05-15 14:35 seasonzone 阅读(687) 评论(0) 推荐(1) 编辑

Summary of Memory Management Methods

摘要：Summary of Memory Management MethodsTable 18-1 summarizes the various memory management methods. If you do not enable automatic memory management, the... 阅读全文

posted @ 2015-05-06 15:29 seasonzone 阅读(153) 评论(0) 推荐(0) 编辑

Automatic Tuning of Memory Management

摘要：4.2.2 Automatic Tuning of Memory ManagementTwo memory management initialization parameters, MEMORY_TARGET and MEMORY_MAX_TARGET, enable automatic mana... 阅读全文

posted @ 2015-05-06 15:15 seasonzone 阅读(159) 评论(0) 推荐(0) 编辑