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
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
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.
For example, you can see your disk space quota: select * from user_ts_quotas;

© 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