|
LESSON #8:
UNDO Advisor in the Oracle
10g database
You will learn:
How to size your UNDO
tablespace with the UNDO Advisor
What the Snapshot Too Old
error means
More ...
LESSON #9:
Big and Small file tablespaces in
the Oracle 10g database
You will learn:
What a bigfile tablespace (BFT)
is
When to use the
DATABASE_PROPERTIES dictionary view
When to use the
DBA_TABLESPACES dictionary view
When to use the V$TABLESPACE
dynamic view
When to use the
DBA_TABLESPACE_GROUPS view
How to create a tablespace
with a BIGFILE default tablespace type
More ...
LESSON #10:
The Oracle Data Pump Export and
Import utilities in the Oracle 10g database
You will learn:
Why Data Pump Export and
Import
How to export a table with a
specific criteria
How to import a table with
recalculating statistics
How to export with limited
resources in a schema
How to move objects from one
tablespace to another
How to read from your
exported file
What an endian format is
More ...
LESSON #11:
Backup and Recovery
Enhancements in the Oracle 10g database
You will learn:
How and why to use RMAN
What the Flash Recovery Area
is
How to define a Flash
Recovery Area
How to back up the Flash
Recovery Area
How to enable Fast
Incremental Backup
How to monitor block change
tracking
How to use the
V$BACKUP_DATAFILE view
How to back up the entire
database
How to back up an individual
tablespaces
How to back up data files and
control files:
More ...
LESSON #12:
The Flashback feature in the
Oracle 10g database
You will learn:
What the flashback is
How the flashback works
Why we should use flashback
How to Flashback a database
How to monitor Flashback
Database
When to use the
V$FLASHBACK_DATABASE_LOG view
When to use the
V$FLASHBACK_DATABASE_STAT view
How to exclude a tablespace
from flashback database
How to reclaim the recycle
bin
How to recover a table using
the flashback command
More ...
LESSON #13:
General Storage
Enhancements in the Oracle 10g database
You will learn:
About the SYSAUX tablespace
an auxiliary tablespace
How to drop or rename a
tablespace
How to use the Redo Logfile
size advisor
How to control the interval
and retention of snapshot.
More ...
LESSON #14:
Automatic Storage Management (ASM) in
the Oracle 10g database
You will learn:
About the Automatic Storage
Management (ASM)
How to creating a diskgroup
How to dropping a diskgroup
More ...
LESSON #15:
Security VPD in the Oracle
10g database
You will learn:
About the Oracle Virtual
Private Database (VPD)
How to create a package that
contains a procedure that it assigns the employee’s identifier to the
EMPNO attribute
When to use the
DBM_SESSION.SET_CONTEXT procedure
More ...
LESSON #16:
More features that is
important to note in the Oracle 10g database
You will learn:
When to use the
V$FAST_START_TRANSACTIONS
When to use the
V$FAST_START_SERVERS view
When to use the
DBA_ENABLED_TRACES view
What the Regular Expression
Support is
How to write a PL/SQL block
to test a value of a binding variable
More ...
LESSON #17:
Navigate the Oracle Enterprise
Manager Grid Control in the Oracle 10g database
You will learn:
What the Grid Control is
How to stop the Oracle
Management Server
How to start the Oracle
Management Server
How to get the status of the
Oracle Management Server
How to access to Enterprise
Manager Database Control
More ...
LESSON #18:
Oracle 10g Regular Expression Support
You will learn:
What the REGULAR EXPRESSIONS
is
How to use REGULAR
EXPRESSIONS
When to use the REGEXP_LIKE
function
When to use the REGEXP_SUBSTR
function
When to use the REGEXP_INSTR
function
When to use the
REGEXP_REPLACE function
More ...
LESSON #19:
Navigate the Oracle
Enterprise Manager Grid Control in the Oracle 10g database
You will learn:
How to create an Oracle user
How to export tables from a
schema
How to import tables from a
schema
How to retrieve the latest
ADDM and determine the cause of the problem
How to shut down and startup
your databases
How to check or resize the
size of the various SGA buffers
How to enable the Automatic
Shared Memory
How to find a high load SQL
statement
How to determine the most
important wait category
How to use the SQL Access
Advisor to generate recommendation for SQL tuning set
How to create and schedule a
job
How to change the Tablespace
Space Usage thresholds of a tablespace
How to run the Segment
Advisor
How to use the Undo Advisor
How to change the size of
flash recovery area
How to backup your whole
database
How to use the flashback
feature to recover a dropped table
How to determine the Redo Log
File size using the Sizing Advice
More ...
The Oracle 10g
Database New Features Questions
.
Part
I .
Part
II
Good Luck!!!!
|