Ever wondered how Oracle locks a row, or a table? Is there a master lock manager? No, there is not. In this session you will learn how Oracle manages the locking with demos, how ITL slots are used and how you can avoid the issues related to ITL slots. Also learn how unindexed Foreign Keys…

Oracle announced several appliances and engineered systems - Database Appliance, Exadata, Exalogic, T4 super cluster, Exalytics and Big Data Appliance. While these products provided much needed gap in many cases, there is a tremendous amount of confusion about the proper usecase of these machines. In this session attendees will learn the difference between these, the…

What does it take to make the database secure, to comply with regulations and mandates like SOX and PCI? You may be amazed to know that by taking some simple steps you can perform in a single day, you can attain 60% of the requirements and make your database a secure place, as you will…

Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in…

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…

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…

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.