Basic HTML version of Foils prepared 7 October 97

Foil 32 Major Schema Objects in Oracle - IX

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
1 Clusters are groups of one or more tables physically stored together because they share common columns and are often used together.
  • Because related rows are physically stored together, disk access time improve
2 Data Dictionary - each Oracle server has a data dictionary which is a set of tables and views that are used as a read-only reference about the database (meta-data),
  • such as logical and physical structure of the database, users, tables definition, integrity constraints, etc.
3 For example, you can see your disk space quota: select * from user_ts_quotas;
in Table To:

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998