iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 10g New Features (Part II)

Online Oracle Training

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!!!!

 

Google
 
Web web site