Unix environments provides rich set of tools to debug performance issues. Even if the issue is complex to understand, if we use right tool for the job, we can identifiy the root cause of an issue quickly. In this presentation, I will demo tools such as truss/strace, pfiles, pmap, prstat, vmstat etc to show how you…

“Why isn’t my query using an index?” is one of the most common questions beginners have when tuning SQL. This talk explores the factors that influence the optimizer’s decision behind this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms across a number of bags of…

This presentation will look at which 12c tuning features should be investigated for use.  Many of the tuning features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  There will be simple examples (such as a quick example using…

Strategies to migrate Enterprise Applications such as the E-Business Suite, Hyperion and Oracle Business Intelligence to the hybrid cloud (public + private) are discussed; business requirements, constraints, Application-level Service Level Agreements (SLAs) within the confines of the multi-tenant distributed architecture analyzed. Different computing platforms, storage technologies, networking options, automated Disaster Recovery scenarios, a Return on…

In today’s diverse computing environments, data ends up in many different places, addressing many various demands. Data may need to be moved between on-premises systems and public clouds, between private and public clouds, between different hybrid clouds, or between different public clouds. The rise of big data—in its varying formats and files sizes, often required…

Oracle in the 2014 edition of its Open World rolled out new database public cloud service with its DBaaS offerings, but this is just a piece in each company's technological architecture. Businesses still have the need to create a Private cloud and discover the driver to create it; Wether it is a measured service,consolidation or rapid…

I will discuss internal details about inmemory option, processes and memory structures, v$ views, some of the practical issues that we encountered testing a multi-terabyte database with this product. I will also discuss a few internal troubleshooting events to understand how IM is populated, scaned etc. Just for a good measure, we will also take…

Learn how to properly architect and deploy your Oracle Enterprise Manager 12c implementation, including designing for high availability and scalability. This session focuses on the essential tasks an implementation team must do to ensure Oracle Enterprise Manager 12c rollouts occur in a timely fashion and deliver a solid foundation for exploiting the marquee features of Oracle Enterprise…

In today’s diverse computing environments, data ends up in many different places, addressing many various demands. Data may need to be moved between on-premises systems and public clouds, between private and public clouds, between different hybrid clouds, or between different public clouds. The rise of big data—in its varying formats and files sizes, often required…

Original Broadcast: Tuesday, May 26, 2015 Security is a concern of every IT manager and it is clear that perimeter defense, trying to keep hackers out of your network, is not enough. At some point someone with bad intentions will penetrate your network and to prevent significant damage it is necessary to make sure there…