�ݺ�ߣshows by User: MariaColgan1

�ݺ�ߣshows by User: MariaColgan1 / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: MariaColgan1 / Thu, 23 Feb 2023 22:59:24 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: MariaColgan1 Five_Things_You_Might_Not_Know_About_Oracle_Database_v2.pptx /slideshow/fivethingsyoumightnotknowaboutoracledatabasev2pptx/256070244 fivethingsyoumightnotknowaboutoracledatabasev2-230223225924-5a39777e
In this session, we looked at five things you might not know about the Oracle Database or might have forgotten. For each topic, I explained the functionality and demonstrated the benefits using real-world examples. The topics covered apply to anyone running Oracle Database 11g and up, including Standard Edition, with only a few minor exceptions.]]>
In this session, we looked at five things you might not know about the Oracle Database or might have forgotten. For each topic, I explained the functionality and demonstrated the benefits using real-world examples. The topics covered apply to anyone running Oracle Database 11g and up, including Standard Edition, with only a few minor exceptions.]]> Thu, 23 Feb 2023 22:59:24 GMT /slideshow/fivethingsyoumightnotknowaboutoracledatabasev2pptx/256070244 MariaColgan1@slideshare.net(MariaColgan1) Five_Things_You_Might_Not_Know_About_Oracle_Database_v2.pptx MariaColgan1 In this session, we looked at five things you might not know about the Oracle Database or might have forgotten. For each topic, I explained the functionality and demonstrated the benefits using real-world examples. The topics covered apply to anyone running Oracle Database 11g and up, including Standard Edition, with only a few minor exceptions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/fivethingsyoumightnotknowaboutoracledatabasev2-230223225924-5a39777e-thumbnail.jpg?width=120&height=120&fit=bounds" /> In this session, we looked at five things you might not know about the Oracle Database or might have forgotten. For each topic, I explained the functionality and demonstrated the benefits using real-world examples. The topics covered apply to anyone running Oracle Database 11g and up, including Standard Edition, with only a few minor exceptions.

Five_Things_You_Might_Not_Know_About_Oracle_Database_v2.pptx from Maria Colgan

]]> 1111 0 https://cdn.slidesharecdn.com/ss_thumbnails/fivethingsyoumightnotknowaboutoracledatabasev2-230223225924-5a39777e-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Part5 sql tune /slideshow/part5-sql-tune/228591534 part5sqltune-200219013435
The final part of the SQL Tuning workshop focuses on applying the techniques discussed in the previous sections to help diagnose and correct a number of problematic SQL statements and shows how you can use SQL Plan Management or a SQL Patch to influence an execution plan.]]>
The final part of the SQL Tuning workshop focuses on applying the techniques discussed in the previous sections to help diagnose and correct a number of problematic SQL statements and shows how you can use SQL Plan Management or a SQL Patch to influence an execution plan.]]> Wed, 19 Feb 2020 01:34:35 GMT /slideshow/part5-sql-tune/228591534 MariaColgan1@slideshare.net(MariaColgan1) Part5 sql tune MariaColgan1 The final part of the SQL Tuning workshop focuses on applying the techniques discussed in the previous sections to help diagnose and correct a number of problematic SQL statements and shows how you can use SQL Plan Management or a SQL Patch to influence an execution plan. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/part5sqltune-200219013435-thumbnail.jpg?width=120&height=120&fit=bounds" /> The final part of the SQL Tuning workshop focuses on applying the techniques discussed in the previous sections to help diagnose and correct a number of problematic SQL statements and shows how you can use SQL Plan Management or a SQL Patch to influence an execution plan.

Part5 sql tune from Maria Colgan

]]> 6673 0 https://cdn.slidesharecdn.com/ss_thumbnails/part5sqltune-200219013435-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Part4 Influencing Execution Plans with Optimizer Hints /slideshow/part4-influencing-execution-plans-with-optimizer-hints/228586422 part4optimizerhints-200218234452
Part 4 of the SQL Tuning workshop is called “Harnessing the power of optimizer hints”. Although I am not a strong supporter of adding hints to SQL statements for a whole host of reasons, from time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains how Optimizer hints are interpreted, when and where they should be used, and why they sometimes appear to be ignored.]]>
Part 4 of the SQL Tuning workshop is called “Harnessing the power of optimizer hints”. Although I am not a strong supporter of adding hints to SQL statements for a whole host of reasons, from time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains how Optimizer hints are interpreted, when and where they should be used, and why they sometimes appear to be ignored.]]> Tue, 18 Feb 2020 23:44:52 GMT /slideshow/part4-influencing-execution-plans-with-optimizer-hints/228586422 MariaColgan1@slideshare.net(MariaColgan1) Part4 Influencing Execution Plans with Optimizer Hints MariaColgan1 Part 4 of the SQL Tuning workshop is called “Harnessing the power of optimizer hints”. Although I am not a strong supporter of adding hints to SQL statements for a whole host of reasons, from time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains how Optimizer hints are interpreted, when and where they should be used, and why they sometimes appear to be ignored. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/part4optimizerhints-200218234452-thumbnail.jpg?width=120&height=120&fit=bounds" /> Part 4 of the SQL Tuning workshop is called “Harnessing the power of optimizer hints”. Although I am not a strong supporter of adding hints to SQL statements for a whole host of reasons, from time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains how Optimizer hints are interpreted, when and where they should be used, and why they sometimes appear to be ignored.

Part4 Influencing Execution Plans with Optimizer Hints from Maria Colgan

]]> 6117 0 https://cdn.slidesharecdn.com/ss_thumbnails/part4optimizerhints-200218234452-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Part3 Explain the Explain Plan /slideshow/part3-explain-the-explain-plan/228586012 part3explaintheexplainplan-200218232933
Part 3 of the SQL Tuning workshop examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.]]>
Part 3 of the SQL Tuning workshop examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.]]> Tue, 18 Feb 2020 23:29:33 GMT /slideshow/part3-explain-the-explain-plan/228586012 MariaColgan1@slideshare.net(MariaColgan1) Part3 Explain the Explain Plan MariaColgan1 Part 3 of the SQL Tuning workshop examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/part3explaintheexplainplan-200218232933-thumbnail.jpg?width=120&height=120&fit=bounds" /> Part 3 of the SQL Tuning workshop examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Part3 Explain the Explain Plan from Maria Colgan

]]> 6546 0 https://cdn.slidesharecdn.com/ss_thumbnails/part3explaintheexplainplan-200218232933-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Part2 Best Practices for Managing Optimizer Statistics /slideshow/part2-best-practices-for-managing-optimizer-statistics/228584528 part2optimizerstatistics-200218223557
Part 2 of the SQL Tuning workshop focuses on Optimizer Statistics and the best practices for managing them, including when and how to gather statistics. It also covers what additional information you may need to give the Optimizer and provides guidance on when not to gather statistics. Finally we look at all of the techniques you can use to speed up statistics gathering including taking advantage of Incremental statistics, parallelism and concurrency.]]>
Part 2 of the SQL Tuning workshop focuses on Optimizer Statistics and the best practices for managing them, including when and how to gather statistics. It also covers what additional information you may need to give the Optimizer and provides guidance on when not to gather statistics. Finally we look at all of the techniques you can use to speed up statistics gathering including taking advantage of Incremental statistics, parallelism and concurrency.]]> Tue, 18 Feb 2020 22:35:57 GMT /slideshow/part2-best-practices-for-managing-optimizer-statistics/228584528 MariaColgan1@slideshare.net(MariaColgan1) Part2 Best Practices for Managing Optimizer Statistics MariaColgan1 Part 2 of the SQL Tuning workshop focuses on Optimizer Statistics and the best practices for managing them, including when and how to gather statistics. It also covers what additional information you may need to give the Optimizer and provides guidance on when not to gather statistics. Finally we look at all of the techniques you can use to speed up statistics gathering including taking advantage of Incremental statistics, parallelism and concurrency. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/part2optimizerstatistics-200218223557-thumbnail.jpg?width=120&height=120&fit=bounds" /> Part 2 of the SQL Tuning workshop focuses on Optimizer Statistics and the best practices for managing them, including when and how to gather statistics. It also covers what additional information you may need to give the Optimizer and provides guidance on when not to gather statistics. Finally we look at all of the techniques you can use to speed up statistics gathering including taking advantage of Incremental statistics, parallelism and concurrency.

Part2 Best Practices for Managing Optimizer Statistics from Maria Colgan

]]> 6630 0 https://cdn.slidesharecdn.com/ss_thumbnails/part2optimizerstatistics-200218223557-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Part1 of SQL Tuning Workshop - Understanding the Optimizer /slideshow/part1-of-sql-tuning-workshop-understanding-the-optimizer/228577482 part1understandingtheoptimizer-200218194933
Part 1 of a 5 part SQL Tuning workshop, This presentation covers the history of the Oracle Optimizer and explains the first thing the Optimizer does when it receives a SQL statements, which is to transform the SQL statement in order to open up additional access paths. ]]>
Part 1 of a 5 part SQL Tuning workshop, This presentation covers the history of the Oracle Optimizer and explains the first thing the Optimizer does when it receives a SQL statements, which is to transform the SQL statement in order to open up additional access paths. ]]> Tue, 18 Feb 2020 19:49:33 GMT /slideshow/part1-of-sql-tuning-workshop-understanding-the-optimizer/228577482 MariaColgan1@slideshare.net(MariaColgan1) Part1 of SQL Tuning Workshop - Understanding the Optimizer MariaColgan1 Part 1 of a 5 part SQL Tuning workshop, This presentation covers the history of the Oracle Optimizer and explains the first thing the Optimizer does when it receives a SQL statements, which is to transform the SQL statement in order to open up additional access paths. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/part1understandingtheoptimizer-200218194933-thumbnail.jpg?width=120&height=120&fit=bounds" /> Part 1 of a 5 part SQL Tuning workshop, This presentation covers the history of the Oracle Optimizer and explains the first thing the Optimizer does when it receives a SQL statements, which is to transform the SQL statement in order to open up additional access paths.

Part1 of SQL Tuning Workshop - Understanding the Optimizer from Maria Colgan

]]> 15656 0 https://cdn.slidesharecdn.com/ss_thumbnails/part1understandingtheoptimizer-200218194933-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Ground Breakers Romania: Oracle Autonomous Database /MariaColgan1/ground-breakers-romania-oracle-autonomous-database oracleautononmousdatabaseunderthehoodnodemos-191022203153
This session was delivered as part of the Oracle Ground Breakers EMEA tour in Romania. What does "autonomous" really mean, and what makes the database autonomous? If you're looking for the answers to these questions, this is the session for you! In this session, we invite you to take a peek under the hood of the Oracle Autonomous Database, so you can get a clear understanding of how our unique Autonomous Database works. We’ll share our exclusive combination of database features, best practices and machine learning algorithms that make up this family of cloud services. With the use of live demos, we’ll illustrates how it can simplify your approach to data management and accelerate your transition to the cloud.]]>
This session was delivered as part of the Oracle Ground Breakers EMEA tour in Romania. What does "autonomous" really mean, and what makes the database autonomous? If you're looking for the answers to these questions, this is the session for you! In this session, we invite you to take a peek under the hood of the Oracle Autonomous Database, so you can get a clear understanding of how our unique Autonomous Database works. We’ll share our exclusive combination of database features, best practices and machine learning algorithms that make up this family of cloud services. With the use of live demos, we’ll illustrates how it can simplify your approach to data management and accelerate your transition to the cloud.]]> Tue, 22 Oct 2019 20:31:53 GMT /MariaColgan1/ground-breakers-romania-oracle-autonomous-database MariaColgan1@slideshare.net(MariaColgan1) Ground Breakers Romania: Oracle Autonomous Database MariaColgan1 This session was delivered as part of the Oracle Ground Breakers EMEA tour in Romania. What does "autonomous" really mean, and what makes the database autonomous? If you're looking for the answers to these questions, this is the session for you! In this session, we invite you to take a peek under the hood of the Oracle Autonomous Database, so you can get a clear understanding of how our unique Autonomous Database works. We’ll share our exclusive combination of database features, best practices and machine learning algorithms that make up this family of cloud services. With the use of live demos, we’ll illustrates how it can simplify your approach to data management and accelerate your transition to the cloud. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracleautononmousdatabaseunderthehoodnodemos-191022203153-thumbnail.jpg?width=120&height=120&fit=bounds" /> This session was delivered as part of the Oracle Ground Breakers EMEA tour in Romania. What does "autonomous" really mean, and what makes the database autonomous? If you're looking for the answers to these questions, this is the session for you! In this session, we invite you to take a peek under the hood of the Oracle Autonomous Database, so you can get a clear understanding of how our unique Autonomous Database works. We’ll share our exclusive combination of database features, best practices and machine learning algorithms that make up this family of cloud services. With the use of live demos, we’ll illustrates how it can simplify your approach to data management and accelerate your transition to the cloud.

Ground Breakers Romania: Oracle Autonomous Database from Maria Colgan

]]> 536 0 https://cdn.slidesharecdn.com/ss_thumbnails/oracleautononmousdatabaseunderthehoodnodemos-191022203153-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Ground Breakers Romania: Explain the explain_plan /slideshow/ground-breakers-romania-explain-the-explainplan/185459213 explaintheexplainplan-191022201638
This session was delivered as part of the EMEA Ground Breakers tour in Romania, Oct. 2019. The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.]]>
This session was delivered as part of the EMEA Ground Breakers tour in Romania, Oct. 2019. The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.]]> Tue, 22 Oct 2019 20:16:38 GMT /slideshow/ground-breakers-romania-explain-the-explainplan/185459213 MariaColgan1@slideshare.net(MariaColgan1) Ground Breakers Romania: Explain the explain_plan MariaColgan1 This session was delivered as part of the EMEA Ground Breakers tour in Romania, Oct. 2019. The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/explaintheexplainplan-191022201638-thumbnail.jpg?width=120&height=120&fit=bounds" /> This session was delivered as part of the EMEA Ground Breakers tour in Romania, Oct. 2019. The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Ground Breakers Romania: Explain the explain_plan from Maria Colgan

]]> 252 0 https://cdn.slidesharecdn.com/ss_thumbnails/explaintheexplainplan-191022201638-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 What to Expect From Oracle database 19c /slideshow/what-to-expect-from-oracle-database-19c/154360330 oracledatabase19ccvcdeck-190708172816
The Oracle Database has recently switched to an annual release model. Oracle Database 19c is only the second release in this new model. So what can you expect from the latest version of the Oracle Database? This presentation explains how Oracle Database 19c is really 12.2.0.3 the terminal release of the 12.2 family and the new features you can find in this release.]]>
The Oracle Database has recently switched to an annual release model. Oracle Database 19c is only the second release in this new model. So what can you expect from the latest version of the Oracle Database? This presentation explains how Oracle Database 19c is really 12.2.0.3 the terminal release of the 12.2 family and the new features you can find in this release.]]> Mon, 08 Jul 2019 17:28:16 GMT /slideshow/what-to-expect-from-oracle-database-19c/154360330 MariaColgan1@slideshare.net(MariaColgan1) What to Expect From Oracle database 19c MariaColgan1 The Oracle Database has recently switched to an annual release model. Oracle Database 19c is only the second release in this new model. So what can you expect from the latest version of the Oracle Database? This presentation explains how Oracle Database 19c is really 12.2.0.3 the terminal release of the 12.2 family and the new features you can find in this release. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracledatabase19ccvcdeck-190708172816-thumbnail.jpg?width=120&height=120&fit=bounds" /> The Oracle Database has recently switched to an annual release model. Oracle Database 19c is only the second release in this new model. So what can you expect from the latest version of the Oracle Database? This presentation explains how Oracle Database 19c is really 12.2.0.3 the terminal release of the 12.2 family and the new features you can find in this release.

What to Expect From Oracle database 19c from Maria Colgan

]]> 13057 7 https://cdn.slidesharecdn.com/ss_thumbnails/oracledatabase19ccvcdeck-190708172816-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Explain the explain_plan /slideshow/explain-the-explainplan/151127925 explaintheexplainplan-190621164219
This presentation explains to read and interpret execution plans for Oracle SQL Statements. Each aspect of the plan is reviewed and explained.]]>
This presentation explains to read and interpret execution plans for Oracle SQL Statements. Each aspect of the plan is reviewed and explained.]]> Fri, 21 Jun 2019 16:42:18 GMT /slideshow/explain-the-explainplan/151127925 MariaColgan1@slideshare.net(MariaColgan1) Explain the explain_plan MariaColgan1 This presentation explains to read and interpret execution plans for Oracle SQL Statements. Each aspect of the plan is reviewed and explained. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/explaintheexplainplan-190621164219-thumbnail.jpg?width=120&height=120&fit=bounds" /> This presentation explains to read and interpret execution plans for Oracle SQL Statements. Each aspect of the plan is reviewed and explained.

Explain the explain_plan from Maria Colgan

]]> 1915 6 https://cdn.slidesharecdn.com/ss_thumbnails/explaintheexplainplan-190621164219-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Beginners guide to_optimizer /slideshow/beginners-guide-tooptimizer/151126772 beginnersguidetooptimizer-190621163646
The presentation helps to introduce the key aspects of the Oracle Optimizer and how you find out what it's up to and how you can influence its decisions.]]>
The presentation helps to introduce the key aspects of the Oracle Optimizer and how you find out what it's up to and how you can influence its decisions.]]> Fri, 21 Jun 2019 16:36:46 GMT /slideshow/beginners-guide-tooptimizer/151126772 MariaColgan1@slideshare.net(MariaColgan1) Beginners guide to_optimizer MariaColgan1 The presentation helps to introduce the key aspects of the Oracle Optimizer and how you find out what it's up to and how you can influence its decisions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/beginnersguidetooptimizer-190621163646-thumbnail.jpg?width=120&height=120&fit=bounds" /> The presentation helps to introduce the key aspects of the Oracle Optimizer and how you find out what it's up to and how you can influence its decisions.

Beginners guide to_optimizer from Maria Colgan

]]> 477 2 https://cdn.slidesharecdn.com/ss_thumbnails/beginnersguidetooptimizer-190621163646-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 The Changing Role of a DBA in an Autonomous World /slideshow/the-changing-role-of-a-dba-in-an-autonomous-world/143297371 thechangingroleofdba-190502231313
The advent of the cloud and the introduction of Oracle Autonomous Database Cloud presents opportunities for every organization, but what's the future role for the DBA? This presentation explores how the role of the DBA will continue to evolve, and provides advice on key skills required to be a successful DBA in the world of the cloud.]]>
The advent of the cloud and the introduction of Oracle Autonomous Database Cloud presents opportunities for every organization, but what's the future role for the DBA? This presentation explores how the role of the DBA will continue to evolve, and provides advice on key skills required to be a successful DBA in the world of the cloud.]]> Thu, 02 May 2019 23:13:13 GMT /slideshow/the-changing-role-of-a-dba-in-an-autonomous-world/143297371 MariaColgan1@slideshare.net(MariaColgan1) The Changing Role of a DBA in an Autonomous World MariaColgan1 The advent of the cloud and the introduction of Oracle Autonomous Database Cloud presents opportunities for every organization, but what's the future role for the DBA? This presentation explores how the role of the DBA will continue to evolve, and provides advice on key skills required to be a successful DBA in the world of the cloud. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/thechangingroleofdba-190502231313-thumbnail.jpg?width=120&height=120&fit=bounds" /> The advent of the cloud and the introduction of Oracle Autonomous Database Cloud presents opportunities for every organization, but what's the future role for the DBA? This presentation explores how the role of the DBA will continue to evolve, and provides advice on key skills required to be a successful DBA in the world of the cloud.

The Changing Role of a DBA in an Autonomous World from Maria Colgan

]]> 419 2 https://cdn.slidesharecdn.com/ss_thumbnails/thechangingroleofdba-190502231313-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Oracle Database in-Memory Overivew /slideshow/oracle-database-inmemory-overivew/143296553 databasein-memoryoverivew-190502230448
This presentation provides a clear overview of how Oracle Database In-Memory optimizes both analytics and mixed workloads, delivering outstanding performance while supporting real-time analytics, business intelligence, and reporting. It provides details on what you can expect from Database In-Memory in both Oracle Database 12.1.0.2 and 12.2.]]>
This presentation provides a clear overview of how Oracle Database In-Memory optimizes both analytics and mixed workloads, delivering outstanding performance while supporting real-time analytics, business intelligence, and reporting. It provides details on what you can expect from Database In-Memory in both Oracle Database 12.1.0.2 and 12.2.]]> Thu, 02 May 2019 23:04:48 GMT /slideshow/oracle-database-inmemory-overivew/143296553 MariaColgan1@slideshare.net(MariaColgan1) Oracle Database in-Memory Overivew MariaColgan1 This presentation provides a clear overview of how Oracle Database In-Memory optimizes both analytics and mixed workloads, delivering outstanding performance while supporting real-time analytics, business intelligence, and reporting. It provides details on what you can expect from Database In-Memory in both Oracle Database 12.1.0.2 and 12.2. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/databasein-memoryoverivew-190502230448-thumbnail.jpg?width=120&height=120&fit=bounds" /> This presentation provides a clear overview of how Oracle Database In-Memory optimizes both analytics and mixed workloads, delivering outstanding performance while supporting real-time analytics, business intelligence, and reporting. It provides details on what you can expect from Database In-Memory in both Oracle Database 12.1.0.2 and 12.2.

Oracle Database in-Memory Overivew from Maria Colgan

]]> 431 2 https://cdn.slidesharecdn.com/ss_thumbnails/databasein-memoryoverivew-190502230448-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Useful PL/SQL Supplied Packages /MariaColgan1/useful-plsql-supplied-packages usefulplsqlpackages-180611213111
This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria shares details on 4 useful supplied PL/SQL package with the Oracle Database]]>
This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria shares details on 4 useful supplied PL/SQL package with the Oracle Database]]> Mon, 11 Jun 2018 21:31:11 GMT /MariaColgan1/useful-plsql-supplied-packages MariaColgan1@slideshare.net(MariaColgan1) Useful PL/SQL Supplied Packages MariaColgan1 This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria shares details on 4 useful supplied PL/SQL package with the Oracle Database <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/usefulplsqlpackages-180611213111-thumbnail.jpg?width=120&height=120&fit=bounds" /> This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria shares details on 4 useful supplied PL/SQL package with the Oracle Database

Useful PL/SQL Supplied Packages from Maria Colgan

]]> 9295 4 https://cdn.slidesharecdn.com/ss_thumbnails/usefulplsqlpackages-180611213111-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 JSON and the Oracle Database /slideshow/json-and-the-oracle-database/101951501 json-180611194317
This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria coveres topics like what data type you should use to store JSON documents (varchar2, clob or blob) the pro's and con's of using an IS JSON check constraint, and how to load, index, and query JSON documents.]]>
This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria coveres topics like what data type you should use to store JSON documents (varchar2, clob or blob) the pro's and con's of using an IS JSON check constraint, and how to load, index, and query JSON documents.]]> Mon, 11 Jun 2018 19:43:17 GMT /slideshow/json-and-the-oracle-database/101951501 MariaColgan1@slideshare.net(MariaColgan1) JSON and the Oracle Database MariaColgan1 This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria coveres topics like what data type you should use to store JSON documents (varchar2, clob or blob) the pro's and con's of using an IS JSON check constraint, and how to load, index, and query JSON documents. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/json-180611194317-thumbnail.jpg?width=120&height=120&fit=bounds" /> This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria coveres topics like what data type you should use to store JSON documents (varchar2, clob or blob) the pro's and con's of using an IS JSON check constraint, and how to load, index, and query JSON documents.

JSON and the Oracle Database from Maria Colgan

]]> 11641 7 https://cdn.slidesharecdn.com/ss_thumbnails/json-180611194317-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Five Tips to Get the Most Out of Your Indexing /slideshow/five-tips-to-get-the-most-out-of-your-indexing/101949847 indexing-180611192745
This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria provides 5 useful tips for getting the most out of indexes in the Oracle Database]]>
This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria provides 5 useful tips for getting the most out of indexes in the Oracle Database]]> Mon, 11 Jun 2018 19:27:45 GMT /slideshow/five-tips-to-get-the-most-out-of-your-indexing/101949847 MariaColgan1@slideshare.net(MariaColgan1) Five Tips to Get the Most Out of Your Indexing MariaColgan1 This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria provides 5 useful tips for getting the most out of indexes in the Oracle Database <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/indexing-180611192745-thumbnail.jpg?width=120&height=120&fit=bounds" /> This is one of the 15 minute "TED" style talk presented as part of the Database Symposium at the ODTUG Kscope18 conference. In this presentation @SQLMaria provides 5 useful tips for getting the most out of indexes in the Oracle Database

Five Tips to Get the Most Out of Your Indexing from Maria Colgan

]]> 8690 4 https://cdn.slidesharecdn.com/ss_thumbnails/indexing-180611192745-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Harnessing the Power of Optimizer Hints /slideshow/harnessing-the-power-of-optimizer-hints/79945587 mcolganharnessingthepowerofoptimizerhintsv2-170919170601
The goal of the Oracle Optimizer is to examine all possible execution plans for a SQL statement and to pick the one with the lowest cost, which should be the most efficient. From time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. ]]>
The goal of the Oracle Optimizer is to examine all possible execution plans for a SQL statement and to pick the one with the lowest cost, which should be the most efficient. From time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. ]]> Tue, 19 Sep 2017 17:06:01 GMT /slideshow/harnessing-the-power-of-optimizer-hints/79945587 MariaColgan1@slideshare.net(MariaColgan1) Harnessing the Power of Optimizer Hints MariaColgan1 The goal of the Oracle Optimizer is to examine all possible execution plans for a SQL statement and to pick the one with the lowest cost, which should be the most efficient. From time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mcolganharnessingthepowerofoptimizerhintsv2-170919170601-thumbnail.jpg?width=120&height=120&fit=bounds" /> The goal of the Oracle Optimizer is to examine all possible execution plans for a SQL statement and to pick the one with the lowest cost, which should be the most efficient. From time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored.

Harnessing the Power of Optimizer Hints from Maria Colgan

]]> 10560 14 https://cdn.slidesharecdn.com/ss_thumbnails/mcolganharnessingthepowerofoptimizerhintsv2-170919170601-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Oracle optimizer bootcamp /slideshow/oracle-optimizer-bootcamp/78066401 oracleoptimizerbootcamp-170720014426
10 Optimizer tips you can't do without! This session cover 10 common problems folks encounter when tuning queries on an Oracle Database ]]>
10 Optimizer tips you can't do without! This session cover 10 common problems folks encounter when tuning queries on an Oracle Database ]]> Thu, 20 Jul 2017 01:44:26 GMT /slideshow/oracle-optimizer-bootcamp/78066401 MariaColgan1@slideshare.net(MariaColgan1) Oracle optimizer bootcamp MariaColgan1 10 Optimizer tips you can't do without! This session cover 10 common problems folks encounter when tuning queries on an Oracle Database <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracleoptimizerbootcamp-170720014426-thumbnail.jpg?width=120&height=120&fit=bounds" /> 10 Optimizer tips you can't do without! This session cover 10 common problems folks encounter when tuning queries on an Oracle Database

Oracle optimizer bootcamp from Maria Colgan

]]> 602 2 https://cdn.slidesharecdn.com/ss_thumbnails/oracleoptimizerbootcamp-170720014426-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 What_to_expect_from_oracle_database_12c /slideshow/whattoexpectfromoracledatabase12c/77625466 whattoexpectfromoracledatabase12c-170707230350
Databases are fundamentally changing due to new technologies and new requirements. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and Oracle’s Engineered systems. We will describe which industry transformation inspired each enhancement and explain when and how you can embrace each enhancement while preserving your existing performance.]]>
Databases are fundamentally changing due to new technologies and new requirements. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and Oracle’s Engineered systems. We will describe which industry transformation inspired each enhancement and explain when and how you can embrace each enhancement while preserving your existing performance.]]> Fri, 07 Jul 2017 23:03:50 GMT /slideshow/whattoexpectfromoracledatabase12c/77625466 MariaColgan1@slideshare.net(MariaColgan1) What_to_expect_from_oracle_database_12c MariaColgan1 Databases are fundamentally changing due to new technologies and new requirements. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and Oracle’s Engineered systems. We will describe which industry transformation inspired each enhancement and explain when and how you can embrace each enhancement while preserving your existing performance. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/whattoexpectfromoracledatabase12c-170707230350-thumbnail.jpg?width=120&height=120&fit=bounds" /> Databases are fundamentally changing due to new technologies and new requirements. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and Oracle’s Engineered systems. We will describe which industry transformation inspired each enhancement and explain when and how you can embrace each enhancement while preserving your existing performance.

What_to_expect_from_oracle_database_12c from Maria Colgan

]]> 8712 7 https://cdn.slidesharecdn.com/ss_thumbnails/whattoexpectfromoracledatabase12c-170707230350-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Oracle database 12c_and_DevOps /slideshow/oracle-database-12canddevops/77620193 oracledatabase12canddevopsclean-170707185826
For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald Venzl takes on the role of lead developer on a project to deploy a RESTful web-based application for a new coffeeshop chain, while Maria Colgan takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trends without exposing the business to painful availability or security vulnerabilities. ]]>
For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald Venzl takes on the role of lead developer on a project to deploy a RESTful web-based application for a new coffeeshop chain, while Maria Colgan takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trends without exposing the business to painful availability or security vulnerabilities. ]]> Fri, 07 Jul 2017 18:58:26 GMT /slideshow/oracle-database-12canddevops/77620193 MariaColgan1@slideshare.net(MariaColgan1) Oracle database 12c_and_DevOps MariaColgan1 For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald Venzl takes on the role of lead developer on a project to deploy a RESTful web-based application for a new coffeeshop chain, while Maria Colgan takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trends without exposing the business to painful availability or security vulnerabilities. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracledatabase12canddevopsclean-170707185826-thumbnail.jpg?width=120&height=120&fit=bounds" /> For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald Venzl takes on the role of lead developer on a project to deploy a RESTful web-based application for a new coffeeshop chain, while Maria Colgan takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trends without exposing the business to painful availability or security vulnerabilities.

Oracle database 12c_and_DevOps from Maria Colgan

]]> 9577 8 https://cdn.slidesharecdn.com/ss_thumbnails/oracledatabase12canddevopsclean-170707185826-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://public.slidesharecdn.com/v2/images/profile-picture.png https://cdn.slidesharecdn.com/ss_thumbnails/fivethingsyoumightnotknowaboutoracledatabasev2-230223225924-5a39777e-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/fivethingsyoumightnotknowaboutoracledatabasev2pptx/256070244 Five_Things_You_Might_... https://cdn.slidesharecdn.com/ss_thumbnails/part5sqltune-200219013435-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/part5-sql-tune/228591534 Part5 sql tune https://cdn.slidesharecdn.com/ss_thumbnails/part4optimizerhints-200218234452-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/part4-influencing-execution-plans-with-optimizer-hints/228586422 Part4 Influencing Exec...