Oracle Database 10g New Features for Administrators

What you will learn:
This course introduces students to the new features in Oracle Database 10g Release 2 - the database
for Grid computing. Students learn how to use Oracle Database 10g new features to increase database
availability, to simplify database performance monitoring and tuning through the use of Oracle Database
10g Advisors, and to offer simplified database manageability. The course also covers security changes
that students need to understand. Hands-on practice sessions give students an opportunity to examine
many of the new features, and to practice database administration with Enterprise Manager Database
Control.
Course Objectives:
  • Using Database Control to simplify database management
  • Proactively monitoring the database
  • Increasing data availability by using improved point in time recovery features
  • Implementing Automatic Storage Management
  • Managing Metric Baselines
  • Using Oracle Secure Backup
  • Simplifying Instance Configuration
  • Using Data Pump Export and Import
  • Configuring the Scheduler
  • Using the Automatic Workload Repository
  • Managing Services
  • Creating Bigfile Tablespaces
  • Creating Hash-Partitioned Global Indexes
  • Creating Compressed Backup sets in RMAN
  • Configuring Flashback Database
  • Creating the SYSAUX Tablespace

Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible
and cost-effective way to manage enterprise information. This Self-Study Course covers the new features
of Oracle Database 10g that are applicable to database administration.
  • Match goals of Oracle Database 10g manageability with the methods of achieving them
  • Identify features of the Oracle Database 10g manageability strategy.
  • Identify attributes of Grid computing.
  • Identify new installation features of Oracle Database 10g.
  • Identify features of transportable tablespaces (TTS).
  • Identify functional architecture of Data Pump.
  • Identify features of the Data Pump export and import utilities.
  • Identify features of Automatic Database Diagnostic Monitor (ADDM).
  • Identify features of Automatic Shared Memory Management (ASMM).
  • Identify features of Automatic Workload Repository (AWR).
  • Identify guidelines for gathering optimizer statistics.
  • Identify features of Automatic SQL Tuning.
  • Identify features of the flash backup and recovery strategy.
  • Identify the features of guaranteed undo_retention.
  • Identify features of the SYSAUX tablespace.
  • Identify features of Resource Manager in Oracle Database 10g.
  • Identify options for creating a mapping between consumer groups and session attributes.
  • Identify modifications to the DBMS_RESOURCE_MANAGER package in Oracle Database 10g.

Comments

Post a Comment

Popular posts from this blog

WorkFORCE Assessment for Job Fit

About the WorkFORCE Assessment for Job Fit Hiring a candidate who looks good on paper, but does not come through on the job, can cost your business both time and money. Success at work takes more than technical skills and knowledge. You need people with the right behaviors, attitudes and motivation. IQ tests and technical assessments do not tell the whole story. Identify the candidate most likely to succeed The research-based WorkFORCE Assessment for Job Fit, a 20–25 minute, web-based recruiting tool, measures six behavioral competencies associated with critical factors of workplace success. You are provided with an Overall Job Fit Score that indicates the candidate’s likelihood of success in the position. This score is tailored to the type of job you are filling and the behavioral skills candidates need to perform successfully in that job. Used in conjunction with interviews and knowledge-based testing, the WorkFORCE Assessment for Job Fit gives you a more complete under
Read more

Stylistic Techniques Used For Writing - Voiceskills

Image
Writing is a craft. Skilled writers incorporate stylistic techniques into their writing for rhetorical effect. In other words, stylistic techniques enhance a piece of writing’s aesthetic, emotional or intellectual appeal. Certainly, the content of a text is important, but a writer who can organize his ideas in a unique and provocative way can increase his/her writing’s allure. Varied Sentence Structure English allows for four main sentence constructions: simple, compound, complex and compound-complex, and skilled writers use all of these. Using too many simple sentences in a row sounds monotonous. A simple sentence consists of one subject and one verb, as in “She laughed.” The other sentence constructions incorporate more subject-verb patterns. Conciseness No matter the genre, whether poetry or essay writing, skilled writers aim for conciseness. Conciseness in writing means eliminating any unnecessary words. Writing all sentences in active voice, where the subject precedes the
Read more

Improving English Listening With Independent Study

Image
  There are those who prefer to study English alone and here are some tips to get better at listening. Study a little bit at a time. Only have a few minutes per day to study? Perfect. Believe it or not, that’s even better than having a lot of time to study. If you are someone with a habit of studying around 15-20 minutes a day instead of a few hours in one sitting, actually you are studying using the method of micro learning. Simply speaking, micro learning is dividing your task into very small tasks that can be done in about five minutes. For example, imagine that you’re trying to study the present perfect. You can micro learn it by dividing it into: 1. Affirmative sentences; 2. Negative sentences; 3. Questions; 4. Use; 5. Words that trigger the present perfect. This is just an example. You can divide your task the way you want, always trying to remember that every individual task should last five minutes at most. There are a lot of scientific studies that prove that lea
Read more