Oracle Essentials [Electronic resources] : Oracle Database 10g, 3rd Edition نسخه متنی

SANS (storage area networks)

schemas
2nd

SCN (System Change Number)
2nd

security

application roles and privileges

encapsulation in stored procedures

auditing

distributed databases

fine-grained access control, implementing

Oracle Label Security Option

privileges

security policies

Segment Advisor

segments
2nd

SELECT statement

MODEL clause

sequences

SERIALIZABLE isolation level

serialization

server processes

dedicated

PGA, and

service names

Service Requests (SRs)

SERVICE_NAMES parameter

session beans

session memory

SET ROLE command

SGA (System Global Area)
2nd
3rd

automatic resizing in Oracle Database 10g

components

memory allocation, initialization parameters

session data, for storage of

shadow processes

shared locks

"shared nothing" architecture

shared pool

size and performance

shared server model

shared servers
2nd
3rd

connection process

initialization parameters

shared SQL

bind variables

SHARED_POOL_SIZE parameter

single database block I/Os

single source code model

sizing the sort area

SMON (System Monitor) process

SMP (Symmetric Multiprocessing) systems
2nd
3rd
4th

advantages

CPU quantity and system bus

CPU requirements

snowflake schemas

SORT_AREA_RETAINED SIZE parameter

SORT_AREA_SIZE parameter

spatial information systems and Oracle

spatial object type

Spatial option

SPFILE
2nd

backup

spindles

SQL

command privileges

SQL (Structured Query Language)
2nd

DML

statements

parsing and optimizing

table order and optimization

tuning

SQL Tuning Advisor
2nd

SQL Tuning Optimizer

SQL Workshop

SQL*Loader, direct path load

SQL*Net, configuration

SQL*Plus, PL/SQL blocks, and

SQL/XML

SQLJ
2nd
3rd

SQLNET.ORA

stack

stack space

standby databases
2nd

potential data losses with site failure

star queries

star schemas
2nd

cost-based query optimization

state

statistical aggregate functions

storage area networks (SANs)

Storagetek dedicated storage subsystems

stored outlines

stored procedure-based systems
2nd

stored procedures

Streams
2nd
3rd

striped disk arrays
2nd

loss of disks

Oracle I/O, interaction

striping

with parity

subscribers

summary tables

support services available through Oracle Corporation

surge protection (Web Cache)

Symmetric Multiprocessing systems
[See SMP]

synchronous replication
2nd

synonyms

SYS and SYSTEM user accounts

SYS user

SYSDBA role and privileges

SYSOPER role and privileges

System Change Number (SCN)
2nd

system crashes

error messages

preparation for

System Global Area
[See SGA]

system memory, types

system monitoring

CPU resources

system resources, PGA

SYSTEM user