Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id B634C196123D for ; Tue, 9 Sep 2014 06:52:10 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Tue, 9 Sep 2014 06:52:10 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C7EF22F3D8; Tue, 9 Sep 2014 00:52:02 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JK-FBFsBi5hg; Tue, 9 Sep 2014 00:52:02 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 045D12F2C0; Tue, 9 Sep 2014 00:51:21 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 09 Sep 2014 00:50:41 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9EF9F2F1E6 for ; Tue, 9 Sep 2014 00:50:40 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Azn+tWGfiE89 for ; Tue, 9 Sep 2014 00:50:40 -0400 (EDT) Received: from mail80.mimecast.co.za (mail80.mimecast.co.za [41.74.197.80]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 449582DAC9 for ; Tue, 9 Sep 2014 00:50:10 -0400 (EDT) Received: from rkshs01.bcx.co.za (RKSHS01.bcx.co.za [165.233.60.129]) (Using TLS) by mail80.mimecast.co.za; Tue, 09 Sep 2014 06:50:08 +0200 Received: from nobody by rkshs01.bcx.co.za with local (Exim 4.76) (envelope-from ) id 1XRDNV-000AYJ-UW for oracle-l@freelists.org; Tue, 09 Sep 2014 06:50:05 +0200 Received: from [10.10.17.19] (helo=EXHUBHS01.africa.enterprise.root) by rkshs01.bcx.co.za with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.76) (envelope-from ) id 1XRDNV-000AYE-Q2; Tue, 09 Sep 2014 06:50:05 +0200 Received: from EXMCHMID01.africa.enterprise.root (172.21.249.56) by EXHUBHS01.africa.enterprise.root (10.10.17.14) with Microsoft SMTP Server (TLS) id 14.3.181.6; Tue, 9 Sep 2014 06:50:05 +0200 Received: from EXMCHMID02.africa.enterprise.root ([169.254.2.109]) by EXMCHMID01.africa.enterprise.root ([169.254.1.82]) with mapi id 14.03.0181.006; Tue, 9 Sep 2014 06:50:05 +0200 From: George Leonard - Business Connexion To: "sethmiller.sm@gmail.com" CC: Bala Krishna , Oracle-L Freelists Subject: Re: Dataware house DB's Cross Platfarm migration Thread-Topic: Dataware house DB's Cross Platfarm migration Date: Tue, 9 Sep 2014 04:50:04 +0000 Message-ID: <9D604510-5B14-4C85-911C-59DBC435D236@bcx.co.za> References: In-Reply-To: Accept-Language: en-ZA, en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [10.10.17.13] MIME-Version: 1.0 X-Recipient-Count: 3 X-Sender-Host-Name: EXHUBHS01.africa.enterprise.root X-MC-Unique: 114090906500801001 Content-Type: multipart/related; boundary="_004_9D6045105B144C85911C59DBC435D236bcxcoza_"; type="multipart/alternative" X-archive-position: 56268 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: George.Leonard@bcx.co.za Precedence: normal Reply-To: George.Leonard@bcx.co.za List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_004_9D6045105B144C85911C59DBC435D236bcxcoza_ Content-Type: multipart/alternative; boundary="_000_9D6045105B144C85911C59DBC435D236bcxcoza_" --_000_9D6045105B144C85911C59DBC435D236bcxcoza_ Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Hi there, You can potentially look t outlines, to "pin" the execution plans, but also= remember what you might end doing is pin a execution plan that works now, = but might actually end with a even better execution plan on the target plat= form. As long as you're just moving platforms you should not really get a change,= you're moving the datafiles as they are. if you updated the system stats and told the kernel/optimiser about a diffe= rent cost to IO and CPU then ye, that might change the plans, but then agai= n, don't you potentially want this. I'd record what the execution plans look like atm, hen migrate, where it we= nt worse go and implement changes to revert to old plans, but let the syste= m first see if it can't do it better. Yours Sincerely ________________________________________ George Leonard Oracle Engineered System Specialist Mobile: +27.82 655 2466 eMail: george.leonard@bcx.co.za Web: http://www.bcx.co.za [cid:6EA60917-E50D-422D-BF1F-E8C59EADC861] On 04 Sep 2014, at 5:43 AM, Seth Miller > wrote: Bala, Real Application Testing (RAT) was designed to address these exact quest= ions. The two tools in this group that are relevant to your questions are S= QL Performance Analyzer (SPA) and Database Replay. Seth Miller On Thu, Aug 7, 2014 at 8:52 PM, Bala Krishna > wrote: Hi Team, We've a plan to migrate Dataware house Database's from Aix to Linux with Tr= ansportable Tablespace as an option. Bascally i'm looking forward to measure performance before and after migrat= ion and its implications. Requesting you to please answer the below questions , i appreciate if there= are any pointers to some links etc. 1. Since the change in system stats how do we make sure that our execution = plans will not change majorly ? and its performance slowness. 2. If there are any executions plans are really performing bad after migrat= ing , what would be the best options that you suggest to compare before and= after migrate plans and suggest the best solutions to resolve those issues= ? 3. Implementing baselines is that a good idea ? 4. Exporting and importing stats will help to keep best optimum performance= ? Appreciate your response. Regards Bala --_000_9D6045105B144C85911C59DBC435D236bcxcoza_ Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-ID: <2A6AB7825E9A4247B226671AA7D3BA61@bcx.co.za> Hi there,

You can potentially look t outlines, to "pin" the execution = plans, but also remember what you might end doing is pin a execution plan t= hat works now, but might actually end with a even better execution plan on = the target platform.

As long as you're just moving platforms you should not really get a ch= ange, you're moving the datafiles as they are.

if you updated the system stats and told the kernel/optimiser about a = different cost to IO and CPU then ye, that might change the plans, but then= again, don't you potentially want this.

I'd record what the execution p= lans look like atm, hen migrate, where it went worse go and implement chang= es to revert to old plans, but let the system first see if it can't do it b= etter.

Yours Sincerely

________________________________________ 
George Leonard
Oracle Engineere= d System Specialist

Mobile: +27.82 655 2466

On 04 Sep 2014, at 5:43 AM, Seth Miller <sethmiller.sm@gmail.com> wrote:

Bala,

Real Application Testing (RAT) was designed to addre= ss these exact questions. The two tools in this group that are relevant to = your questions are SQL Performance Analyzer (SPA) and Database Replay.

Seth Miller


On Thu, Aug 7, 2014 at 8:52 PM, Bala Krishna <krishna000@gm= ail.com> wrote:
Hi Team,
 
We've a plan to migrate Dataware house Database's from Aix to Linux wi= th Transportable Tablespace as an option.
 
Bascally i'm looking forward to measure performance before and after m= igration and its implications.
 
Requesting you to please answer the below questions , i appreciate if = there are any pointers to some links etc.
 
1. Since the change in system stats how do we make sure that our execu= tion plans will not change majorly ? and its performance slowness.
2. If there are any executions plans are really performing bad af= ter migrating , what would be the best options that you suggest to compare = before and after migrate plans and suggest the best solutions to resolve th= ose issues ?
3. Implementing baselines is that a good idea ?
4. Exporting and importing stats will help to keep best optimum perfor= mance?
 
Appreciate your response.
 
Regards
Bala


--_000_9D6045105B144C85911C59DBC435D236bcxcoza_-- --_004_9D6045105B144C85911C59DBC435D236bcxcoza_ Content-Type: image/gif; name="image003.gif" Content-Description: image003.gif Content-Disposition: inline; filename="image003.gif"; size=3863; creation-date="Tue, 09 Sep 2014 04:50:04 GMT"; modification-date="Tue, 09 Sep 2014 04:50:04 GMT" Content-ID: <6EA60917-E50D-422D-BF1F-E8C59EADC861> Content-Transfer-Encoding: base64 R0lGODlhbgBCAPf/ANHQ0dbV1fWEifn5+UZCQ/eVmf729oB+fq8PFWViYz05OvHx8XVyc/WBhs3M zPb29sbFxfPz811aW+zs7LKxsfj4+J6cnP39/fedoekaI/aOkvvQ0feZnPijptkbI05LTPiqrSYi I/zZ2vimqbm4uC0pKvzc3vNlaDUxMlVSU/3p6q6srfaSlfR0efT09P3h4vm2uf/9/fRtcv3l5oqI iPm6vPR5ff7u7/qusaCen+rq6vEpKfmxtJiWl+no6Obm5mcBAfzV197e3qupqTAsLV8JCpCOjtva 2jg0NczLyyklJncAAP74+Nzc3IgDBGBcXFFNTvaIjP/6+vvMzv7y8v7w8La0tfrAwsPCwpqYmfNZ XvFNVOPj4/JbYYiGhkE+P/NpblhVVuTk5JuZmvBGS/vJy46MjIeFhX99foKAgEdERSUgIZeWlsgW HnFub5oIC/q8v9gkK/FTWaKgofaLj/V8gfm4uqalpWtoafIcJO/u7i8cHZORkvvKy/zb3PrCxewT HISBgnx6evvHyeLh4aSjo7Cur2xqanl1dvJgZvRxdnp4eOHg4GhlZvvP0fq+wB0gIR8fIL++vv// /ysnKPv7++Df4MjHx/3j5MvKy3JvcPaJjv/7/Pb19b28vejn58HAwMLBwW9sbaimpzo3OP3n6PrF x5aTk/ego8nIyLy6u/isr+7t7pGPj2pnaDMvMP3r7MC/v8rJytjX2JmXmFpXWP7v8Pze36mnqPzX 2PvS06yrq0tHSMrJybi3t8TDxP7z87WztKGfoPzT1Y2LjIWDhGJfYPioq21ra9PS0r69vTUiI+44 Ntzb26qur9PU1K+2uNuqq56ho5yNj6cmLLu8vtbZ2sLDxcfCw9vCwsrLzfq9pvWNbIlEREIfIe9H SfFWQXxhYvnZ2vA9RKyusdna3KMNEbOysu/w8Otuc7q/wcefn4uJioVhY/rBtuq6uz5DRFUhJKGk pO3t7b7Dxaasr357fNBQVeHi4+8gKf3ez9bCw9DPz/f7/CMfIP///yH5BAEAAP8ALAAAAABuAEIA AAj/AH+MGkJwyC4sC/4pXMiwocOGF9KU+BDgocWLGDNq3CjJn8eP/pDk2KhR2cdGJFOqXGmxI0iQ PVg6VPUxgcybODG69KeplSYlHlH4yPlvAKIQBJIRXUp0ZxKFWT5CWHnhwYCGLipZrKr14YAHF79e ePgALNOFOzMpdPAx1T8+rhqNWSgEmSg8sxQGYMBLAYEUgnx0YiCqkad/ZhohI+TjzAcFami4YGhF wpcvKQpdVThgTpjLvIytUNgYyuUPogCcTauQj0ck8/6F8Whz7Ucs/1QBfQnKBRGPFv5B8fgEyUuU /y4geumvFrqixphD+SdEAfNWqz/iOWMshD8lFBTO//ZX+x9bj1MJvH4ShpS/WJ1++ws+/KMSIms+ gvrXymMJN6KU4JEb/6zgUQhQPMHLGtO54V8Ylq2BHVM7vaRGXrLRttB5/vSiw27nKPTALz/oIR99 HlHCjhCdWPARGw+g4JEqCp3j0RpCFONRCgtZgkUF6vlzhkKV8KMUhcx9tIYhGZK34UeX+OYRASsk pJAOJwrnkSgLoWOcP0a49IUYP/zAiHX+jBKVPyEIUtFC9aFAyw9nofVRFhCAwsYrr6HzhIa2eYSb ICC9sgidWAKnJU8LVRJkK6ccWAIllJTgnT/2cCHgjR8Eo9AoIFGSwJFIeqSWQobolwCg5t32zwMH UP8CkgJcoJNlfZo0qoZHRrCT5EfI/APBriDRoFAOMtp3WKn+nPpPMh8Fs6qTgfqDm0I/sBGkPwxE cKtHuRJJbCtjBBXLL6Gki4Ukbw4ACh6ysvkmOkOk8BEBmzX10VMKGfFRMnh49MGTgr7K0LS8/MDn fIuG+08lxJrB4bINDTCWQr98FB5DZnikhCXMukFMICnk5w+PZ3xEgxAOTOtPKjrwMocQenAxXgo6 LIwio+J6NGSQJbSSzCyxIDOXF43IMsECuHxkRQJnzKLHPIt4RMQnzDKHglLJXOrPGiZ7lEQPHr+y mz85xKcorrp6FEhuXn/tES+WyLhGCfh5pMYdBxL/sak/eGTHHCWNCLFQDl6HEEgtHpHQw983ovHP BN/y/HCQb//jCZoflUBDAB8w90UAwXwJ0hMTnOWDIRS03rondDYUQCv2CP3PLCusYLgPFBhxQBpj vFmBFYas0MQ/WOTuwEIXSFI8qRGcQ4M9NOyC9cMOWFCMPexYMdk/LnhyShoH8HHJxXWmr/767Lfv /kI6fO9+BFjQEoggZwjjQL7vM1XJIiH4Ar/W5wI2cA4kDOhfnXbyBPYRInS/aqACmRKKjxhjfT/Y FhICsQJVrOAMpLjgBJdygTMQgSLrC5hHGhEbhixANY1agAvQZ5EBLIB/DqnAAroCkQjMkCWVoCGR /xbQCY3YEIfC+kgKKoARIaCBF0ggxQdoELsHMEACCfgBANzwBSR8gQZFnIcrJICMBUDAFV9AAQFO wcMKWAAKSEACFMbARDaEwRh4GIpC9OCGJ6TgDgNARgJqYYWFAIABBIhiCtjwnFdpQgKuYEUSkJFG AhDDLAohlEckgRESyAckKJiKC9xzMsj5g0A/EFAIwnA2j6RBIRGQAHMkUAEhLMxhy/HHF5YmHzYc K25TOsI/FmCcNaQgXh9J4EIgiAI9XAQAmyKCBD5wKST8YACk9A8SwpYMVkCOCCgwGSUMVzV/vCIQ iNgNIv5BgY8M4R+78Njy5tHLf5DgI0h4ArH8wf+LspjOH0TYpseEqZBk8UKIDImOP0hBUHlE4qEH +AcpUVAIHVTCNR4ZxQI2pQBDzGMAafhILD4hKyXA0EDfOZ49PKIAXySrEAqhp0ey8A9ezE0HCqHB R+7wjy8hARcTGAAxPsIkhSxMDTxsCCE2FZOFPGEPa4DHPNBkLGxtygIR2NRI9GIyVTSNn1xohhCS sTBc/CMCNv2OR5T5D5n6Yw4AcNpCXPAFj0jgAV8ywkK4EK+t/iNIr9CjQyrokeX9QwQyiIMHPECN fdTVH1UdZrKwuqk59Gg3JAjEjULA2RCYrKrJ+FsK5OfWO3yVElxgiIPW8AUdkHJCbc2SQpChMYv/ WOEjz/gHDvJBBi3kIw95iEM8IAHZhSxgsln1iGUVYgnMavJXklOIvTziBYaUNgdWE+w/yqkAH7x2 IW4NjkJQ6g8CsOIhvfBIJLAhjnycQB+TAAMgMtAGc+whEpE9LnCS+9bLzmioa1CAAxyQiQI7oBeM UEi5lHSt2HqkEO382psUotAPLOC7MZXtq9J6MkLIThnuiQQi0rEDbmzDHd8AhAcQ8IYiQIIdxkVu Zf3rDxK4ZA0NbsglvEOEtO4ywx7JgSVMVl2FCGFTgbjAl2AbXoaEwmv/mcMoWjGbBBzAH5FYhgd2 AA5mZODLbUCAE4CwhvzKWLk0Ds9jS2AGWTiA/wJhsOwPHmuEeZCSSw72By3+odAQjIERDpiuEmYx gCWDV8MKsYIpQVICWaQAEt74ch6+TF8WLwEIezDzfmfM3N2MxgphAwkULqDQWmjFFx+BqVt9KYRs evYjwYmAoYHMsIYI4RCmDAEvLFCJeeBBy5POgAfC/AYnXHoNMFYIOs7sD2HQeDT2fOxHSJGDlIXE wwpBQ4qSISV/+JI6jJvVxojpESYjmiE+UMUpaNAKQxwhqYS4x2LbQGxjA6EbCG6UAy5Bokpk4hIQ uN6rZAHw1IkIC+vuAQSKmAoIQOB4C4lAKlKBBcMlgd+xS04AckADPvRG3/xOLZEuTiKcvMMcCP8w R7EvDQQgZGOEMCdKNJxg7CWwfB2TyHnMd56SSfRjFu0oQsuLUIRwQEMd13gGPtBRiUnw/OkPmUQE rEEPZ1hgGqeQRj3IUQ1tlMMHM3Q61MfukJyb/exiJ7va1872trv97XCPu9znTve62/3ueM+73ve+ EgNg4gacMEBOYvCHBhQA5jMAwQirAAIYwGEVOLmBBq6ACsXnhAkK8QMsMrKJwzdECpxoiAleoAIR GGAYMuHEFXSBgQ7cpBQNCAIMLI+TK9BBIS3ABEakAAYVNMQWLRA8Q8AQBBuYAgaouAkVDHCDG8ik CnXwgwGm0PcYNIQFNfiH6q3PEANw/x+6sIH/Q0yhgYUI3g8tAIYMYrCBGSjEFpvXPuYx4v2cbMIU DLkFBzqwed+PQPfu93//UAaJcAX/8AIN4Aj/YAMgUAO3UAoioHhS8A9TkAgwsBAYgAP/4H48gHoF wAIgMH0n8Ad2AAJTcHjU9w830AW3ZwAcAAaccANSEAQa+A8wIAD/0AcnYIA3UQMskH+bQHmbAAcY sApaYIMcAAJHGAQN0AAqYAKb4AczwAEnsAFU0AK3QAdX8AI2YAJNaAILYQOYsAGb8AdbYAtwoAUw AAsi0AACAAsF8AIY0AdwUH63oAGb0AD/gAFRgAH/0AIisAUGiAEgcAN+IAACoHs30QDupxCc/9AA YKgLAsACI3ACI/APDQACYHCJNqAIU8AJNlAKFLgJPPAPmBAFf3gDL8ACAiAD+KcQVaAI/7B/isAC pdAB5fcPdaAIffAPm8AJUXADUSACVCAAM5AImzADXcACnNAHAlAAJ/APNeB5NiADg4ATL9ACC3ED DZAICtEBGCADx1AApnADYNABqDAFL9AFt7CHGggDTIABuSCNI8AJ2jgCq5AIIvAPwKAQurAJMQAG BTACx/APcKB4t6AFfvAPfvCLGmAADcAEBXAFBbAJHcABqOiLLQAHAgCKwFAKqJAI7UgFN4EJW3AL sAADLKALWrABPAACIyAH/1AANcABR4gBB/SpAcAwAmSwAagAB/8QBUHwCBzwCMCgCIOAAX8QBcCA CmWgECo5BWQADDjAATHQATXwCCBAB8DQASPwkBowA3RgBydQALAAAjhQB7ngCCwwDjWgAnUABzYg AhyAAwVABajQizeBAScwlhPIAzZwgR1AfbeACnWgCweolALAAS8AAkKpECNQADcwe77IAkxgC4Y3 j/5YA5z5D7DAASIwBVGgC1XQABzgB1LQAVQAAiLAAgXQAROoAboABw0AA0HAAQqxCh3QACNgAFXw jPvId0zxiP0onAqkAtxnCj9onAq0CRvAj1EgiszZPy8gACPAAUGQEwEBADs= --_004_9D6045105B144C85911C59DBC435D236bcxcoza_-- -- http://www.freelists.org/webpage/oracle-l