Re: Migrating 8i OPS to RAC 9.2
- Original Message - > with work (whether it's Oracle or not). I generally find a few whiskeys > help to sort that out! :) > Single malt rules! Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Migrating 8i OPS to RAC 9.2
On a slightly different note, if you are adverse to beta-testing, look for "terminal" numbers like these: 7.1.6 7.3.4 8.0.6 8.1.7 9.2.0.x (zero is certain, x is unclear) Last one, jury is still out - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 9:27 AM > > Hey! We're ALL beta testers. The only reason for people that Oracle calls > "beta testers" is so they can say the rest of us aren't beta testers. But > we are ... and we PAY Oracle for the privilege! > > -Original Message- > > Will the real non-beta-tester please stand up?? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Migrating 8i OPS to RAC 9.2
Heh-heh. Pete as a Company Man. That's one cool picture to have in ones brain :-). One day, over a beer or twelve, I'll tell you about my various debates and disputes over time with Oracle people. They haven't been few. They haven't been dull. That's how it is if you have an opinion. If you don't have an opinion... well, who cares about you then. But as I reached the mature age of 42 - and suddenly knew all the answers - I stopped worrying for three reasons: 1. I'm forgetting a lot of stuff all the time, which helps. 2. My co-director Lasse always reminds me to consider "What's the worst thing that can happen?" and ... 3. ...my Icelandic friend Gunnar always asks "Will we remember this when we're sitting in the old people's home?". So take a virtual whisky with me (Bowmore 12 year in my glass) and let's have a jolly good laugh. One thing I'd like to point out: I use the term "Oracle people", not "Oracle". Oracle is not a person, and Oracle as such doesn't say anything that I know of. I spend 10 years in Oracle Support and I often heard customers saying "Oracle Support says..." when in fact some supporter had said it. I hate when that happens. It's all about individuals, and who cares about that anyway? Forget it, Robert, and come back on the list as your old, jolly self. Let's rock. Mogens Freeman Robert - IL wrote: I'm gonna start callin' ya Pete "Mr. Company Line" Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
Well, you always irritate me with your words and more than just a bit! :) (For those unaware of it, Robert and I have reviewed each others books for sometime now, so we feel free to abuse each other on a regular basis!) As I think Dennis said (but I've deleted the message now so I could be wrong), you've added a lot of value to the Oracle community and should keep that going. There are always times when you can feel irritated with work (whether it's Oracle or not). I generally find a few whiskeys help to sort that out! :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -Original Message- Sent: Wednesday, June 25, 2003 12:37 PM To: 'Pete Sharman '; 'Multiple recipients of list ORACLE-L ' I'm gonna start callin' ya Pete "Mr. Company Line" Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
Hey! We're ALL beta testers. The only reason for people that Oracle calls "beta testers" is so they can say the rest of us aren't beta testers. But we are ... and we PAY Oracle for the privilege! -Original Message- Will the real non-beta-tester please stand up?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
Robert - Please don't back off the success you've achieved. You have been generous in sharing with us the knowledge of Oracle you've gained. If you hunker down in your cubicle like most of us, you won't be criticized, but then is that what you really want? I know for a fact that many Oracle employees monitor this list, because I've received feedback through Oracle. If I were you, I would take it as a lesson, with pretty mild repercussions at that, shrug it off and keep on keeping on. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 3:35 PM To: Multiple recipients of list ORACLE-L I'm gonna start callin' ya Pete "Mr. Company Line" Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Migrating 8i OPS to RAC 9.2
Amen . nothing more to be said. joe Freeman Robert - IL wrote: I'm gonna start callin' ya Pete "Mr. Company Line" Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
Title: RE: Migrating 8i OPS to RAC 9.2 Will the real non-beta-tester please stand up?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 25, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Migrating 8i OPS to RAC 9.2 I'm gonna start callin' ya Pete "Mr. Company Line" Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Migrating 8i OPS to RAC 9.2
I'm gonna start callin' ya Pete "Mr. Company Line" Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Migrating 8i OPS to RAC 9.2
Hi! There's actually no need to migrate any contents of redo logs, since you must have shut down your database cleanly anyway, the logs can be safely reset - no need for keeping them... Tanel. > > A Basic Qs > > Do the 2 Sets of Redo Log groups belonging to the different instances undergo Migration from 8i to 9i ? > If so , how are the Online Redo Log groups individually Migrated from 8i to 9i ? > > Could NOT find any reference to individual Redo Log groups getting migrated in the Docs. > > Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
A Basic Qs Do the 2 Sets of Redo Log groups belonging to the different instances undergo Migration from 8i to 9i ? If so , how are the Online Redo Log groups individually Migrated from 8i to 9i ? Could NOT find any reference to individual Redo Log groups getting migrated in the Docs. Thanks -Original Message- Sent: Monday, June 23, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Hi Vivek, In terms of technical, there is not much difference in normal database upgrade from 8i to 9i and OPS to RAC upgrade. You just need to install the 9i RAC software in the cluster and upgrade the database. But on the other side, Oracle does not see the OPS to RAC transformation as a MIGRATION or UPGRADE. They treat them as two different software components and you need to have a separate licence for RAC, that means you can not upgrade your OPS licence to RAC licence. Other than the installation/upgrade issues, RAC tuning requires deeper understandings of the cache fusion and the GCS,GES internals. For example, the cache fusion will not happen after certain number of lock converts/downgrade-upgrades and it will use DISK to tranfer the blocks between instances. Based on the nautre of the database and the workload, you may want to incrase or decrease the number of times a block can be trasfered over the wire and decide after X number of wire transfers, you can force the disk transfer. But you can still use the GC_FILES_TO_LOCKS parameters in the RAC instances if you know your application very well and I have seen the GC parameters in some of the Oracle TPC benchmarks. And the other interesting thing in RAC is the CR copies are created by the owner, not the requester. But in OPS the CR copy will be created by the requester and the owner has no responsibility other than just downgrading the locks (X to NULL). Like this there are so many small small things are changed in RAC comparing with OPS and some of the basic OPS concepts are no longer valid in RAC (and RAC Tuning). Good luck for your RAC Migration and do let us know if you have faced any of the complexities in the upgrade/migration/or whatever.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
Title: RE: Migrating 8i OPS to RAC 9.2 KG, do you think there is no downside to bring down this parameter? I know we had a peculiar process that really zoomed when we had set _fairness_* parameter to 1, but didn't go ahead with it in production because we couldn't get a satisfactory answer of its downside. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 23, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: Migrating 8i OPS to RAC 9.2 Mladen: I am not aware any of the documentations which explains this cache fusion to ping pong feature(!). There are 3 components in the typical CR prosessing.. Let us assume there is a resource R which is mastered by the instance A and owned by the instance B on X mode. And also we assume the resource R is requested by Instance C. In this case the requester enquires the status of that resource to the master database and got to know that is owned by instance B. So now it is Instance B's respoisibility to constuct the CR and send it to Instnace C. Here, there is something called light work rule (X$KCLCRST.LIGHT?) which decides the CR construction and block transfer over interconnect (again the CR processing for S to N locks are different based on the setting of _cr_grant_local parameter) or thru the disk transfer. Basically the current holder of the resource maintains a fairness counter, which is incremented every time it sends CR copy over the interconnect to the requester and there is a threshold for the number of CR copies created for that resource. Once the ceiling is hit, instead of creating the CR copies, the LMD simply downconverts the lock to NULL and informs the convertion to Intance A. In simple terms it is like a normal OPS ping. The owner downgrades the lock and the requester reads from the disk after getting approval from the lock master. The threshold is controlled by the parameter _fairness_threshold and IIRC that defaults to 4 or 5. So every 6th (or 5th) CR request will most of the times results in a PING and I have seen good performance improvements in most of the RAC databases by changing this parameter. Best Regards, K Gopalakrishnan (Currently I am in a country (for a week) where I have very limited access to the internet , So I may not be able to reply if you have any more questions And I don't have any oracle database/documentation to test/verify. So please take the advise with a pinch of salt !) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Migrating 8i OPS to RAC 9.2
KG, you're an ace. Thank you very much. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Mladen: I am not aware any of the documentations which explains this cache fusion to ping pong feature(!). There are 3 components in the typical CR prosessing.. Let us assume there is a resource R which is mastered by the instance A and owned by the instance B on X mode. And also we assume the resource R is requested by Instance C. In this case the requester enquires the status of that resource to the master database and got to know that is owned by instance B. So now it is Instance B's respoisibility to constuct the CR and send it to Instnace C. Here, there is something called light work rule (X$KCLCRST.LIGHT?) which decides the CR construction and block transfer over interconnect (again the CR processing for S to N locks are different based on the setting of _cr_grant_local parameter) or thru the disk transfer. Basically the current holder of the resource maintains a fairness counter, which is incremented every time it sends CR copy over the interconnect to the requester and there is a threshold for the number of CR copies created for that resource. Once the ceiling is hit, instead of creating the CR copies, the LMD simply downconverts the lock to NULL and informs the convertion to Intance A. In simple terms it is like a normal OPS ping. The owner downgrades the lock and the requester reads from the disk after getting approval from the lock master. The threshold is controlled by the parameter _fairness_threshold and IIRC that defaults to 4 or 5. So every 6th (or 5th) CR request will most of the times results in a PING and I have seen good performance improvements in most of the RAC databases by changing this parameter. Best Regards, K Gopalakrishnan (Currently I am in a country (for a week) where I have very limited access to the internet , So I may not be able to reply if you have any more questions And I don't have any oracle database/documentation to test/verify. So please take the advise with a pinch of salt !) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Migrating 8i OPS to RAC 9.2
Mladen: I am not aware any of the documentations which explains this cache fusion to ping pong feature(!). There are 3 components in the typical CR prosessing.. Let us assume there is a resource R which is mastered by the instance A and owned by the instance B on X mode. And also we assume the resource R is requested by Instance C. In this case the requester enquires the status of that resource to the master database and got to know that is owned by instance B. So now it is Instance B's respoisibility to constuct the CR and send it to Instnace C. Here, there is something called light work rule (X$KCLCRST.LIGHT?) which decides the CR construction and block transfer over interconnect (again the CR processing for S to N locks are different based on the setting of _cr_grant_local parameter) or thru the disk transfer. Basically the current holder of the resource maintains a fairness counter, which is incremented every time it sends CR copy over the interconnect to the requester and there is a threshold for the number of CR copies created for that resource. Once the ceiling is hit, instead of creating the CR copies, the LMD simply downconverts the lock to NULL and informs the convertion to Intance A. In simple terms it is like a normal OPS ping. The owner downgrades the lock and the requester reads from the disk after getting approval from the lock master. The threshold is controlled by the parameter _fairness_threshold and IIRC that defaults to 4 or 5. So every 6th (or 5th) CR request will most of the times results in a PING and I have seen good performance improvements in most of the RAC databases by changing this parameter. Best Regards, K Gopalakrishnan (Currently I am in a country (for a week) where I have very limited access to the internet , So I may not be able to reply if you have any more questions And I don't have any oracle database/documentation to test/verify. So please take the advise with a pinch of salt !) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
Title: RE: Migrating 8i OPS to RAC 9.2 KG, interesting note that I haven't read before ... >> For example, the cache fusion will not happen after certain number >> of lock converts/downgrade-upgrades and it will use DISK to >> transfer the blocks between instances. any idea how one can check/verify this? Are there any hard limits? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Migrating 8i OPS to RAC 9.2
On 2003.06.23 04:39, K Gopalakrishnan wrote: Hi Vivek, Other than the installation/upgrade issues, RAC tuning requires deeper understandings of the cache fusion and the GCS,GES internals. For example, the cache fusion will not happen after certain number of lock converts/downgrade-upgrades and it will use DISK to tranfer the blocks between instances. Can you point me to any technical document confirming such a behavior? My understanding of RAC was based on a talk with a person from oracle support. Based on the nautre of the database and the workload, you may want to incrase or decrease the number of times a block can be trasfered over the wire and decide after X number of wire transfers, you can force the disk transfer. My company is considering converting to oracle 9.2 and buying a RAC license. I did my reading on the Metalink, but I must have missed that. But you can still use the GC_FILES_TO_LOCKS parameters in the RAC instances if you know your application very well and I have seen the GC parameters in some of the Oracle TPC benchmarks. Well, now, benchmarks are precisely the reason why "discrete transactions" were invented and why there is a parameter called "_disable_logging". There was a huge row over discrete transactions (ones that didn't generate normal undo information but went to a special buffer instead) and Oracle Corp. even withdrew from the TPC for a period of 6 months or so. My opinion of audited published benchmarks is that they're all "cooked" to the same extent as the Enron books. There should be a very valid justification for using GC_FILES_TO_LOCKS in a RAC environment and the only valid justification I can think of is CPU consumption. To tell the truth, releasable locks do not work properly in OPS (8i) version and we're still using GC parameters there. And the other interesting thing in RAC is the CR copies are created by the owner, not the requester. But in OPS the CR copy will be created by the requester and the owner has no responsibility other than just downgrading the locks (X to NULL). Like this there are so many small small things are changed in RAC comparing with OPS and some of the basic OPS concepts are no longer valid in RAC (and RAC Tuning). I believe that the OPS in version 8i was doing precisely that. That was the responsibility of the BSP process. The ability to generate a read-consistent copy over the wire was called cache fusion. Good luck for your RAC Migration and do let us know if you have faced any of the complexities in the upgrade/migration/or whatever.. Thanks! One more question: would you recommend automatic undo mgmt for a RAC environment? In an OPS environment, we created private rollback segments for each instance to minimize pinging and each instance has it's own tablespace for rollback segments. There can be only one undo tablespace in 9i instance. Have you experimented with AUM and RAC? Can I have each instance look into its own undo tablespace? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Migrating 8i OPS to RAC 9.2
Hi Vivek, In terms of technical, there is not much difference in normal database upgrade from 8i to 9i and OPS to RAC upgrade. You just need to install the 9i RAC software in the cluster and upgrade the database. But on the other side, Oracle does not see the OPS to RAC transformation as a MIGRATION or UPGRADE. They treat them as two different software components and you need to have a separate licence for RAC, that means you can not upgrade your OPS licence to RAC licence. Other than the installation/upgrade issues, RAC tuning requires deeper understandings of the cache fusion and the GCS,GES internals. For example, the cache fusion will not happen after certain number of lock converts/downgrade-upgrades and it will use DISK to tranfer the blocks between instances. Based on the nautre of the database and the workload, you may want to incrase or decrease the number of times a block can be trasfered over the wire and decide after X number of wire transfers, you can force the disk transfer. But you can still use the GC_FILES_TO_LOCKS parameters in the RAC instances if you know your application very well and I have seen the GC parameters in some of the Oracle TPC benchmarks. And the other interesting thing in RAC is the CR copies are created by the owner, not the requester. But in OPS the CR copy will be created by the requester and the owner has no responsibility other than just downgrading the locks (X to NULL). Like this there are so many small small things are changed in RAC comparing with OPS and some of the basic OPS concepts are no longer valid in RAC (and RAC Tuning). Good luck for your RAC Migration and do let us know if you have faced any of the complexities in the upgrade/migration/or whatever.. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).