Unexpected execution plans due to system changes such as optimizer version and statistics, schema/metadata definitions, and system settings can have disastrous effects on performance. Learn how 11g SQL Plan Management (SPM) provides controlled plan evolution to ensure stability and consistent SQL performance.

ASH is one of the most powerful instrumentation related feature Oracle ever introduced and yet it is one the least explored feature. In this article, I explain how ASH can be used for troubleshooting, performance tuning, root cause analysis, scalability and capacity analysis. I also explain key performance related data that is only captured in…

ASH is one of the most powerful instrumentation related feature Oracle ever introduced and yet it is one the least explored feature. In this article, I explain how ASH can be used for troubleshooting, performance tuning, root cause analysis, scalability and capacity analysis. I also explain key performance related data that is only captured in…

With the great interest in ‘Big Data’ solutions, hear why the Oracle platform is perfect for ‘Big Data’ requirements with analytic and SQL capabilities to join ALL data types, including relational, Spatial, XML, text, semantics, multimedia and other unstructured data. Get an introduction into the features in Oracle Database for storing, managing and analyzing unstructured…

This is a two-part session that will take place on Tuesday and Wednesday. While Developer/DBA's are busy researching new features to solve existing performance issues, they tend to ignore or forget existing features to improve performance. At Verisign, we have millisecond SLA's forcing us to squeeze every millisecond from our database and based on this…

SQL is arguably the world's most popular programming language today, and SQL database servers and systems are used in the majority of mission-critical business applications. However, many applications need capabilities such as transactions, concurrency, and high performance usually associated with database servers, without the query flexibility or overhead of SQL. Oracle Berkeley Database transactional key-value…

SQL is arguably the world's most popular programming language today, and SQL database servers and systems are used in the majority of mission-critical business applications. However, many applications need capabilities such as transactions, concurrency, and high performance usually associated with database servers, without the query flexibility or overhead of SQL. Oracle Berkeley Database transactional key-value…

Passing comma-delimited parameters to Oracle stored procedure is complicated by the fact that the interpretation by Oracle of commas is contextual. We take a look at various real-life situations where this is needed and a clever programming technique whereby we could avoid the pitfalls and achieve the desired result.

IPM 11g is on a completely different architecture!! If you have been using IPM for some time, and now that it is time to upgrade have been told there isn't a clear path to make the upgrade, you need to attend this session. Learn from those that have done this before, and were successful. You…

This session answers many questions around Oracle Resource Manager implementation based on a real implementation at SEI a Global Wealth management service provider. The crux of the problem that was solved at SEI was managing prioritization of workload specifically to leverage infrastucture there is always the possibility of fierce competition for resources when N number…