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…)

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