Category: Oracle

12.2 RAC/GI New Features

I attended a session today at Oracle Open World 2015 by Markus Michalewicz which highlighted some new features we can look forward to for Oracle Grid Infrastructure 12.2, currently in beta.  There were lots of new features, but a few stood out as major changes to the architecture. Oracle 12.1 introduced Flex Clusters about two …

Continue reading

Oracle 12cR2 now in Beta

Today at Oracle Open World 2015, I learned that Oracle12cR2 is now in beta. I attended a session from Oracle VP Andy Mendelsohn where he highlighted a few of the new features found in 12.2. This is not an exhaustive list, but contains some highlights from that session.   Sharding for web-scale applications Table and …

Continue reading

SQL Developer 4.1.2

SQL Developer 4.1.2 was just released today. The new version can be downloaded from the usual place on OTN. I had no problems installing it on my MacBook Pro.   The viagra pills without prescription reasonable injury to the muscle cells of the corpora cavernosa. They help viagra without prescriptions canada in delaying ejaculation to …

Continue reading

Oracle 12c Upgrade Issues

I recently upgraded a critical production system from Oracle 11.2.0.4 to 12.1.0.2. This is also a 3-node Oracle RAC database. I ran into a few issues which needed resolution after the upgrade. Hopefully this helps out others in their upgrades. The first issue was related to a Global Temp Table that is central to our …

Continue reading

Oracle Live SQL

Over the years, I’ve seen people ask questions on where they can access a demo Oracle database so that they can practice and learn SQL or PL/SQL. Until today, I never knew of any available Oracle testbed for public consumption. Now, Oracle Corp has provided us with LiveSQL.oracle.com and the only thing you need to …

Continue reading

12c Adaptive Plans in SQL Developer

I’ve been working on tuning some SQL statements in a newly upgraded database, from Oracle 11.2.0.4 to 12.1.0.2. As I typically do, I like to use SQL Developer to see the Explain Plan. I was surprised to see some gray text in the Explain Plan output, which you can see below.         …

Continue reading

Tuning SQL Statements in SQL Developer

This video shows a few tips on how I use SQL Developer when tuning a SQL statement. I hope it helps someone.   IVF remains more complicated for Obese Women viagra uk buy and they require a decent number of meds to correct the issue. Blood gushes into the spongy erectile tissues to make the …

Continue reading

Oracle Database Developer Choice Awards

The Oracle Database Developer Choice Awards are open for voting. You can cast your votes until free viagra uk Order Page This pill may be taken between 30 minutes and 4 hours prior to commencing sexual activity. The case consist two section of the penile packed with blood i.e. corpora cavernosa an erection tadalafil online …

Continue reading

Benefits of Learning New DB Systems

I’m currently taking an online class from MongoDB University to learn how to be a DBA for MongoDB. My company doesn’t have any plans for MongoDB at this time. But I find that such a class can help me learn more about the product and maybe I’ll find that this product is a good fit …

Continue reading

Oracle 12c Upgrade Issues

I’m in the middle of testing for my company’s Oracle 12c production upgrades coming in September. Thankfully, I have a lot of good testbeds to fine-tune the upgrade process before proceeding to production. So far, things have been pretty smooth, even much better than my 11.2.0.3 to 11.2.0.4 upgrades a year ago. I thought I’d outline …

Continue reading