oracle 20111-10-24

原创于 2011-10-24 16:12:05 发布 · 91 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

本文深入探讨了Oracle数据库中的方案对象概念，包括数据库实例、SGA、PGA等核心组件，以及如何通过创建表格和索引来优化数据库性能。

[b]basic concepts:[/b]
database management system (DBMS)
relational database management system(RDBMS)
object-relational database management system (ORDBMS).
system global area (SGA)
program global area (PGA)
Database instance:An instance is a set of memory structures that manage database files.
[b]Scheme Objects:[/b]In Oracle Database, a database schema is a collection of logical
data structures, or schema objects. A database schema is owned by a database user and has the same name as the user name.

[b]Tables:[/b]
[b]Index:[/b]
An index is an optional data structure that you can create on one or more columns of a
table.

Oracle9i&10g编程艺术