Oracle High Performance Tuning for 9i and 10g

C

Configuration tuning, 16–17

Constraints, use of, 48–55, 721

COUNT function, 126, 143–45, 277, 721

Creating a database, 405–26 see also Installing Oracle database

Database Configuration Assistant, 406–13

current trends, 412–13

dedicated or shared servers, 409

default structure, 413

memory buffer parameters, 410

optional features, 407

redo logs, 412

sort buffer, 411

tablespaces, 411

manual creation, 413–26

automated storage management, 425–26

catalog and SPFILE, 424–25

create the database, 415–17

directory structure, 414–15

tablespace and rollback, 417–23