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

BLOCK RECOVERY Without Having RMAN Backup

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.




for more information and reference

please…
Continue

Added by Rajeshkumar Govindarajan on May 5, 2010 at 1:30pm — 2 Comments

Command Line History and Editing in SQL*Plus and RMAN on Linux

In windows you have option of using up and down arrows for previously used sql statements and rman commands. But in Linux operation system with in sql*plus and rman prompt, not possible to use the up arrows and edit the previous used commands and statements.…
Continue

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

Blog Topics by Tags

Monthly Archives

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Join and Union examples of related tables to show different SQL and esProc syntax

Join multiple tables with “join”

The SQL…

Continue

Posted by Jim King on October 15, 2014 at 12:02am

profiles in Oracle DBA

I've one question it is related to Oracle DBA, I've just read about password settings in profiles concept, i'm little bit confusing on PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME, and I understand something about these two topics. I updating here what i'm understand when I was reading about this, so tell me is it right or wrong.

1) PASSWORD_REUSE_MAX: This setting is used for reusing of old passwords. The functionality of this setting is restricts reusing of old password for…

Continue

Posted by Bhagya Raj Katta on October 10, 2014 at 7:21am

Dynamic Performance views-what are they?

A little bit about how exactly Oracle retrieves the information from Dynamic performance views. Read more here : http://suntrupth.blogspot.in/2014/10/dynamic-performance-views-what-are-they.html

Posted by Suntrupth Yadav on October 9, 2014 at 9:30am

Oracle Masters?

Where can I ask my Oracle / PlSQL related doubts from masters ?

Posted by Mohammed on September 24, 2014 at 6:07pm

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service