Skip Headers
Oracle® Database Express Edition 2 Day DBA
11g Release 2 (11.2)

E18804-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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
See also user accounts
user privileges, 7.1.1
users
authenticating, 7.2.3
expiring passwords for, 7.5.4
See also user accounts
USERS tablespace, 6.1.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