Home
Search results “Database oracle 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!
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: 77511 DBA Genesis
What is database tuning?
 
03:11
http://zerotoprotraining.com What is database tuning?
Views: 3614 HandsonERP
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: 25314 itversity
Database Performace Tuning Tips Presentation Video Oracle DB
 
04:26
For a quick reference on oracle visit http://PocketORACLE.blogspot.com
Views: 9793 TheEzguide
Ronald Vargas Quesada - Oracle Database Performance Tuning con SQL
 
42:52
En esta presentación Ronald de Costa Rica nos muestra cómo mejorar la performance de la base de datos a partir de un correcta escritura de las sentencias SQL.
Views: 5243 OracleAmericaLatina
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: 33249 Themis Education
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: 59836 SkillBuilders
Oracle Database SQL Tuning with Constraints - Lesson 1 of 5
 
00:54
Learn how to tune SQL - especially in Data Warehouse environments - with Constraints. Constraints provide critical information to the Cost Based Optimizer in the Oracle Database. Don't drop your constraints for query performance! In these 5 lessons, Oracle Certified Master DBA John Watson will demonstrate how constraints - unique, foreign key, not null - improve the execution plan and thus performance of SQL in an Oracle database. View all 5 lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.
Views: 877 SkillBuilders
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.
Views: 5892 Oracle World
Install Oracle 12C Database on AWS EC2
 
49:15
!!PLEASE SWITCH PLAYBACK to 1080P!! - https://support.google.com/youtube/answer/91449?hl=en Video on how to install Oracle 12c database on AWS EC2 instance Companion Blog Post - http://wp.me/p72gDZ-2B Installing APEX on EC2 - https://youtu.be/zw1Ql1pdTPw
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: 2854 OrSkl Academy
13. SQL Server for Oracle DBA's - Performace Tuning
 
57:44
SQL Server for Oracle Database Administrators - Performace Tuning http://dbacatalog.blogspot.com
Views: 158 dbacatalog
Oracle SQL Tuning
 
02:25
Oracle SQL Tuning
Views: 185 ruessdba1766
Where To Find Oracle Database Tuning Guides
 
00:50
http://www.perftuning.com/ - To find Oracle database tuning guides, the internet is where you need to look. There are several websites that discuss performance tuning in Oracle and you would not spend more than a few minutes to find an updated Oracle performance tuning ppt. So if you are interested to learn about Oracle performance tuning, go online.
Views: 47 clark peavler
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 Database Hints Tuning Tips Presentation Video Oracle DB
 
05:28
For a quick reference on oracle visit http://PocketORACLE.blogspot.com
Views: 4976 TheEzguide
SQL Tuning with Oracle Database 12c Histograms
 
09:20
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3149 SkillBuilders
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: 29872 Quest University
Oracle SQL Tuning - Equal SQL is not Always Equal
 
09:49
Learn how and why equivalent SQL statements can have a dramatic effect on performance. Certified Master J Watson demonstrates...See all our free Oracle Database tutorials at http://skillbuilders.com/free-oracle-tutorials. The Oracle Database cost-based optimizer (CBO) should recognize equivalent SQL statements and re-write them into the most efficient form. Well, nothing is perfect - not even Oracle Database. Sometimes the way you write your SQL can have a dramatic effect on performance. Presented by John Watson, Oracle Certified Master DBA. Some experience with SQL tuning is expected.
Views: 1775 SkillBuilders
Oracle database tuning
 
03:09
Finding culprit session
Views: 55 azmad pasha
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: 5098 itversity
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: 49459 Anindya Das
Lecture 5   Oracle Database Performance Tuning 2 - Guy Harrison
 
38:42
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 systematic 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: 13033 Quest University
Oracle - Database Links
 
11:35
Oracle - Database Links
Views: 21402 Chris Ostrowski
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: 15834 GaryBoetticher
oracle sga memory tuning oracle database buffer  cache
 
05:34
oracle system global area description brief description of components of oracle sga memory oracle system global area oracle database buffer cache oracle shared area memory
The Oracle Tuning Service of Your Dreams
 
00:41
http://themagnumgroup.net/oracle-tuning.htm Have you gasped in disbelief when a local Oracle tuning service quoted $400 per hour for tuning your database? Imagine how delighted you will feel when you discover our Oracle tuning experts charge you less than half of that for remote repair of the same application! Our Oracle tuning experts have thousands of hours' experience tuning very large Oracle databases and have profound technical knowledge of the nuances of an Oracle system. For instance, they use a combination of ratio analysis, wait analysis and workload analysis when they tune a malfunctioning database. Don't agonize over high Oracle tuning costs: get in touch with us using the form at http://themagnumgroup.net/oracle-tuning.htm for a free consultation on the approach we would use to solve your particular Oracle database problem.
Views: 451 TMGvblog
Oracle 12c: Database Administration II Part 2: Lab Demo Solution: Create an SQL Tuning Profile
 
05:43
http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free! In this video you will learn how to Perform Flashback Database Recovery, Configure Flashback Data Archives, Tune Backup and Recovery Operations, Use Oracle’s SQL Tuning Advisor, Use Oracle’s SQL Access Advisor and Implement Oracle’s Advanced Memory Management. Create Metrics Thresholds and Alerts Create AWR Reports Create AWR Single and Repeating Baselines Implement SQL Plan Management Tune Oracle’s Shared Pool Tune Oracle’s Buffer Cache Use Oracle’s Automatic Segment Space Management http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free!
Views: 1492 GogoTraining
Oracle Database 12c: Adaptive Execution Plans with Tom Kyte
 
05:42
Tom Kyte introduces adaptive execution plans followed by a demo. "Adaptive Plans" in SQL Tuning Guide" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL221 "Controlling Adaptive Optimization" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL257 "Generating and Displaying SQL Execution Plans" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL271 "Keeping Your Database Secure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG009
Views: 12625 OracleDBVision
Oracle Database SQL Tuning with Direct and Indirect Reads
 
08:12
Oracle Database SQL Tuning tutorial. Learn what direct and indirect reads are and what impact they have on tuning SQL in Oracle Database. In this free tutorial from www.SkillBuilders.com, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help. Perhaps most importantly, John will tell you what you can do about it. Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.
Views: 1568 SkillBuilders
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: 88103 radhikaravikumar
Pl/sql Best Practices,Performance Tuning,Database best Practices
 
11:19
This video will show best practices for Pl/sql and SQL.It shows performance tuning guidelines for Pl/sql and database.
Views: 288 Ashwani pandey
Fabio Prado - Oracle ACE en Database & Performance Tuning
 
05:32
Su camino para ser Oracle ACE y la especialidad en Performace Tuning y Entrenamientos
Views: 318 OracleAmericaLatina
Exploring Oracle 12c's Automatic Database Optimization (ADO) Features:
 
45:36
Oracle Database Release 12cR1's new Automatic Database Optimization (ADO) features now make it possible to automatically locate data within the most appropriate storage tier and at the appropriate compression level based on its usage patterns. Join Oracle Ace Director Jim Czuprynski as he discusses how to take advantage of these features to save crucial Tier 0 and Tier 1 storage space ... and perhaps even improve query and DML performance.
Views: 5145 Database Community
Oracle Database 11g New Features: Performance Tuning with Feedback Based Optimization
 
02:19
Oracle Database 11g provides a new feature called "feedback based optimization". In this tutorial you will learn what feedback-based optimization is and how it helps Oracle Database 11g performance. One part of nine tutorials dedicated to Oracle 11g Adaptive Cursor Sharing. View all 10 videos for free at SkillBuilders.com/ACS.
Views: 4689 SkillBuilders
Query Tuning with tkprof
 
14:57
Demonstration of generating Oracle trace files and then turning these into tuning reports with the tkprof utility.
Views: 53183 Stephen Frein
Security in the Database Oracle 11g
 
01:07:48
This webinar was recorded live on 29 Feb 2012. Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User Group) presents practical ways to look at security and implementing standards and procedures around the database environment to account for the security outside of the users, including secured environments for regulations and compliance. Oracle 11g provides transparent data encryption at a tablespace level, and this webinar looks at how to implement this option to make it transparent to applications and users. You will learn some quick steps on securing the database environment, a basic process for applying CPU security patches, managing permissions and roles from test environments to production, and encryption. You can view our complete archive at http://www.red-gate.com/oracle-webinars
Views: 17866 Redgate Videos
1Z0-417 – Oracle Exam Database Performance Test Tuning Questions
 
00:50
For more information on Oracle 1Z0-417 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-417.htm What am I going to be tested for? This 1Z0-417 certification exam covers topics such as: Describe product technologies and major capabilities that make up a 1Z0-417 Database Performance and Tuning Test Solution, Provide a high level overview of key 1Z0-417 hardware and software product exam components for an Oracle Database Questions Performance test solution. Which are some of the topics of the 1Z0-417 Tuning exam? 1Z0-417 Test Topic 1: Positioning the Solution Questions (Exam Coverage 20%) 1Z0-417 Test Topic 2: Solution Overview Questions (Exam Coverage 10%) 1Z0-417 Test Topic 3: Product Area Features Questions (Exam Coverage 15%) 1Z0-417 Test Topic 4: Solution Implementation Questions (Exam Coverage 13%) 1Z0-417 Test Topic 5: Performance Diagnostics Questions (Exam Coverage 23%) 1Z0-417 Test Topic 6: Performance Tuning Questions (Exam Coverage 19%) Who can attend to the Oracle Database Performance and Tuning Essentials 2015 test? Candidates must have a basic understanding of: Differentiate 1Z0-417 Oracle product technology for test database performance within the 1Z0-417 Oracle portfolio, competitive marketplace and the opportunity available to partners, Describe what it requires to get started with an Oracle Exam Database Performance test solution and the minimum and typical environment required. Can you give me some in-depth information on the 1Z0-417 exam topics? • 1Z0-417 AWR, ADDM, ASH, and Database Express architecture • Real Application Testing architecture • Real User Experience 1Z0-417 Insight architecture • Performing exam database performance Health Checks • 1Z0-417 Application Testing architecture • Integration: Enterprise Manager Cloud Test Control architecture • Application, 1Z0-417 database, middleware, network, system, storage • Segment Advisor and test object reorganization • Real User Experience Exam Monitoring What’s the 1Z0-417 passing score and duration? The duration of this exam is 120 minutes (82 questions) and the minimum passing score is 75%.
Views: 137 Orsan Stubell
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 5958 BhagyaRaj Katta
DB Optimizer - Database Performance and SQL Tuning
 
04:18
DB Optimizer is a database optimization tool that maximizes database and application performance, reliability, and availability by profiling, tuning, and load testing SQL code.
Oracle And Database Performance Testing
 
00:42
http://perftuning.com/consulting/performance-tuning-assessment - Database performance testing is regularly done on all Oracle databases. Database consultants can explain to you that Oracle is one of the best known databases in the world. Oracle 10g performance tuning, therefore, has become a real IT specialty. You should always make sure that a well-trained individual performs your database performance testing.
Views: 343 kathleenwarner75
Oracle Database Backup and Recovery Session 1
 
02:38:11
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis 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. MASTER AND LEARN - Backup and Recovery Overview - Cold Database Backup - Hot Database Backup - Manual Database Recovery
Views: 134164 DBA Genesis
Database Performance Tuning| Sql server |oracle|mysql|sybase|postgress
 
02:26
Database performance tuning session | Oracle |MySQL|sybase|teradata |postgress | Db sever |database |indexes|clustered indexes |non-clustered index
Views: 17 rahul singh