The social network for Oracle people

May 2010 Blog Posts (17)

Transport the tablespace Same OS platform

You want to transport tablespaces using RMAN backups instead of performing the transportable tablespaces operation on the live production database.

From here also http://mohamedazar.wordpress.com/2010/05/29/transport-the-tablespace-on-same-os-platform/

Source Database : MYTEST

Target Database : MYDB

Transportable…

Continue

Added by Mohamed Azar on May 29, 2010 at 5:53am — No Comments

SOA Case Studies

Have companies been able to realize the promise of SOA? Here is the proof

Financial

Bank of Baroda

First Horizon

Guardian

Helvetia Patria

Synovus Financial

AFLAC Inc.

Standard Bank South Africa

Large Australian bank uses SOA for introducing new products

Large Scandinavian bank uses SOA to reduce personal loan origination… Continue

Added by SOA Trainer on May 28, 2010 at 9:34am — No Comments

Avail online Oracle Demantra Training: Starts 29th May 2010

Our new batch of online Oracle Demantra Training is commencing on 29 May 2010.

Why this training is… Continue

Added by Focusthread Ltd on May 28, 2010 at 4:42am — No Comments

Avail online Oracle ERP Development Training- Starts 29th May 2010

Our new online course on Oracle ERP Development Training is commencing on 29th May, 2010

Why this training is necessary?

Oracle Enterprise Resource Planning (ERP) promotes a fully integrated systems approach, enables companies to cut costs, operate more efficiently, be more responsive to Client demand, reduce turnover and assist staff in reaching peak… Continue

Added by Focusthread Ltd on May 28, 2010 at 4:22am — No Comments

Avail online Oracle Demantra Training- Starts 29th May 2010

Our new batch of online Oracle Demantra Training is commencing on 29 May 2010.

Why this training is… Continue

Added by Focusthread Ltd on May 28, 2010 at 3:07am — No Comments

Create duplicate database using rman

You want to use RMAN to create a duplicate database on the same server by using RMAN backups.

Source database name is MYTEST

Target (duplicate) database name is MYDB

This is the simple steps to create a duplicate database

You can read from here…

Continue

Added by Mohamed Azar on May 25, 2010 at 11:33am — No Comments

Self-Service Human Resource (SSHR)

Self-Service Human Resource

SSHR stands for Self-Service Human resource. In Organizations this particular module helps in managing self service

functions at both manager level as well as employee level. One basic

advantage in using SSHR is it saves your time & money by giving the

related functions access to employee for changing their Personal

information for eg.: if an… Continue

Added by abhishek sharma on May 25, 2010 at 3:41am — No Comments

Update under the hood ... and some extreme side effects

If you want to read about how UPDATE works at block level and some ugly cases where you can flood the blocks and waste space, follow this link for English version UPDATE under the hood ...and some extreme side effects... or follow this link for Spanish text UPDATE interno... y sus efectos secundarios.

Hope you find it useful, please… Continue

Added by Ignacio Ruiz on May 24, 2010 at 5:00am — No Comments

Restoring old Optimizer Statistics for troubleshooting purpose

Since 10g, we do not simply overwrite old optimizer statistics by gathering new. Instead, the old optimizer statistics are automatically historized and kept for one month by default, so that they can be restored easily if that should be desired. Here we go with a short demonstration of restoring historic optimizer statistics…

Continue

Added by Uwe Hesse on May 19, 2010 at 8:10am — No Comments

Granule size

I wrote about Granule size and some example (and fake to test from granule 4M -> 16M when have memory limited)
http://surachartopun.com/2010/05/granule-size.html

Added by Surachart Opun on May 18, 2010 at 1:10pm — No Comments

Character Set migration Oracle 11g

When i tried to transport the tablespace from linux to windows, during import it shows charachter set error, so I just looked on linux database and windows database character set is different .

Linux is WE8IS08859P1

Windows is AR8ISO8859P6

So i plan to migrate the charater set of windows and change to WE8IS08859P1 character set. Here I provided step by step guide , How to migrate character set. I play with…

Continue

Added by Mohamed Azar on May 18, 2010 at 4:45am — 1 Comment

Oracle HRMS Job Opportunity

I have an excellent opportunity (Permanent) with a client of mine in Kansas City for a senior level Oracle HRMS (Payroll) and Oracle Financials Expert. I have a full job description I can send your way if you or anyone you know might have interest!

• This position will be responsible for the business requirements analysis, process modeling standards, and related business process documentation for both commercial off the shelf (COTS) and custom application environments.

• Leads…

Continue

Added by Jill Dryer on May 17, 2010 at 10:38am — No Comments

Index Dynamics - Part 3

Continuing with this series, where you can explore real life observations for regular Index behavior, within a living ERP system. This post present final results for this experiment, both in English Index Dynamics - Part 3 and Spanish Dinamica de Indices - Parte 3. I'll share a small recommendation derived from experiment: try not rebuild indexes before high… Continue

Added by Ignacio Ruiz on May 12, 2010 at 5:00am — No Comments

BACKUP AND RECOVERY: BLOCK RECOVERY IN RMAN

Block media recovery recovers an individual corrupt datablock or set of datablocks within a datafile. In cases when a small number of blocks

require media recovery, you can selectively restore and recover damaged

blocks rather than whole datafiles.

More please visit.…

Continue

Added by Rajeshkumar Govindarajan on May 7, 2010 at 3:30am — No Comments

Index Dynamics - Part 2

More than a year ago started a series of posts about Index Dynamics (initial post click here), don't know why, but updates on Oracle Community were miserably forgotten... anyway, today will resume and share with you real life results with a set of indexes from a live ERP system, armed with tools like statement ANALYZE INDEX and table INDEX_STATS. Full English text is available here… Continue

Added by Ignacio Ruiz on May 6, 2010 at 6:00am — No Comments