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 I)

Online Oracle Training

LESSON #1:

How to install the Oracle 10g Database on LINUX

You will learn:

How to install the Oracle 10g Database on LINUX

How to create the oinstall, dba group and the oracle user with optionally the oper group

How to create a profile .profile or .bash_profile

How to create the Oracle directory

How to change the Kernel parameters in the /etc/sysctl.conf file system\

More ...

 

LESSON #2:

Automatic Database Diagnostic Monitor in the Oracle 10g database

The automatic Database Diagnostic Monitor (ADDM) maintains a self-diagnostic to a database

You will learn:

Where to access to ADDM

How to turn OFF the ADDM

How to retrieve ADDM Reports using SQL

What the Automatic Shared Memory Management (MMAN) is

How to enable or disable Automatic Shared Memory Management

How to determine the actual size of the auto-tuned components in the SGA

How to change the SGA_TARGET value

How to create a tablespace using manually segment space management and locally extent managed

How to determine the effects of the database load on the memory buffers

More ...

 

LESSON #3:

Oracle Manageability Infrastructure in the Oracle 10g database

You will learn:

What the components of Oracle manageability Infrastructure are

What the Server-Generated alerts are

What the Advisory Framework is

What the Automatic Workload Repository (AWR) is

How manually invoke the ADDM advisor to analyze the database

How to de-queue alert

How to grant ‘EXECUTE’ object privilege

How to set the USER Commits

How to check a metrics thresholds

How to examine your outstanding alerts and alert history

How to write a script to generate a commit rate

How to check your outstanding alerts

How to clean up your threshold set up

How to disable your alert and remove subscriber

More ...

 

LESSON #4:

Application tuning in the Oracle 10g database

You will learn:

How to enhance Query Optimization

How to use Automatic Tuning Optimizer (ATO)

How to use the dbms_stats package

How to gather statistics for entire schema

How to use the DBMS_SQLTUNE package

How to invoke the EXECUTE_TUNING_TASK procedure

What the mview (Materialized View) is

How to create a materialized view

How to gather statistics against the new materialized view

How to query from new materialized view

How to execute EXPLAIN PLAN

How to use the DBMS_MVIEW.EXPLAIN_REWRITE procedure

More ...

 

LESSON #5:

Database Resource Manager in the Oracle 10g database

You will learn:

About the Oracle Resource manager to manage your resources

How to kill a session

How to use the DBMS_RESOURCE_MANAGER package

More ...

 

LESSON #6:

Scheduler in the Oracle 10g database

You will learn:

About the Oracle database Scheduler

How to use the DBMS_SCHEDULER package

Why we prefer the DBMS_SCHEDULER package to the DBMS_JOB package

How to monitor the scheduler

How to create a scheduler

How to create a job

How to create a daily job

More ...

 

LESSON #7:

Tablespace Monitoring in the Oracle 10g database

You will learn:

How to raise or clear an alert

How to set a warning threshold of 80% and a critical threshold of 95% on a tablespace

How to turn off a space-usage tracking

How to reset a database threshold value

How to check a status of your threshold

More ...

 

 

. Part I          . Part II

Good Luck!!!!

 

Google
 
Web web site