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