OCP Prerequisite

May 31, 2010 by · Comments Off
Filed under: Oracle 

To achieve OCP? certification, candidates are required to attend one instructor led training course from Oracle University. See here for more information.

A candidate should have 1 year or more in Oracle and SQL database administration in an enterprise environment.
Students who are successful in accelerated training and certification ALL possess:
The drive and motivation to succeed and advance their careers.
Course Curriculum for Current Track
Day 1Â
 Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Â
Day 2
 Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects

Practical Exercises
Exam 1Z0-051
Â
Day 3
 Basic Oracle Concepts
Installing Oracle Database 10g
Creating an Oracle Database
Interfacing with the Oracle Database
Managing Oracle Processes
Managing Oracle Storage Structures
Â
Day 4Â
 Administering Users
Managing Database Objects
Manipulating Database Data
Programming Oracle with PL/SQL
Securing the Database
Configuring Oracle Networking
Managing Shared Servers
Â
Day 5
 Managing Database Performance
Monitoring Oracle
Managing Undo
Dealing with Locking
Configuring the Database for Backup and Recovery
Backing Up Oracle Databases
Recovering Oracle Databases
Recovering from User Errors
Tools for Oracle Database 10g Tuning
Â
Day 6
 Practical Exercises
Exam 1Z0-042
Managing Globalization in Oracle Databases
Configuring Security for the Listener
Getting Started with Oracle Recovery Manager (RMAN)
Â
Day 7
 Using RMAN to Back Up Oracle Databases
Diagnosing Oracle Database Issues
Recovering from Noncritical Losses
Incomplete Database Recovery
Using Flashback Database
Â
Day 8
 Detecting and Recovering from Database Corruption
Monitoring and Managing Storage
Managing Storage with Automatic Storage Management
Monitoring and Managing Memory
Managing Oracle Database Resource
Â
Day 9
 Automating Administrative Tasks
Practical Exercises
Exam 1Z0-043

Tags:

Oracle 10G OCP Boot Camp Certification Training Class

May 28, 2010 by · Comments Off
Filed under: Oracle 

The goal of this nine-day accelerated OCP boot camp class mapped to Oracle’s new requirements for SQL, is to provide IT professionals with the advanced knowledge and skills necessary to administer the world’s leading database systems and applications. This is a performance-based course designed upon the job-related tasks an advanced professional must perform using new or modified features in the Oracle® systems.

Our Boot Camp Program for Oracle 10g DBA Certified Professional  Certification affords students the ability to live, learn, and take the vendor exams on-site at our education centers throughout the US and Europe. Our program is delivered in a distraction-free, immersed environment with on-site, deluxe accommodations – utilizing a curriculum adapted specifically for accelerated learning.

Reasons for OCP™ certification include career advancement, personal improvement, skills enhancement, and higher salaries. According to Certification Magazine, http://www.nowexam.com, Oracle certified professionals earned 28% more money than the average IT certified professional. In addition, Computer Reseller News, http://www.nowexam.com, cites that Oracle certified DBAs on average are paid 21% more than non-certified DBAs.

Tags:

About Cisco: Prioritize Voice traffic with LLQ

May 25, 2010 by · Comments Off
Filed under: Cisco 

In one of my previous posts I was explaining how to mark packets closer to network edge. Starting from that point, we are sure the packets are market with the correct value, so on the router device we can directly match those packets and prioritize using Low Latency Queueing.

I believe you already know why queueing is so important for Voice packet especially, but also for all other kind of real time protocol (e.g. Video over IP), but just a small reminder. Most of the interfaces are using FIFO method for queuing. This is the most basic queue method and as you probably know means First In First Out. In human terms, first packet how arrive on the interface will be send first. Nothing wrong with this theory until this point and I can assure you that most of the time you don’t have to do anything to improve this technique. But what if you have real time protocols (e.g. voip services) and data transfer over the same physical interface? With FIFO the packets are sent out the interface as they arrive, but this is not very good for the delay sensitive traffic like voice. If a TCP packet in HTTP flow can wait it’s turn to be sent out, with not visible impact for user, than a delayed voice packet will cause deprecation in voice call.

With this problems need to be solved we arrive at LLQ, which is an ehanced version of Priority Queueing (PQ) in a Class-Based Weighted Fair Queueing (CBWFQ).
Before we start let’s have a look to the topology we will use (the same like in Cisco: Mark voice packets at the network edge post):
After marking the packets on the Access Switch,now we want to prioritize voice packets on the core router:

1) Match packets market with EF in a class-map

class-map VOICE
match dscp 46

2) Configure a policy-map unde which you match the traffic in the class-map VOICE and enable LLQ. The parameter “priority” is the one telling policy-map to enable priority queueing under that class. The value after the “priority” keyword can be a value in kbps or percentage from the total bandwidth. In the example below I assume that I have a 10Mbps bandwidth and I’ll configure LLQ class to use 10% from it, meaning 1000kbps

policy-map MYPOLICY
class VOICE
priority 1000

or with percentage

policy-map MYPOLICY
class VOICE
priority percent 10

I have to tell you that after the bandwidth or percent value you can add a burst value in bytes. If you don’t add this value, it will be calculated automatically. I chose this method when I’m doing simple config, but if you want to fine tune the values you can calculate it yourself and add it. Be careful that a higher value will influence the Tc value in the process.

3) Apply the policy to the WAN interface of the Core router (I assumed that the Core router is your direct connection to provider backbone) direction outbound. You cannot apply this type of queueing direction inbound. Keep this in mind.

interface s0/0
service-policy output MYPOLICY

If you insist on applying it inbound, you’ll get an error message:

Core(config-if)#service-policy input MYPOLICY
Low Latency Queueing feature not supported in input policy.

To check that your queueing policy is applied:

show policy-map interface s0/0

Service-policy output: MYPOLICY

queue stats for all priority classes:

queue limit 64 packets
(queue depth/total drops/no-buffer drops) 0/0/0
(pkts output/bytes output) 0/0

Class-map: VOICE (match-all)
0 packets, 0 bytes
5 minute offered rate 0 bps, drop rate 0 bps
Match: EF
Priority: 10% (1000 kbps), burst bytes 25000, b/w exceed drops: 0

Class-map: class-default (match-any)
0 packets, 0 bytes
5 minute offered rate 0 bps, drop rate 0 bps
Match: any

queue limit 64 packets
(queue depth/total drops/no-buffer drops) 0/0/0
(pkts output/bytes output) 0/0

Tags:

OCA, OCP and OCM – Oracle Certification

May 22, 2010 by · Comments Off
Filed under: Oracle 

This section contains information about Oracle certification (OCA, OCA and OCM). The information on this page is for informational only. For detail, please visit http://education.oracle.com

As you know, Oracle certifications can help you succeed in your IT career and provide measurable benefits to your employer.

Oracle certifications also reliable validations of training and experience that can accelerate your professional development, improve your productivity, and enhance your credibility.

Certifications available for DBA:

Currently Oracle offers following certification for a DBA in 9i and 10g.

Oracle Database 10g DBA OCA
Oracle Database 10g DBA OCP
Oracle Database 10g DBA OCM

Oracle9i DBA OCA
Oracle9i DBA OCP
Oracle9i DBA OCM

Certifications available for Application Developer:

Oracle PL/SQL Developer OCA
Oracle Forms Developer OCP
Internet Application Developer Rel.6i OCP

What is OCA (Oracle Certified Associate):
This exam is your first step to become an Oracle professional. You can take this exam for DBA as well as for developer.
What is OCP (Oracle Certified Professional):
This is an advanced certification that Oracle offers for a DBA. In order to get this certification, you should pass the OCP exam first and should complete a Hands-On Course with Oracle University.

What is OCM (Oracle Certified Master):
This is the most advanced exam for Oracle database administrators. Before you plan for this exam, you should have comprehensive and extensive experience on a wide variety of topics including installation, troubleshooting, backup and recovery and tuning.

Tags:

Next Page »