Home
Search results “Performance in oracle”
Oracle Database Performance Tuning for Admins and Architects
 
48:59
Product manager Randal Sagrillo asks you to be a hero as an administrator or architect in the practice of performance tuning!
Oracle SQL Performance Tuning  1
 
06:49
Oracle SQL Performance Tuning and tips Cost Based Optimizer (CBO) Rule Based Optimizer (RBO) SQL Explain Plan Oracle Explain Plan
Views: 15057 TechLake
Oracle DBA - Solve Long Running Query & TX Row Lock Contention | Performance Tuning
 
09:19
How to Solve Row Lock Contention in Oracle Database - Performance Tuning - Oracle DBA Solve Row Lock Contention & Long Running Query in Oracle Database - Performance Tuning Oracle DBA - Performance Tuning Row Lock Contention Please Like, Comment, Subscribe and Share... Boxcut Media.
Views: 7759 BoxCut Media
Oracle 11g Performance Tuning Demo Session
 
44:46
More Oracle DBA Courses: https://oraclegenesis.com/ Online trainings: https://oraclegenesis.com/video-courses/ Fly me a trainer: https://oraclegenesis.com/fly-me-a-trainer/ DBA Knowledgebase: https://oraclegenesis.com/dba-knowledgebase/ ORACLEGENESIS provides all you need to build and manage effective Oracle technology learning. We designed ORACLEGENESIS as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand.
Views: 83991 DBA Genesis
Beginning Performance Tuning with Arup Nanda (In English)
 
01:02:17
Webinar presented to LAOUC by Arup Nanda regarding Oracle Performace tuning for beginners.
Views: 98043 OracleMania
Solving Performance Problems on Oracle DB
 
28:11
Solving Performance Problems on Oracle DB Matthew Vegh - Embarcadero Thursday, June 26, 2014 - 11am DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are responsible for; it can be very difficult, frustrating, and expensive. Given the complex interactions of applications, users and databases, new performance issues can arise almost as fast as old ones can be addressed. This session will simulate common performance problems on an Oracle server and then both identify those problems and provide effective solutions. Matthew Vegh is a Software Architect at Embarcadero Technologies for the Embarcadero DB Power Studio family of products and has been with the company for the better part of a decade. He has over 15 years of development experience with a wide range of technologies and a definite preference for database tooling.
Real-World Performance - 19 - Architecture with an AWR Report
 
21:38
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Graham Wood, Architect and Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as they explain and analyze the information gathered via an AWR Report from a large internet retailer and how that affects performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle and .NET: Performance Best Practices
 
01:00:00
Watch this video to find out the best practices for getting the best performance from your Oracle and .NET applications. This is a session from the Oracle Virtual Technology Summit in July 2015. Topics ====== Overview: 2:15 ODP.NET Coding Best Practices 3:25 Oracle Performance Analyzer and SQL Tuning Advisor: 22:09 Caching 30:06 ======
Views: 6335 Oracle .NET
Oracle DB - Dynamic Performance View & Data Dictionary
 
04:08
Oracle DB - Dynamic Performance View & Data Dictionary Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Performance Tips for JSON in Oracle Database
 
38:37
JSON (JavaScript Object Notation) has become the dominant data exchange format of the 21st century. As of version 12.1, Oracle Database offers powerful, flexible features for storing and manipulating documents. In this session, Beda Hammerschmidt kicks off a multi-part series of discussions on how to optimize performance of SQL when working with JSON documents. AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
Views: 372 Oracle Developers
Oracle Performance Tuning - Monitoring using Oracle Enterprise Manager
 
12:41
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 31672 itversity
Oracle Database In-Memory Performance Demo
 
15:09
Demonstration of Oracle Database In-Memory from Oracle's Real World Performance Team.
Oracle 12c Performance Tuning - Webinar 17/08/2017
 
01:01:08
In this webinar, we will overview performance problems with nowadays database applications. It will explore various approaches to tackle these performance problems after introducing key natures of Oracle database engine. For more information visit the New Horizons website: https://goo.gl/SFn78P
Oracle 11gR2 Performance Tuning
 
20:24
Learn Oracle Performance Tuning with Real Time Activities. Watch this video to see how HARD PARSING issue can be rectified with simple resolution. This course will load the system and show you a real time approach to resolve performance issues on your environment. Get more details at : www.orskl.com/training Queries? WhatsApp: +919951696808 Get your hands dirty now and become performance tuning expert.
Views: 9974 OrSkl Academy
Oracle Performance Tuning - Read and interpret Explain Plan
 
17:43
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 41393 itversity
Real-World Performance - 1 - Cursors and Connection Intro
 
03:08
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he explains and introduces a demonstration application, that simulates the mistakes of a poor database and application configuration, and the specific parts of the system that create a sub-optimal configuration. The goal is to step beyond Moore's Law, and create orders of magnitude changes. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Hints Tutorial for improving performance
 
10:35
Oracle Hints Tutorial for improving performance APPEND PARALLEL JOIN INDEX NO_INDEX SELECT /*+ FIRST_ROWS(10) */ * FROM emp WHERE deptno = 10; SELECT /*+ ALL_ROWS */ * FROM emp WHERE deptno = 10; SELECT /*+ NO_INDEX(emp emp_dept_idx) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ INDEX(e,emp_dept_idx) */ * FROM emp e WHERE e.deptno = 10; -- SELECT /*+ INDEX(scott.emp,emp_dept_idx) */ * FROM scott.emp; SELECT /*+ AND_EQUAL(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ INDEX_JOIN(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ PARALLEL_INDEX(e,emp_dept_idx , 8) */ * FROM emp e; SELECT /*+ LEADING (dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ PARALLEL(8) CACHE (e) FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL USE_MERGE (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- SORT Merge Join SELECT /*+ PARALLEL USE_HASH (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- Hash Join SELECT /*+ PARALLEL */ * FROM emp e ; INSERT /*+ APPEND */ INTO mytmp select /*+ CACHE (e) */ *from emp e; commit;
Views: 8289 TechLake
Performance Tuning of SGA using AMM in oracle 11gR2
 
16:02
Hello friends in my today scenario i briefly explain how to manage and tune automatically SGA AND PGA via Automatic memory management feature that is release in 11gR2. #PerformanceTuning #SGA #AMM
Views: 7144 Oracle World
Troubleshooting a Complex Oracle Performance Issue
 
01:28:00
In this session Tanel will walk you through troubleshooting a yet another complex performance issue that he has faced in past. Again, the initial symptoms point to a different direction than the actual root cause, so a systematic approach was needed.
Views: 3822 Tanel Poder
Database Time-Based Performance Tuning: From Theory to Practice
 
56:54
In this 2014 OpenWorld session, Graham Wood covers how you can identify bottlenecks and maximize database performance with Oracle’s unique database time methodology. It covers a rich toolset at the disposal of DBAs—from Oracle Enterprise Manager 12c’s Automatic Workload Repository and Active Session History features to Oracle Database’s Automatic Database Diagnostics Monitor feature—and how these tools work together seamlessly. The session also provides an in-depth understanding of how the database time methodology is used in Oracle Enterprise Manager to provide a simple yet effective method to diagnose and resolve performance problems with just a couple of mouse clicks.
Oracle Hints Tutorial for improving performance with examples
 
11:16
Oracle Hints Tutorial for improving performance with examples Oracle Hints Oracle Tutorial for beginners SQL Tutorial for beginners SQL Hints SQL Performance tuning
Views: 3782 TechLake
Why is my Oracle Database Slow? The SQL Developer Performance Dashboard
 
11:00
Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!
Views: 1700 Jeff Smith
oracle sql performance analyzer
 
12:50
compares the performance of the statements in a tuning set before and after a database change.
Oracle Performance Tuning - Oracle Enterprise Manager - Reading AWR Reports
 
20:35
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 32338 itversity
Performance Tuning using Cursor_sharing in oracle 11gR2
 
29:24
Hello friends in my today video we learn about cursor_sharing in oracle which help in improving performance for SQL queries using literal values. #PerformanceTuning #Cursor_sharing Oracle database Unbeatable,Unbreakable Platform..
Views: 4151 Oracle World
Oracle Performance Tuning - Oracle Enterprise Manager - Understanding Statistics
 
11:58
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 4584 itversity
Partitioning in Oracle - Performance Basics
 
28:35
This is the 2nd video from " Partitioning in Oracle " series, It explains how oracle stores and manages data. What is single Block IO and Multi Block IO ? Why full table scan is better than index access in few cases. The video is very elaborate, I have tried my level best to keep it as simple as possible
Views: 11102 Tech Coach
Oracle Performance Tuning - Generate Explain Plan
 
18:05
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 8797 itversity
[Oracle SQL Performance Tuning: 4/4] Basic Hints and their Usage
 
30:52
This presentation explains how to use basic hints of Oracle. The series of SQL tuning videos presents performance tuning tips for developers. For presentation used in this video, please visit: https://drive.google.com/drive/folders/0B6EDqGZwjejmWng5VWM3ZEtaNzA?usp=sharing
Views: 10908 anilkumar ghorakavi
Optimizing SQL Performance
 
51:42
Held on July 12 2018 In July's session we mainly looked at performance. Highlights include: 1:30 How does the database process subqueries? 5:20 Performance: comparing insert ... select to create tmp table, insert select from tmp; DDL in PL/SQL; dynamic SQL problems 12:45 18c private temporary tables; tables specific to a session; DDL you can rollback across! 21:00 Improving update performance: things to watch for; insert vs. update; "join-update" - create a view instead; create table as select "update" 34:05 Analytic function performance: first_value non-determinism; min keep vs first_value; computing function in a subquery; indexes for analytic functions AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 544 Oracle Developers
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 6149 TechLake
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 99189 radhikaravikumar
Oracle SQL performance Analyzer
 
09:10
Oracle SQL performance Analyzer
Views: 5982 transfersolutions
BULK COLLECT and FORALL-A PL/SQL Performance Booster
 
25:07
In this Video Tutorial, I have covered 2 great feature in Oracle PL/SQL - BULK COLLECT and FORALL with some demos.
Views: 55230 Anindya Das
Oracle Performance Tuning - Oracle Enterprise Manager - AWR
 
14:59
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 4298 itversity
Database Performance Analyzer Overview for Oracle Databases
 
03:24
Learn more: http://slrwnds.com/DPAforOracle This video will give a high level overview on how to use DPA in assisting you to find performance issues in your Oracle instance. Connect with SolarWinds: THWACK: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds LinkedIn: http://www.linkedin.com/company/solarwinds
Views: 11813 solarwindsinc
Performance Management in Fusion Cloud Talent Management
 
11:51
In this Video Tutorial following are the topics covered in the Oracle HCM Cloud Talent Management- Performance Management Overview with the setups like Performance Document types, Performance Template Section, and Profile Ratings. Enroll for our complete trainings at: www.apps2fusion.com/packages Also, visit us at : http://apps2fusion.com/ Contact us at: [email protected] or +44-207-193-5456 | +1-650-318-5241 Follow Us On: Facebook: https://www.facebook.com/apps2fusion Twitter: https://twitter.com/apps2fusion LinkedIn: https://www.linkedin.com/company/apps... Youtube: https://www.youtube.com/c/apps2fusion
Views: 910 apps2fusion
Oracle Performance - SQL Baseline Exercises
 
08:52
Oracle Performance - SQL Baseline Exercises
Views: 2992 The Silent DBA
[Oracle SQL Performance Tuning: 1/4] Overview of SQL Processing
 
28:06
The series of SQL tuning videos presents performance tuning tips for developers. For presentation used in this video, please visit: https://drive.google.com/drive/folders/0B6EDqGZwjejmWng5VWM3ZEtaNzA?usp=sharing
Views: 7858 anilkumar ghorakavi
V$ Dynamic performance views
 
09:48
V$ Dynamic performance views watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Oracle Performance - Create Tuning Sets and Run SQL Tuning Advisor
 
09:50
Oracle Performance - Create Tuning Sets and Run SQL Tuning Advisor
Views: 4042 The Silent DBA
DBMS_PROFILER - A Key to Identify PL/SQL Performance Bottleneck
 
14:02
This video tutorial explains PL/SQL performance analysis with DBMS_PROFILER. This video tutorial explains DBMS_PROFILER package,Profiler tables,how to use profiler. It demonstrates Setting up DBMS_PROFILER, Profiling for a PL/SQL procedure and Analyzing the Profiler data.
Views: 28541 Anindya Das
Oracle SQL Monitoring - Performance Analysis
 
01:30:41
SQL Monitoring is the best new feature of Oracle 11g for performance analysts, developers and support teams. Finally there is a tool that provides the most accurate, useful and interesting information when a SQL statement is running for longer than expected in a clear format with no minimal advance configuration requirements: What execution plan is really being used? What row source cardinality calculations are incorrect? What steps in the plan are taking the most time and consuming most resources? In this presentation, Doug Burns will demonstrate the various ways of accessing SQL Monitoring functionality and use example reports to show how the information can be used to analyse both currently running and completed statements. It will also describe and offer solutions to some of the minor quirks you might encounter. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 5219 Redgate Videos
High Performance Bulk Data Loading
 
33:55
What is the best way to get data into an Oracle database? This session covers how to bulk load data quickly into an Oracle database. It will help developers avoid common gotchas that will limit performance, and it gives insight into how to make sure the solution will be database AND DBA-friendly! Example SQL is used to demonstrate the solution, and links to working examples will be provided.
Oracle Performance Tuning Interview Questions For Developers
 
02:06
For more Questions check http://www.dbvidya.com/oracle-performance-tuning-interview-questions-developers-dbas/ [email protected] +91 991 2323 000 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-awr/ Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-tool/ ER Data Modeling Course : http://www.dbvidya.com/course/er-modeling/ Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensional-modeling/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 663 DbVidya
Oracle Performance Tuning - Materialized View
 
04:32
How to create and refresh materialized view
Views: 3669 Saurabh Kumar
Oracle Performance Tuning - Introduction
 
11:26
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 12240 itversity
Real-World Performance - 17 - Database Log Writer
 
16:15
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he explains how the Database Log Writer affects performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.