Oracle A423961 - Manual (Page 78)

Admin.
Guide
SQL
3 – 20 Oracle7 Server Getting Started for Windows NT
Creating Database Objects
Once you have created new database files, as described in Chapter 3 of
this Guide, you can create new database objects including:
• tables
• clusters
• indexes
• views
• roles
Additional Information: See Oracle7 Server Administrator’s
Guide for guidelines on creating database objects. In particular,
see the section that provides equations for estimating the space
requirements for clusters, nonclustered tables, and indexes.
Windows NT uses the same fixed header, transaction header,
and row header constants described in that chapter.
When creating database objects such as tables, clusters, and indexes,
specify a STORAGE clause to define the way in which the object size
increases over time.
Additional Information: The individual parameters of the
STORAGE clause have the same defaults and minimum values
as those described in the Oracle7 Server SQL Reference.
Setting Resource Costs
Oracle7 Server for Windows NT allows you to limit users’ access to
database resources and database objects.
For example, you can set limits for a user’s file input/output (I/O)
regardless of which database objects the user accesses. Set a resource
cost for the logical reads of the user’s session to set I/O limits.
Define resource costs through user profiles. A profile is a collection of
valid database resources and costs for a given user. With Oracle7 Server
for Windows NT, you can create user profiles to define the following
resource costs:
• logical reads for individual sessions or SQL statements
• number of sessions that a user may create
• idle time and elapsed time for each user session