Enterprise Edition Installation

1
Identify System Requirements
2
The Optimal Flexible Architecture (OFA)
3
Oracle_base
4
Oracle_home
5
Configure the Installation Environment
6
Enterprise Edition Installation
7
DBCA

The Administrator Interface

1
Enterprise Manager Tour
2
Using EM SQL Worksheet
3
Duties of a Database Administrator
4
Exploring the Oracle Database Architecture: General

THE ORACLE ENTERPRISE ARCHITECTURE

Exploring the Oracle Database Architecture: Instance Memory

1
What is an Oracle Database Instance?
2
More about the System Global Area (SGA)
3
About the PGA
4
Managing Memory

Exploring the Oracle Database Architecture: Instance Processes

1
Instance Background Processes
2
SQL Execution Processes

Creating an Oracle Database

1
Create a new Database
2
Configure an existing Database
3
Drop a Database
4
Manage DBCA Templates
5
Manually create a Database

Managing the Database Instance

1
Configuring a Linux Environment
2
Starting and Stopping Database Control
3
Starting and Stopping the Database Listener
4
Starting and Stopping the Database Instance
5
More about the Database Files

Manage Database Storage Structures: Tablespaces

1
About Tablespaces
2
Tablespace Management
3
Drop Tablespace
4
Alter Tablespace

Manage Database Storage Structures: Advanced Tablespaces

1
More about temporary tablespaces
2
About temporary tablespace groups
3
More about permanent tablespaces
4
More about bigfile tablespaces
5
More about the sysaux tablespace

Manage Database Storage Structures

1
Data files and temp files
2
Managing Data Files
3
Managing Temp Files
4
Enable oracle-managed files (omf)

Managing undo data

1
About undo space management
2
Configure automatic undo management
3
undo_management
4
undo_tablespace
5
undo_retention
6
Guarantee undo retention
7
Monitor undo space
8
Use the undo advisor

Network environment: oracle shared servers

1
Shared servers architecture
2
Configure shared servers
3
Monitor shared servers
4
v$shared_server
5
v$shared_server_monitor
6
v$session
7
v$circuit
8
v$dispatcher and v$dispatcher_config
9
v$queue

Security: implementing database security

1
Database system privileges
2
Database object privileges
3
Administrator auditing of database activity
4
Enhanced default security settings

Security: administering user security

1
Create and manage database accounts
2
Grant and revoke database privileges
3
Resource limits via profiles
4
Alter profile
5
Drop profile
6
Password management via profiles
7
About role-based security
8
With admin option
9
Alter user…default role
10
Set Role
11
Enhanced default security settings

Moving data: sql loader

1
Loader concepts
2
Control file options
3
Load methods
4
Using the em interface

Moving data: export and import

1
Manage directory objects
2
About the data pump architecture
3
Data pump export
4
Data pump import
5
Data pump data dictionary views
6
Using the em interface

Database maintenance and performance management

1
The management and advisory framework
2
Manage the automatic workload repository
3
Automatic database diagnostic monitor
4
Use metrics and alert thresholds
5
Automatic maintenance tasks

Managing concurrency and locks

1
About latches and locks
2
Manage and monitor latches
3
Manage and monitor locks
4
v$lock
5
v$locked_object
6
v$session
7
v$session_wait
8
dba_blockers
9
dba_dml_locks
10
dml_locks

Backup and recovery concepts and configuration

1
About database backup and recovery structures
2
Managing redo data
3
Managing archival data
4
Automatic crash recovery
5
Creating a basic backup strategy

Be the first to add a review.

Please, login to leave a review
Oracle Course Classes In Fremont CA
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV

Working hours

Monday9:30 am - 6.00 pm
Tuesday9:30 am - 6.00 pm
Wednesday9:30 am - 6.00 pm
Thursday9:30 am - 6.00 pm
Friday9:30 am - 5.00 pm
SaturdayClosed
SundayClosed

Pin It on Pinterest