Home » ORACLE » Archive for category "BEST PRACTICES"

Weblogic Thread Monitoring: Your Finger on the Pulse of the Middle Tier

Introduction WebLogic thread monitoring is very important for all slow or hanging application server issues. All WebLogic (middleware) requests are processed by thread pool thus it becomes a very important place to check for the problems. In Oracle DBA terms it’s very similar to checking database active sessions. Weblogic server architecture Weblogic server has a

(Read More…)

Cintra Data Masking and Subsetting Solution

Most of us know that Oracle has an option that can be added to Enterprise Edition databases called the Data Masking and Subsetting Pack. This is a powerful solution, typically used to mask data when it is exported from a Production database and loaded into a Non-Production environment, so that our Developers do not have

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

Private Cloud Design: Pick the Right Brick

I guess many of you still remember good old times when your company had about three core applications, users were less than twenty, the client layer was installed on a few workstations and all this was fitting perfectly on 2 single instance databases. And then, the company grows, business gets diversified, and suddenly IT becomes

(Read More…)

Exadata: How Cintra Ensures a Smooth Deployment

Oracle Exadata has picked up popularity in recent years as each generation has become more capable and feature-rich. Exadata is the number one choice for any Oracle architecture where extreme performance, reliability and consolidation is the key. At Cintra, we have been working with many customers helping them migrate to Exadata and making the transition

(Read More…)

Effective Database Management for Agile Development

With the transition of modern day software development to an agile methodology and more importantly more and more organizations adopting this approach, the implication to the Database Administrator is to be a key active participant in the agile development teams. DBAs are under constant pressure from development teams to make changes to the schema, optimize

(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 Eliminates Generic Hosting Rights and Lowers Discounts for SaaS providers for Technology Products

In a move that underscores the growing threat of competitive Cloud based services to Oracle’s traditional perpetual license business model, Oracle announced in October that they are no longer providing Generic Hosting Rights for Oracle Database  and they are raising prices for database licensing for SaaS/Cloud Services providers. This move will effectively remove any potential

(Read More…)

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