Oracle A423961 Manual Do Utilizador

Admin.

Guide

SQL

3 – 20

Oracle7 Server Getting Started for Windows NT 

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

  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.

  The individual parameters of the

STORAGE clause have the same defaults and minimum values
as those described in the Oracle7 Server SQL Reference.

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