SQL*Net. Parser. Planner. Executor. Have you ever wondered how the Oracle Database consumes your SQL, parses/plans/executes your query, and gives you a result set?  In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end.  Through this process you…

SQL*Net. Parser. Planner. Executor. Have you ever wondered how the Oracle Database consumes your SQL, parses/plans/executes your query, and gives you a result set?  In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end.  Through this process you…

SQL*Net. Parser. Planner. Executor. Have you ever wondered how the Oracle Database consumes your SQL, parses/plans/executes your query, and gives you a result set?  In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end.  Through this process you…

SQL*Net. Parser. Planner. Executor. Have you ever wondered how the Oracle Database consumes your SQL, parses/plans/executes your query, and gives you a result set?  In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end.  Through this process you…

SQL*Net. Parser. Planner. Executor. Have you ever wondered how the Oracle Database consumes your SQL, parses/plans/executes your query, and gives you a result set?  In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end.  Through this process 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…

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

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