Index

A B C D E F H I L M N O P R S T U V

A

administrative user accounts, 7.2

logging in to, 7.3

SYS, 7.2.1

SYSTEM, 7.2.1

altering user account attributes, 7.5.2

passwords, 7.5.2

user names, 7.5.2

ARCHIVELOG mode, 6.1.7.2

setting, 11.1.2, 11.1.2.2

viewing current setting, 11.1.2.1

archiving redo log files, 6.1.7.2

attributes, user accounts

altering, 7.5.2

authentication

operating system, 7.2.3

automatic memory management, 5.1

B

backing up the database

about, 11.1.1

how to, 11.1.3

scheduling, 11.1.4

script, 11.1.3

backup

retention policy, 11.1.1

script, 11.1.1

storage

automatic management of, 11.1.1

C

changing

administrative user passwords, 7.4

user account attributes, 7.5.2

passwords, 7.5.2

user names, 7.5.2

client software

Instant Client, 3.1.2

Oracle Database Express Edition Client, 3.1.2

compacting storage space, 6.3

connect strings

elements of, 3.1.2

connecting to Oracle Database XE

from your application, 3

using SQL Command Line

locally, 3.1.1, 3.3

remotely, 3.1.2, 3.4

with the SYSDBA privilege, 7.2.3

control file

defined, 6.1.4

control files

SQL*Loader, 10.2.2

conventional path loads

SQL*Loader utility, 10.2.2.1

CREATE TABLESPACE command, 6.1.2

creating

tablespaces, 6.1.2

D

data dictionary tables

access to as user SYS, 7.2.2

Data Pump Export utility, 10.2.3.1

dump file set, 10.2.3.1

Data Pump Import utility, 10.2.3.1

database

defined, 6.1.1

initialization parameters, 6.1.5

settings

viewing, 9.1, 9.2

version

viewing, 9.1, 9.2

database administration

privileges required, 7.2

database storage structures

logical, 6.1

physical, 6.1

datafile

defined, 6.1.3

DBA role

security implications, 7.5.1

direct path loads

SQL*Loader utility, 10.2.2.1

directory object, 10.2.3.1

dropped tables

and the recycle bin, 11.3

recovering, 11.3

dropping user accounts, 7.1, 7.5.5

E

enabling

Oracle Database XE graphical user interface for remote computers, 4.5

environment variables

and the listener on Linux, 4.2

required for connecting with Oracle utilities, 3.5

scripts, 3.5, 3.5

invoking, 3.5

setting

on Linux, 3.2.2

on Windows, 3.2.1

using scripts to set, 3.5

expiring passwords

how to, 7.5.4.1

reasons for, 7.5.4

Export utility, 10.2.3.2

exporting data and metadata, 10

external table load

SQL*Loader utility, 10.2.2.1

F

filtering data

using Data Pump Export utility, 10.2.3.1

flash recovery area

defined, 6.1.7

location of, 6.1.7

managing, 6.6

monitoring space in, 6.6.1

setting location, 6.6.2

setting size, 6.6.2

structures in, 6.1.7

Flashback Query

tips for using, 11.2.3

using to retrieve historical data, 11.2.1

ftp connection requests for XML DB repository

and the listener, 4.1

H

historical data

retrieving with Flashback Query, 11.2.1

HR sample schema, 7.5.3

HR user account, 7.5.3

HTTP

connection requests, 4.1

enabling remote, 4.5

I

Import utility, 10.2.3.2

importing data and metadata, 10

initialization parameters, database

changing, 6.1.5

viewing, 6.1.5

Instant Client

accessing, 3.1.2

internal schemas, 7.1.2

internal user accounts, 7.1.2

SYSTEM, 7.1.2

L

LD_LIBRARY_PATH environment variable, 3.5

listener

and environment variables on Linux, 4.2

and ftp connection requests, 4.1

configuration of, 4.1

port numbers

changing, 4.4

starting, 4.3

stopping, 4.3

types of requests handled by, 4.1

viewing status of, 4.2

Listener Control utility (lsnrctl), 4.2

listener.ora file

changing port numbers in, 4.4.1.1

location of, 4.4.1.1

local connections

required environment variables, 3.5

locking user accounts, 7.5.3

log writer process (LGWR)

writing to online redo log files, 6.1.7.1

logging in to Oracle Database XE

as an administrator, 7.3

logical storage, 6.1

M

managing

database users, 7.5

memory, 5.2.1

network connections, 4

storage, 6

memory

allocation in Oracle Database XE, 5.2.1

automatic memory management, 5.1

insufficient, 5.2.3

managing, 5.2

types of

program global area (PGA), 5.2.1

system global area (SGA), 5.2.1

monitoring

current sessions, 8.1

long operations, 8.3

most-used SQL statements, 8.2

space in flash recovery area, 6.6.1

storage space usage, 6.2

N

network connections

and the Oracle Net Listener, 4.1

managing, 4

NLS_LANG environment variable, 3.5

NOARCHIVELOG mode, 6.1.7.2

O

object privileges, 7.1.1

online redo log files

defined, 6.1.7.1

operating system authentication

See OS authentication

Oracle Database Express Edition Client

accessing, 3.1.2

Oracle Net

used in remote connections, 4.1

Oracle Net listener

See listener

ORACLE_HOME environment variable, 3.5

ORACLE_SID environment variable, 3.5

OS authentication, 7.2.3

user groups, 7.2.3

security of adding new members, 7.2.3

P

password file, 6.1.6

passwords

altering for user accounts, 7.5.2

expiring, 7.5.4

PATH environment variable, 3.5

PGA

See program global area

PGA Aggregate, 5.2.3

PGA Aggregate Target parameter, 5.2.3

physical storage, 6.1

port numbers

changing

for database connection requests, 4.4.1

for HTTP connection requests, 4.4.2

changing in listener.ora file, 4.4.1.1

on Linux, 4.1

on Windows

default for HTTP requests, 4.1

predefined user accounts, 7.6.1

privileges

administrative, 7.2

object, 7.1.1

required for database administration, 7.2

system, 7.1.1

SYSDBA, 7.2.2

user, 7.1.1

using roles to manage, 7.1.1

program global area (PGA), 5.2.1

default size, 5.2.3

when to change size of, 5.2.3

purging the recycle bin, 11.3.4

R

recovering dropped tables, 11.3

recycle bin

and dropped tables, 11.3.1

purging, 11.3.4

viewing contents of, 11.3.2

redo log

and data protection, 6.1.7.2

ARCHIVELOG mode, 6.1.7.2

archiving, 6.1.7.2

NOARCHIVELOG mode, 6.1.7.2

redo log files

circular use of, 6.1.7.1

defined, 6.1.7.1

in the flash recovery area, 6.1.7

LGWR and the, 6.1.7.1

moving, 6.6.2

online

defined, 6.1.7.1

viewing, 6.5

remote connections

about, 3.1.2

required environment variables, 3.5

removing user accounts, 7.5.5

restore

script, 11.1.1

restoring the database

about, 11.1.1

retention policy, backup, 11.1.1

roles, 7.1.1

using to manage user privileges, 7.1.1

S

sample schema, HR, 7.5.3

schemas, 7.1

internal, 7.1.2

scripts

backup of the database, 11.1.3

scheduling, 11.1.4

using to set environment variables, 3.5

security

implications of DBA role, 7.5.1

maintaining, 7

server parameter file, 6.1.5

sessions

monitoring, 8.1

setting environment variables

on Linux, 3.2.2

on Windows, 3.2.1

SGA

See system global area

SGA Target parameter, 5.2.3

SHUTDOWN ABORT command, 2.2.2

SHUTDOWN IMMEDIATE command, 2.2.2

shutting down

the database

from the desktop, 2.2.1

using SQL Command Line, 2.2.2

space

compacting, 6.3

monitoring, 6.2

SQL Command Line

connecting using

locally, 3.1.1

remotely, 3.1.2

using to shut down the database, 2.2.2

using to start up the database, 2.1.2

SQL statements

viewing the most used, 8.2

SQL*Loader utility

control files, 10.2.2

conventional path method, 10.2.2.1

direct path method, 10.2.2.1

discarded records, 10.2.2

external tables method, 10.2.2.1

features of, 10.2.2.2

rejected records, 10.2.2

using to load data, 10.2.2

SQLPATH environment variable, 3.5

starting

the database

from the desktop, 2.1.1

using SQL Command Line, 2.1.2

the listener, 4.3

stopping

the database

from the desktop, 2.2.1

using SQL Command Line, 2.2.2

the listener, 4.3

storage

compacting, 6.3

logical, 6.1

managing, 6

monitoring space usage, 6.2

physical, 6.1

SYS user, 7.2.1

SYSAUX tablespace, 6.1.2

SYSDBA system privilege, 7.2.2

system global area (SGA), 5.2.1

components, 5.2.2

default size, 5.2.3

when to change size of, 5.2.3

system privileges, 7.1.1

SYSDBA, 7.2.2

SYSTEM tablespace, 6.1.2

SYSTEM user, 7.2.1

T

tablespaces

creating new, 6.1.2

defined, 6.1.2

SYSAUX, 6.1.2

SYSTEM, 6.1.2

TEMP, 6.1.2

types of, 6.1.2

UNDO, 6.1.2

USERS, 6.1.2

viewing, 6.4

TEMP tablespace, 6.1.2

U

undo data, 6.1.2

UNDO tablespace, 6.1.2

unlocking user accounts, 7.5.3

user accounts

administrative, 7.2

altering attributes of, 7.5.2

altering passwords, 7.5.2

altering user names, 7.5.2

defining user attributes, 7.1

dropping, 7.1, 7.5.5

HR, 7.5.3

internal, 7.1.2, 7.1.2

locking, 7.5.3

predefined in Oracle Database XE, 7.6.1

unlocking, 7.5.3

user names

altering, 7.5.2

V

version, database

viewing, 9.1, 9.2

viewing

database settings, 9.1, 9.2

database version, 9.1, 9.2

listener status, 4.2

recycle bin contents, 11.3.2

redo log files, 6.5

tablespaces, 6.4