We're running our data warehouse on 12c now (to get the pattern matching stuff), and our warehouse does not have stringent uptime requirements are the feeder systems, so we're a little more at ease in terms of resolving issues should they arise. There's been a few 'wrong results', 'bad plan" issues but nothing too major. But yeah...in-memory is where we're really thinking about heading with 12.x On Mon, Apr 14, 2014 at 4:13 AM, Kenny Payton <k3nnyp@xxxxxxxxx> wrote: > > On the surface 12c seems to be the strongest release in a long time. I’m > not just talking about new features such as Multi tenant and promised In > Memory Database but also commitment to enhancing existing features such as > Flex ASM, Online partition moves, dbms_redefinition enhancements, Online > database file moves, etc.. These features really show Oracle’s commitment > to not only grow there “pay for” options but also continue to add value to > existing features. > > The Multitenant option buys two things for my environment. > > The first is a true multi tenant project in scope over the next 2 years > where we are looking to isolate customers with a potential from a few dozen > to over 2,000 separate databases. Multitenant seems to be a much more > manageable and long term cost effective solution in comparison to > Virtualizing the database stacks. The shared background processes and > database memory pools makes the solution a much more efficient architecture. > > I have 5 single instance servers today that have very large memory > footprints with mismatched workloads with little abilities to share > resources. Moving to a RAC architecture would require a many month effort > of application and database tuning and I have yet to figure out how to do > this without greatly impacting performance while trying to manage 10 busy > instances on 5 nodes. Multitenant affords us the ability to cluster 1 CDB > instance and plug all databases into it while application partitioning the > database per node allowing us to gradually grow into RAC and balance our > workloads. > > Our first step would be 12c GI clustering with single instance 11gR2 > databases on each node. We are upgrading our database servers to UCS > blades which are an ideal hardware configuration for RAC and 12c seems > pretty solid so far within that limited scope. The database upgrades, CDB > with single PDB, would not be until early next year per our current plans > and true Multitenant would follow that. > > We have upgrade GI in a few environments so far and have ran into 0 issues. > > Thanks, > Kenny > > P.S. > > We already have the RAC licenses that are not being used. > > P.S.S. > > Speaking of automobiles and enhancements I recently traded my 2005 Nissan > Frontier in for a 2013 Nissan Leaf lease. Given Federal and State > incentives, gas savings, maintenance savings and depreciation I’ll save > $13k over 2 years. Certainly pros and cons to driving an electric eco-turd > but so far it is living up to everything I could ask for with my 68 mile > round trip commute. > > > > On Apr 12, 2014, at 12:39 PM, Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx> > wrote: > > re: adoption rate seems abnormally low > > What is the motivation to upgrade? I drove a 1986 Saturn SL1 from 1996 > until 2013. It had close to 300,000 miles on it by the time I upgraded to a > Prius hybrid with all the options including faux-leather seats. My "refresh > cycle" was 17 years. For 17 years it took me everywhere I needed to go > including long road trips. > > Pluggable databases are presumably the principal motivation to move to 12c > but the pluggable database option is an extra-cost option. Besides, only > enterprise-edition customers may license it. Since it's a new option, it > won't be included in existing contracts. And, of course, you must be > willing to go through all the testing and effort entailed by an upgrade. > > There are some backdoors as has been pointed out. For example, RMAN and > Grid Control include a license for Oracle database. Off-the-shelf > applications commonly include a license for Oracle Database but they need > to justify the effort and expense just like everybody else. > > Kindest regards, > > Iggy > > P.S. The old car was still in good condition except that the driver-side > window no longer worked. Even the paint was in good condition because I had > always parked it in my garage. It's book value was less than $200 so I > gave it to a student who happily continues to drive it and keeps it cleaner > than I ever did. He even posted a picture of himself with the car on > Facebook. > > -- > Iggy Fernandez > Email: iggy_fernandez@xxxxxxxxxxx > Cellphone: (925) 478 3161 > Blog: So Many Manuals So Little Time <http://iggyfernandez.wordpress.com/> > Author of Beginning Oracle Database 11*g* > Administration<http://books.google.com/books?id=pdSLnG66WQkC&printsec=frontcover#v=onepage&q&f=false> > Editor of the *NoCOUG Journal <http://bit.ly/rC2gRA>* > Lecturer at University of Washington Professional and Continuing > Education<http://www.pce.uw.edu/biography/ignatius-fernandez/> > > > ------------------------------ > From: cameron.hodge@xxxxxxxx > To: k3nnyp@xxxxxxxxx; james.clarence.allen@xxxxxxxxxx > CC: oracle-l@xxxxxxxxxxxxx > Date: Sat, 12 Apr 2014 07:01:52 +0800 > Subject: RE: DB12c in Production? > > <114041200020801383.gif><https://service175.mimecast.com/mimecast/click?account=CUK87A3&code=2b46c94cee7c5606a88700ed422ae53c> > > > Kenny, > We’ve got 12c in Prod for our RMAN Catalogues. However most (all) of our 3 > rd Party applications are not yet certified with 12c and like most > businesses we stay on a supported DB release so that the 3rd party > companies cannot just turn around and say “it’s because you’re on 12c” if > we run into any problems. I doubt we’d run into any issues on 12c as the > majority of apps written for databases utilisze just the basics (tables, > triggers, views, procedures/packages) but “just in case”. > > > > > > > > > > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [ > mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *On > Behalf Of *Kenny Payton > *Sent:* Saturday, 12 April 2014 1:25 AM > *To:* james.clarence.allen@xxxxxxxxxx > *Cc:* oracle-l@xxxxxxxxxxxxx > *Subject:* Re: DB12c in Production? > > > I asked a similar question a week ago on here and didn’t get any replies > where they were actually in production. > > > I’m at IOUG this week and out of all of the sessions I have attended not 1 > person has raised their hand when this question has been asked to the > audience. I’m sure they exist but adoption rate seems abnormally low. The > dogma of R2 being the real R1 seems to be strong with this release. > > > Kenny > > > > > > > > > On Apr 11, 2014, at 10:45 AM, james.clarence.allen@xxxxxxxxxx wrote: > > > Anyone, > > > Is anyone (or know of anyone) currently using DB12c in production? > > > I am having trouble finding shops using DB12c for production. I would > like to read how things are going and if 12.1.0.1.0 is stable enough to > be in production. I read where SAP is waiting for 12.1.0.2 before > certifying > it. > > > Sincerely, > Jim Allen > Database Support Lead, MASSDB > Tel: 301-763-7501 > Database Help Desk: X34944 > Support Email: James.Clarence.Allen@xxxxxxxxxx > Website: http://epd.econ.census.gov/offices/massdb/ > -- //www.freelists.org/webpage/oracle-l > > > > > ------------------------------ > This email contains confidential information. The contents must > not be disclosed to anyone else except with the authority of the sender. > Unauthorised recipients are requested to maintain this confidentiality and > immediately advise the sender of any error or misdirection in transmission. > > > -- Connor McDonald =========================== blog: connormcdonald.wordpress.com web: http://www.oracledba.co.uk "If you are not living on the edge, you are taking up too much room." - Jayne Howard