Home
Search results “Analyze oracle index”
Oracle Indexes - Beginner
 
12:12
Oracle Indexes - Beginner
Views: 62739 Chris Ostrowski
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: 42866 DWS Ltd
Oracle Optimization - Table Partitions
 
15:07
Oracle optimization: create table partitions and Index-Organized Table. Other lessons, visit http://www.learn-with-video-tutorials.com/plsql-oracle-optimization
B*Tree Index Fundamentals(Indexes in Oracle-1)
 
17:42
Part -1 : Introduction to Indexes, B*Tree Indexes, Index scan methods. Part -2 : B*Tree Index Types(different types of B*Tree indexes) Part -3: Using B*Tree Indexes(When use B*Tree indexes, factors related to B*Tree Access) Part -4 : Index Organized Table Part -5 : Bitmap Indexes Part -6: Partitioned Indexes Part- 7: Other type of Indexes based on characteristics & use. Part -8: Managing Indexes
Views: 48167 Anindya Das
Index Fragmentation  Internals, Analysis, and Solutions
 
01:43:15
As soon as you have more than one index on a table, you’re going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You’ll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy. CEO / Owner Paul is a Microsoft SQL Server MVP and a Microsoft Regional Director. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and is a world-renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp.
Views: 4813 DBAFundamentals
Oracle index creation monitoring
 
01:50
Analyzing an Oracle index creation with d.side - Automatic diagnostic for Oracle databases performance and troubleshooting http://www.dside-software.com Copyright (c) d.side software
Views: 204 D.SIDE SOFTWARE
A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1
 
08:43
"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries. In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan. He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 6863 The Magic of SQL
B*Tree Index Types (Indexes in Oracle-2)
 
33:58
This video will cover different types of B-tree indexes: Descending index,Reverse key index,Key Compressed Index B-tree cluster index,Index Organized Table(IOT):
Views: 15147 Anindya Das
AWR Reports and Baselines
 
10:16
AWR Reports and Baselines watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
How To Analyze And Solve Oracle Direct Path Read Problems - Introduction
 
00:59
How To Analyze And Solve Direct Path Read Problems - Introduction Oracle Direct reads of all kinds tell a special and unique performance story. But this uniqueness can result in unexpected performance issues. In this webinar I will use an AWR report and live demonstrations showing how Direct Path Reads work, why they are used, why they are awesome and also how they can beat your IO subsystem to death! I hope can join me as we explore an increasingly popular data retrieval method. If you would like to view the webinar - go to www.orapub.com/webinars For more information on OraPub or on Oracle Ace, Craig Shallahamer, go to www.orapub.com
Views: 22 OraPub, Inc.
Oracle tutorial : Using execution plan to optimize query in oracle
 
12:54
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: 7315 Tech Query Pond
Query Analysis and Optimizing in Oracle
 
37:53
Database Management Systems 11. Query Analysis and Optimizing in Oracle ADUni
Views: 81891 Chao Xu
Index Rebuild vs. Reorganize
 
05:48
Some of my thoughts about performing either, or any at all. In some cases, I won't use indexes.
Views: 3667 SQLInSix Minutes
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: 60842 SkillBuilders
Oracle  AUTOTRACE Fundamentals to Analyze & Tune SQL
 
20:43
This Tutorial will explain fundamentals of Oracle AUTOTRACE. Set up & Use AUTOTRACE. Review PLAN & Statistics generated by AUTOTRACE. Understanding Statistics details.
Views: 22040 Anindya Das
Analyzing and Troubleshooting Oracle Parallel Execution
 
01:58:45
Presented by Randolf Geist 8th May 2013 Oracle parallel execution, a feature of the Enterprise Edition, allows you to automatically distribute the processing of a SQL statement execution among multiple worker processes. This requires additional effort when analysing and troubleshooting such parallel executions, since it adds complexity that is simply not there with normal serial execution where only a single process is involved. In this webinar, Randolf Geist, provides an overview of what these additional challenges are and how these can be approached. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 3389 Redgate Videos
How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5
 
10:58
Every index you add to a table increases its storage requirements and DML overheads. So it's a good idea to create as few as possible. When you have two or more indexes using the same columns, you may be able to get away with just one. But how do you decide which to keep? This video discusses how to analyze your queries so you can cut the number of indexes you create. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1984 The Magic of SQL
tkprof for trace analysis
 
12:56
tkprof for trace analysis watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
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: 89997 radhikaravikumar
How to analyze code with Toad for Oracle Xpert Edition
 
03:42
http://www.DellSoftware.com/Toad-for-Oracle This video shows how to analyze code with Toad for Oracle Xpert Edition from Dell Software.
Views: 1080 DellTechCenter
TEPCO - Using Oracle's Primavera Risk Analysis for P6 Turnaround Projects
 
32:56
Using Oracle's Primavera Risk Analysis for P6 Turnaround Projects http://www.tepco.us
Views: 5716 TEPCOLLC
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: 34161 itversity
Real-World Performance - 15 - Index Contention
 
19:46
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 index contention 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.
Using B*Tree Indexes-When to use B*Tree Indexes(Indexes in Oracle-3)
 
31:14
 This video will cover  When B*Tree Index should be used. We will try to understand some of the situations when the optimizer will use B*Tree Index.  Index Clustering Factor .  Influence of parameter Optimizer_Mode and Optimizer_index_cost_adj on using B*Tree Index.
Views: 13088 Anindya Das
Index Fragmentation  Internals, Analysis, and Solutions   Paul Randal
 
01:46:16
As soon as you have more than one index on a table, you're going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy. Paul’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and has been a SQL Server MVP ever since. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp. Full bio at http://www.sqlskills.com/about/paul-s-randal/
Views: 763 DBAFundamentals
Interpreting Oracle Explain Plan Output - John Mullins
 
01:00:16
Themis Instructor John Mullins presents some details on interpreting Oracle Database Explain Plan output. For more information visit http://www.themisinc.com
Views: 42304 Themis Education
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: 50067 Anindya Das
Non Obvious MySQL Index Optimization Tricks part 1
 
16:17
Signup here to get the next part of this video when ready: https://www.launchclasses.com/MySQL-Index-Optimization-Tips-1 Enable subtitles and auto-translation in this video to read the transcription in your language. Every developer knows that adding indexes to database tables may speedup database queries. However, in several circumstances, this may not be the case, and your application may actually get slower when you add indexes. Watch the video of the first part of this talk that teaches what are indexes under the hood, how to determine when you should add indexes to your database tables, when you should not add indexes, and what you can do in alternative to adding indexes when using indexes may slow down your applications. Contents Non-Obvious MySQL Index Optimization Tricks What else you should know to optimize MySQL applications using indexes or not Manuel Lemos What is an Index? When to Use Indexes? What is the slow query log? How does a slow query log look like? Analyze slow queries with EXPLAIN Output of the EXPLAIN query When to not use an index? Alternatives to using indexes Queue tables Split tables with many fields Examples of split tables Conclusion
Views: 2063 Launch Classes
Searching for Log Entries Using Oracle Log Analytics Cloud Service
 
01:20
Oracle Log Analytics Cloud Service is a unified, integrated cloud solution that enables you to monitor, aggregate, index, analyze, search, explore, and correlate all log data from your applications and infrastructure.
Oracle Midlands #13: Interpreting AWR Reports - Franck Pachot
 
57:30
Timestamps: 2:30 - Database load 10:30 - Top 10 Foreground Events 16:30 - db file sequential read 23:39 - DB CPU 32:30 - log file sync 37:16 - enq: TX - row lock contention 39:47 - Findings summary & recommendations 42:38 - Quantifying the gain 47:15 - Q&A Franck walks his way through an AWR report, explaining his observations and thought process as he goes. The slides are available at: Google: https://drive.google.com/folderview?id=0B0DLaAfeW6uKZmJ3TXE0WGtLYlE Dropbox: https://www.dropbox.com/sh/9koxoemak8ts7j6/AADozVVYLoK_FdDZbQGC6TYta This event was sponsored by Red Stack Technology (http://redstacktechnology.com/). See more events at http://OracleMidlands.com/ Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. "Fair Dealing" under UK Copyright, Designs and Patents Act 1988.
Views: 9783 Oracle Midlands
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: 26154 Anindya Das
Query Tuning with tkprof
 
14:57
Demonstration of generating Oracle trace files and then turning these into tuning reports with the tkprof utility.
Views: 53690 Stephen Frein
Analyzing ANY Privilege Use with Oracle Database Vault
 
02:53
This video shows you how to analyze the use of the READ ANY TABLE system privilege in Oracle Database 12c with Oracle Database Vault. The tutorial is also described step-by-step in the product documentation. 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.
Calculate query performance with Explain Plan in Oracle PLSQL.
 
09:14
Explain plan is a wonderful utility in Oracle PL SQL. It helps you to understand how much cost a query takes to perform based on indexed table or table without index. In this oracle tutorial a full description is given on a table containing huge number of rows first based on index on a column and then without index.
Views: 3462 Subhroneel Ganguly
Stored Procedure Optimization Techniques
 
13:50
Performance Tunning : Procedure : 1.Set Nocount On 2.Set Isolation level Read Uncommited / Nolock 3.Missing Indexes : 4.Scalar function 5.COvering index -- include 6.Partition . 7.Proper Index -- Column Store 9.Try to minimize Physical read 10.Fragmentation issue (Index rebuilding + Reorganizing ) 11.understand Execution planning (opertor )
Views: 7392 SqlIsEasy
ORACLE TKPROF fundamentals Part 1 -  Introduction to SQL Tracing & TKPROF
 
11:44
Link for ORACLE TKPROF fundamentals Part-2 (Interpret TKPROF Report) https://www.youtube.com/watch?v=OiVu6vFq28w ORACLE TKPROF fundamentals For SQL TUNING Part-1 covers 1. Introduction to SQL Tracing. 2. Set up SQL_Trace &TKPROF. 3. Generate TKPROF Report. ---------------------------------------------------------------------------------------------------------------------- ORACLE TKPROF fundamentals For TUNING SQL Part-2 covers  1. Interpreting TKPROF Report.
Views: 30130 Anindya Das
SQL: Optimizer Hints Part-1
 
05:56
In this tutorial, you'll learn...what are optimizer hints and how to use it.. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Views: 18505 radhikaravikumar
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.
SQL: Introduction to Optimizer in Oracle
 
07:34
In this tutorial, you'll know what is the meaning and use of Optimizer in Oracle
Views: 16735 radhikaravikumar
Oracle Social Relationship Management - Reviewing Resource Metrics
 
03:34
The Oracle Social Listen & Analyze tool allows brands to monitor social message streams, view social analytics, and gain key insight into how the social user is engaging with the brand on social. This video showcases the various metrics that are available on the tool such as fan demographics, growth in fans, fan sources, reach, engagement and more. Visit http://docs.oracle.com/cloud/social/index.htm for full documentation, and the Oracle Learning Library at http://oracle.com/goto/oll more on the Oracle Social Listen & Analyze tool. Copyright © 2013 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.
Big data inside: columnstore index internals
 
01:01:18
Columnstore index, introduced back in SQL 2012 was a major breakthrough for SQL Server enabling it to analyze huge volumes of data in a reasonable time. With updateable clustered columnstore index in SQL 2014 Microsoft made another step forward making this feature usable for almost any datawarehouse deployment. But what stands behind this breakthrough? How data is stored in a columnstore index and what makes queries run so fast? In this session we will dive deep into columnstore index data structure, explain different sorts of data encoding and compression it uses, see how those indexes are used in a query - in a very different way from traditional indexes we're used to in SQL Server. From data structure we will continue to data loading and see how loading data into clustered columnstore index is different from loading data into traditional SQL Server table.
Analyzing the Drivers of LinkedIn's Social Selling Index (SSI) - seg. #24
 
06:50
In our socially connected economy, easy access to information makes transparency the norm and authenticity critical at every level. The new form of currency in this economy is the depth of your relationships and your commitment to contributing to your network. In this segment, Jeff explores the main attributes and trend analysis of LinkedIn's Social Selling Index (SSI.) --- Find Jeff here: Website: http://www.publishorperish.fm/ Twitter: @JeffLHerrmann Twitter: @PublishPerish.FM LinkedIn: https://www.linkedin.com/in/jefflherrmann Jeff is a champion of B2B sales, marketing alignment and brand audience development. Jeff’s passion lies in the development of strategies to leverage content; technology and data to help both organizations and individuals realize extraordinary growth. With a commitment to constant learning, leadership development, and teaching, Jeff has a live laboratory to experiment in every day as the lead audience builder for both Fathom’s sales and marketing audiences. Jeff’s passion for content marketing is well founded, following a 15 year career at The Nielsen Company working with Fortune 50 brands in the development of audience measurement and advertising effectiveness solutions for emerging digital platforms.
Views: 104 Jeff Leo Herrmann
How to Think Like the SQL Server Engine, Part 2: Nonclustered Indexes
 
21:20
That last module was horrible – it’s so much work when you only have a clustered index! In this module, you’ll get two nonclustered indexes, learn which one is more useful, and see why seek doesn’t mean awesome.
Views: 4536 Brent Ozar Unlimited
Four Steps to Oracle SQL Tuning  - A Methodolgy
 
02:43
Learn a predictable and repeatable methodology for tuning Oracle SQL statements. Just four steps that you should always follow when tuning an SQL statement. (Note this video does not contain examples of how to apply the four steps, just what the steps are.) Oracle Certified Master John Watson presents. John concludes with a brief overview of how SkillBuilders SQL tuning course provides the information you need to apply the four steps. Learn more about SkillBuilders SQL Tuning course http://skillbuilders.com/oracle-sql-tuning-training 1. What is Oracle doing? (explain plan, trace) 2. Why is Oracle doing it that way? (analyze the execution plan) 3. Is there a better way? Test! 4. If there's a better way, push the CBO towards the better way.
Views: 10154 SkillBuilders
performance tuning
 
18:59
Tracing: Transaction ST12 = Combination of two transactions . SAT (ABAP Trace) , ST05 = SQL Trace SQL Trace: To monitor the database access of reports and transactions. Less common traces : Enqueue Trace: (the locking system),RFC Trace, Table buffer trace: Performance Improvements ABAP Coding: Keep an eye on those loops. Select statements in loops = absolutely avoid = use for all entries instead Function call, or performs in loops = re - visit and see if you can optimize The "READ TABLE" statement Sorted table- Binary search .. Or even better use "Index" on internal tables. Use mass operations on internal table = internal table copy one to another, Append lines of int_fligh1 to int_fligh2. Use field symbols to modify internal table in a loop (minor improvement ) A little trick if you call performs in a loop:: Use static variables Avoid sleep, wait etc commands.. Or synchronous RFC calls 2)Database bottleneck Use Indexes : Make sure Indexes are being used in your select statement (check with trace if needed) Extreme case , create new index (this has the disadvantage of making the insert slower) Select -- End select loop : Usually database optimiser will fix it, still avoid it Select * into corresponding fields = about a millisecond slower Make clever use of inner joins Use views Use (max,min, avg): example : Select max( flightnum ) from flight . GET RUN TIME command Reduce I/O first, then memory, then CPU activity.Field-groups can be useful for multi-level sorting and displaying. However, they write their data to the system's paging space, rather than to memory (internal tables use memory)
Views: 13436 Sourabh Bora
Creating Basic Ad Hoc Reports in Smart View
 
05:08
In this tutorial you learn how to use ad-hoc analysis to create reports and analyze data in Smart View for Oracle Enterprise Performance Reporting Cloud Service.
Views: 44486 Oracle EPM Tutorials
Analyzing Server Logs with Kibana
 
07:06
Full course: https://www.udemy.com/elasticsearch-6-and-elastic-stack-in-depth-and-hands-on/?couponCode=ELASTICTUBE "ElasticSearch 6 and Elastic Stack: In-Depth and Hands-On!" We'll see how Kibana's built-in dashboards can quickly produce all the visualizations you need for your server log data.
Views: 12163 Sundog Education
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: 4935 Redgate Videos