Home » ORACLE » Archive for category "DATABASE"

Got an Oracle-based app running slowly? Here’s your guide to effectively diagnosing it

We’ve all experienced that frustrating wait while a web page loads or a business application takes an age to process something. Poor user experiences cost your organization money and risk damaging its reputation. And with so many companies now using customer experience as a differentiator, any that lag behind are at a serious disadvantage. But

(Read More…)

Oracle 12c Multitenancy: Pluggable Database Concepts

A few years ago, Oracle released a multitenant database architecture that featured a concept called Pluggable Databases. The basic idea behind this architecture is a set of containers. A multitenant database is comprised of: One root container which acts as the main repository for metadata and common users One seed pluggable database that acts as

(Read More…)

Oracle 12c: Real-Time Database Operation Monitoring

In the latest release of Database 12c, Oracle has come up with another brilliant feature for performance monitoring: Real-Time Database Operation Monitoring. Real time SQL monitoring was introduced in 11g and helped with monitoring SQL query performance in real time. However, only individual SQL statements could be monitored in 11g. Now, imagine there is a batch

(Read More…)

The Oracle Optimizer: Mode Considerations

Oracle’s Cost-Based Optimizer has been with us now for a long time. Choosing the right mode setting can improve the average performance of your database queries and is often overlooked. The Optimizer tries to determine the best execution plan for a database query based on many factors including table statistics, query predicates, joins, indexes, partitions

(Read More…)

Tales from Oracle OpenWorld 2015: Day 2 (Monday)

Oracle OpenWorld kicked off in earnest today, with over 65,000 people descending on the Moscone Center for their dose of Oracle knowledge! If you couldn’t make it in person, here are the Cintra team’s hottest topics of the day: Monday Morning Keynote: This morning’s keynote was largely in line with Larry Ellison’s presentation the previous

(Read More…)

Oracle Discontinues Standard Edition and Standard Edition One and Introduces Standard Edition Two (SE2)

By Seth Feeley  sfeeley@cintra.com On September 1, 2015 Oracle announced that with the release of 12.1.0.2, Oracle Standard Edition and Standard Edition One have been discontinued and replaced with a new product called Standard Edition Two (SE2). At Cintra, we’re reaching out to our Standard Edition customers to inform them of this significant change in

(Read More…)

Oracle OpenWorld 2014 Hot Topics

Oracle OpenWorld, the company’s week-long convention in San Francisco, was bigger this year than ever before. More people, more lines, more products, and more technical sessions than in any previous year. So, what nuggets of information did the Cintra team pick up at OOW? This year, the overriding theme was 12c. Whether it was 12c

(Read More…)

Zero Downtime, Zero Risk Oracle Migrations

As the world of data is constantly, exponentially expanding and uptime requirements are following suit, this presents problems for not only storing that data, but how to migrate it between Oracle versions. Oracle Database 12c presents some compelling benefits, but if we cannot move our multi-terabyte database to it without significant downtime, we may not

(Read More…)

Duplicate Indexes: Less is More (more or less)

When investigating database performance problems, a common issue seen is duplication of indexes, literally the same column included in multiple indexes. This is often due to a misconception that all predicate columns in a query should be indexed. This can lead to multiple indexes being inadvertently created on the same lead columns. Indexes are used

(Read More…)

Oracle OpenWorld 2012 – A DBA’s Perspective

The last time I attended Oracle OpenWorld was way back in 1996, in the days before Oracle acquired Sun, JD Edwards and a plethora of other companies. It was pretty small-scale back then, with a single exhibition hall and sessions which were almost exclusively focused on database technology. Not so in 2012; with around 50,000

(Read More…)

© This website and its content is copyright of © Cintra Software and Services 2011. All rights reserved.