Translate this Page

 

Sometime we got difficulties to get actual result of the explain plan when we want to see the cost of the query that we made since the number of records in the development server have significant differential with production server. To solve this problem we can transfer the Optimizer Statistics from Production server to Development Server.

Other concern why we need to transfer the Optimizer Statistics, because it will take long time to gather a big schema instead to transfer the Optimizer Statistics.

This is the Step-By-Step to transfering the Optimizer Statistics, Good Luck ;) Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha