|
|
| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 1 - Getting
Started
Oracle Database Administration
Responsibilities
-
Assist O/S admin personnel
with disk configuration (disk number, RAID configurations)
-
Executing Oracle’s installation program
-
Failed installation recovery
-
Database Creation
-
File sizing for on-line redo logs
-
File sizing for default, temporary, rollback,
system, and temporary tablespaces
-
Object sizing for rollback segments
-
Memory sizing for data buffers, log buffers SQL
area and sort areas
-
File placement for control files, data files,
redo-logs, application programs
-
Physical Object Creation and Administration
-
Tablespace sizing
-
Tablespace free space parameters
-
Tablespace resizing
-
Tablespace data management parameters (local,
dictionary, Oracle managed data files and segment sizes, etc.)
-
Schema Object Creation and Administration
-
Table, index sizing and creation
-
User-defined datatypes
-
Data constraints (referential integrity, check
and unique constraints)
-
Table partitioning (range, hash, list,
composite)
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
|
|
|
