“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…

“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…

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…

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…

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…

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…

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…