This week we continue our look at the new features of Dbvisit Replicate 2.8. Last week we looked at some of the Setup Wizard’s changes along with the adding of template files and start and stop scripts. When Oracle 12c was released, Dbvisit Replicate 2.6 was released very quickly and supported Oracle 12c. Dbvisit Replicate 2.7…
The concept of cursor sharing is simple. If an application executes SQL statements containing literals and if cursor sharing is enabled (i.e. CURSOR_SHARING=FORCE), the database engine automatically replaces the literals with bind variables. Thanks to these replacements, hard parses might be turned into soft parses for the SQL statements that differ only in the literals.
The question raised by the title of this post is: in case cursor sharing is enabled, does literal replacement always take place?
I’ve been running my Apex sites on Amazon EC2 for many years now, and I’ve gone through a number of infrastructure upgrades and price changes over time. I have some alerts set up, e.g. if a server starts getting very busy or if my estimated charges go over a threshold. Today I got an alert saying my estimated monthly bill will be over $100 which is unusual.
Ever since I decided to study and work in the IT industry I’ve noticed a common pattern; the constantly evolving characteristic in every single aspect of an IT infrastructure, from networking to OS, from app development to development methodologies, from servers to databases…and the list goes on.
style="font-weight: 400;">From Data To Data Insights
style="font-weight: 400;">Companies are betting big on
href="https://www.pythian.com/data-enablement/">data, and are seeing payoffs from these investments. According to MIT Researcher Yang Lee, 65% of Chief Data Officer positions have been established within only the past 3 years. It’s clear that we’ve entered a new era where there is a strong desire to convert data into data insights.
I’ll be presenting the next round of “Let’s Talk Database” events around Australia and NZ this winter in July/August 2016. These are free events but due to limited places have often “sold out” in the past, so booking early is recommended to avoid disappointment. All events run between 9:00am – 12:30pm and are followed by a networking lunch. We always have […]