oracle 20111-10-24

wking_forever

于 2011-10-24 16:12:05 发布

阅读量82

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/wking_forever/article/details/84052844

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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编程艺术