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.

OBIEE 11g Balanced Scorecard is a Key Performance Indicator (KPI) based analytic application which generates Balanced Scorecards and other functionality that makes KPI analytics valuable, visible across the organization, and increasingly actionable closer to real time. How does it work? The logical split as well as its reflection in the underlying metadata is twofold: KPI…

OBIEE 11g Balanced Scorecard is a Key Performance Indicator (KPI) based analytic application which generates Balanced Scorecards and other functionality that makes KPI analytics valuable, visible across the organization, and increasingly actionable closer to real time. How does it work? The logical split as well as its reflection in the underlying metadata is twofold: KPI…

OBIEE 11g Balanced Scorecard is a Key Performance Indicator (KPI) based analytic application which generates Balanced Scorecards and other functionality that makes KPI analytics valuable, visible across the organization, and increasingly actionable closer to real time. How does it work? The logical split as well as its reflection in the underlying metadata is twofold: KPI…