Home
Search results “Oracle performance and tuning”
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!
20 Essential Oracle SQL and PL/SQL Tuning Tips
 
01:11:53
SQL and PL/SQL are powerful languages used to access an Oracle database. Today's databases contain mountains of data which presents itself as a challenge when trying to get to the data we want to in a timely fashion. In this FREE Webinar, OCP DBA John Mullins will present 20 valuable tips to help your SQL or PL/SQL perform better. The tips cover every angle regarding SQL and PL/SQL performance, making the presentation suitable for all job roles. Demonstrations will be used to support many of the tips and Oracle 11g and 12c will be covered.
Views: 40599 Themis Education
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: 15474 TechLake
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: 84316 DBA Genesis
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: 41865 itversity
What exactly is PLAN TABLE in Oracle Database #Performance #Tuning
 
16:00
Running an EXPLAIN PLAN to generate EXECUTION PLAN in oracle database is possible with PLAN_TABLE. But this video will give you much more insights of what is this PLAN_TABLE. Learn how is PLAN_TABLE called as global temporary table. Need Oracle database training? WhatsApp to +919951696808 visit www.orskl.com/training
Views: 3150 OrSkl Academy
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: 3914 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: 7953 BoxCut Media
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: 12289 itversity
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: 8573 TechLake
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: 98238 OracleMania
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: 31978 itversity
Oracle SQL Tutorial : Using execution plan to optimize query in oracle
 
12:54
Oracle SQL Tutorial Oracle tutorial: Explain plan for query optimization in Oracle PLSQL oracle tutorial for beginners using execution plan to optimize query sql query analyzer sql query cost analysis https://techquerypond.wordpress.com This oracle tutorial show you how to use EXPLAIN PLAN in oracle. This video covers how to check cost of the query from DBMS_XPLAN.DISPLAY . You can find the cost of the query using the Using EXPLAIN PLAN FOR and based on the result you can optimize the query for faster performance. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://twitter.com/techquerypond
Views: 13270 Tech Query Pond
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
Query Analysis and Optimizing in Oracle
 
37:53
Database Management Systems 11. Query Analysis and Optimizing in Oracle ADUni
Views: 84624 Chao Xu
[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: 10984 anilkumar ghorakavi
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: 8832 itversity
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: 10004 OrSkl Academy
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 6345 TechLake
oracle performance tuning  interview realtime - usa
 
11:42
for remaining interview you can contact at WhatsApp No. +1.732.524.8134 or [email protected]
Views: 67 cino mann
Oracle 11g Hints Overview
 
42:56
In this Video tutorial we will discuss about Optimizer hints in Oracle. What is optimizer hint, when & why its needed. Different Category of hints. Description of mostly used hints. Demonstrate how query plan can change with the influence of hint.
Views: 53254 Anindya Das
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: 4614 itversity
Oracle Database Tuning Introduction - Session 1
 
35:46
This is the first lecture of the Oracle Database Troubleshooting and Tuning Class. The Full course is available on Udemy at https://www.udemy.com/oracle-database-troubleshooting-and-tuning You can use Coupon Code YOUTUBETT for discount Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2518 Ramkumar Swaminathan
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: 678 DbVidya
[Oracle EBS Performance Tuning: 2/4 ] Gathering Performance Diagnostics for Oracle EBS
 
36:12
Multiple ways of collecting diagnostics for troubleshooting performance issues. The series of SQL tuning videos presents performance tuning tips for developers. For the presentation used in this video, please visit: https://drive.google.com/drive/folders/0B6EDqGZwjejmWng5VWM3ZEtaNzA?usp=sharing
Views: 4886 anilkumar ghorakavi
Oracle Performance Tuning - Materialized View
 
04:32
How to create and refresh materialized view
Views: 3685 Saurabh Kumar
Oracle SQL Performance Tuning for Developers: Understand Explain Plans
 
01:42
Understanding Explain Plans is an excerpt from Oracle SQL Performance Tuning for Developers: http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027 6+ Hours of Video Instruction The focus of Oracle SQL Performance Tuning for Developers LiveLessons is to illustrate coding techniques that ensure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements. Description In this video training, Dan Hotka starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course then goes in-depth on understanding and controlling the Explain Plan, which is how and in what order Oracle retrieves data. The discussion includes considerable detail, with SQL examples, on how the optimizers--both rule-based and cost-based, but mostly cost-based--make their decisions. Students will work with a variety of SQL statements, reviewing Explain Plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the Explain Plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This LiveLessons course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used. This course includes Oracle10g, Oracle11g, and Oracle12c SQL tuning topics. Skill Level Intermediate Learn How To Read and understand Explain Plan content Review an Explain Plan and tell quickly if this is a good plan Understand a good index column candidate from a not-so-good candidate Quickly tell the likelihood if your SQL will use an existing index Use coding and a variety of Hints (directives) that can produce better performing SQL Execute and interpret SQL trace output Who Should Take This Course Oracle programmers Oracle database administrators who need additional training on SQL tuning Course Requirements Working knowledge of the SQL query language http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027
Views: 3436 LiveLessons
Oracle-performance-tuning-1.avi
 
08:53
How to show the execution plan for your Oracle SQL statements to help with your performance tuning activities. For more Oracle tutorials go to http://www.asktheoracle.net
Views: 39658 asktheoracle1
[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: 7932 anilkumar ghorakavi
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: 7201 Oracle World
Performance Tuning with ASH and AWR Data
 
01:03:05
Presented by Kellyn Pot'Vin 30 August 2012 Summary: Since their introduction with Oracle 10g, AWR and ASH data has offered the Database professional enhanced performance reporting capabilities that previously were only gleamed via statspack and reporting queries. In this webinar, Kellyn Pot'Vin, Senior Technical Consultant at Enkitec, will take you through the requirements, reporting basics and differences of AWR and ASH. You will learn: - Reasons to use both reports. - A firm understanding of each report and its format. - Knowledge of the differing versions of the AWR report and when best utilized. - The power of ASH Reporting in real-time trouble-shooting. - Ability to utilize the reports at the command line and from Enterprise Manager. A live Q&A session with Kellyn Pot'Vin follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 113029 Redgate Videos
How to tune SQL code
 
20:28
Efficient techniques to tune SQL code.
Views: 33433 amit wadbude
Oracle Database Performance Tuning - Optimizer Statistics Gathering
 
04:51
In this video we explain how to gather the database optimizer statistics #performancetuning, #oracledatabase, #oracle, #database, #optimizerstatistics, #learning, About Optimizer Statistics Collection In Oracle Database, optimizer statistics collection is the gathering of optimizer statistics for database objects, including fixed objects. The database can collect optimizer statistics automatically. You can also collect them manually using the DBMS_STATS package. Purpose of Optimizer Statistics Collection The contents of tables and associated indexes change frequently, which can lead the optimizer to choose suboptimal execution plan for queries. To avoid potential performance issues, statistics must be kept current. To minimize DBA involvement, Oracle Database automatically gathers optimizer statistics at various times. Some automatic options are configurable, such enabling AutoTask to run DBMS_STATS. Stats collection Stats gathering database performance tuning, 10g, 11g 12c database administration
Views: 398 KINGS TUBE
Oracle SQL Tuning Expert Series - Understanding Indexes
 
01:32:30
Ross Leishman of DWS Ltd presents the principles of Understanding Indexes for SQL Tuning. The presentation includes an entertaining demonstration of Indexes featuring DWS Alumnus Jordan Thomas as a "Buffer Cache". DWS Ltd is a leading publicly listed Australian IT Services company, providing services to blue chip organisations since 1991. With a business philosophy based upon integrity, reliability and professional service delivery, DWS provides end to end IT solutions. www.dws.com.au
Views: 45506 DWS Ltd
Oracle Performance Tuning using Bulk Collect.
 
08:42
This video will give you understanding of Bulk Collect and Bulk Binding for Performance Tuning,
Views: 16049 amit wadbude
Lecture 5   Oracle Database Performance Tuning 1 - Guy Harrison
 
39:46
China Sun Yat-sen University and Dell co-established course IT System Management Introduction Lecture 5 Oracle Database Performance Tuning - Guy Harrison The Oracle database is highly tuneable with many options for optimizing performance. However, the sheer quantity of tuning options can be overwhelming, and you can waste precious time unless you know which tuning activities are most likely to provide a return on your time investment. In this lecture we'll review some of the fundamental Oracle performance tuning practices and see how to use these in a ystematic way to improve Oracle performance. Topics will include workload and SQL optimization, identification and elimination of key contention points, configuring memory to avoid physical IO, and disk IO optimization. We will also see how to use commercial tools to assist in Oracle database tuning. This lecture will be based on materials from the lecturer's book on Oracle performance: http://product.china-pub.com/60833).
Views: 30425 Quest University
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.
Performance Tuning in Real Application Cluster by Arup Nanda (English)
 
01:13:54
This is a webinar done by Arup Nanda for LAOUC and NZOUG back in 2010.
Views: 9832 OracleMania
Oracle SQL Developer's Tuning Features
 
50:59
An overview of all the performance tuning and diagnostic features in Oracle SQL Developer including: Explain Plan, Autotrace, SQL Tuning Advsior, Real Time SQL Monitoring, ASH, Monitoring Sessions, and our new Instance Viewer.
Oracle Performance Tuning - Loading Data - 04 Direct Path Load
 
16:28
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: 1986 itversity
Oracle SQL Tuning - How to Read Execution Plans (Explain Plan)
 
13:39
In this free tutorial you will learn how to generate and read (interpret) an execution plan in Oracle Databases. See more FREE Oracle Tuning tutorials at http://skillbuilders.com/free-oracle-tutorials. Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key. Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR. In the tutorial, John will teach you: - How to read an execution plan - Find the 1st step in the plan - Decipher the order of the steps in the plan - That EXPLAIN PLAN can be very misleading Prerequisites: To get the most from this tutorial, you should: 1 Know how to code SQL 2 Be familiar with SQL*Plus 3 Know - in very general terms - what an execution plan is. 4 Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements) 5 Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan. Hopefully the correct - most efficient - plan).
Views: 66351 SkillBuilders
Oracle weblogic performance tuning
 
03:19
This is a short tutorial on how to improve the performance of Oracle Weblogic server. This will make the console and Enterprise manager portal rendering faster.
Views: 24285 Ashok Singh
Oracle Performance Tuning Interview Questions   DBAs
 
01:39
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: 255 DbVidya
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: 4320 itversity
Performance Tuning Tools
 
30:36
Performance Tuning Tools watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
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.
UHCL Database Performance Tuning in Oracle and SQL
 
06:59
This video explains database performance tuning in Oracle. It was produced by computer science students at the University of Houston - Clear Lake for the graduate Database Management System course.
Views: 15900 GaryBoetticher
Oracle Performance Tuning - Preparing database - Upload data using SQL Develooper
 
12:30
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: 5769 itversity
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: 1761 Jeff Smith
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: 11395 Tech Coach