Category Archives: Uncategorized

Optimizing the Oracle 11g Result Cache

The Oracle 11g Result Set Cache stores entire result sets in shared memory. If a SQL query is  executed and its result set is in the cache then almost the entire overhead of the SQL execution is avoided:  this includes … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Oracle Books Recomented by Jonathan Lewis

By  Jonathan Lewis When I was in Salt Lake City a few months ago, Barbara Matthews (one of the organisers of the SLC Oracle User Group) asked me for my “Top 10” books about Oracle. I don’t normally do lists … Continue reading

Posted in Uncategorized | Leave a comment

Steps for performing database cloning using hot backup

Below steps helps you in performing database cloning using hot backup Assumptions: 1. directory structure is different in both source and target servers 2. Oracle version : 10.2.0.5 3. OS version : Linux 5 4. target database name is same … Continue reading

Posted in Uncategorized | Leave a comment

SCOPE OF ERP

As part of our ERP implimantation in our office, I made this document check list, hope it may help other also SCOPE OF ERP Financial Accounting *    Multi Company *    Business Activities *    Multi Projects / Departments *    Multi Stores … Continue reading

Posted in Uncategorized | Leave a comment