Home
Search results “Oracle v sql elapsed time”
SQL Execution/Elapsed Time - DBPerf Video 11
 
03:01
In this video you will undestand what is SQL Execution time. You will get to know about CPU time and Wait Time . 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: 2509 Ramkumar Swaminathan
Demonstrating Oracle DB Elapsed Time and Wall Time With Parallel Query
 
03:37
Is it really true? In my recent postings I wrote that when using parallel query a SQL statement's wall time is roughly equal to its elapsed time divided by the number of parallel query slaves. To check I ran an experiment and posted the results. The results are both obvious and illuminating. If you don't want to read but just sit on the couch and watch a video, you're in luck! I created a special video clip demonstrating what I wrote about. The main video clip is from my OraPub Online Institute video seminar, Tuning Oracle Using An AWR Report - Part 1. (NOT Part 2 as the video shows) From my blog posting: http://blog.orapub.com/20140907/watch-oracle-database-elapsed-time-and-wall-time-with-parallel-query.html For more information on OraPub r for more great education, go to www.orapub.com
Views: 1238 OraPub, Inc.
Oracle: How To Optimize Performance When The Top Event Is DB CPU  - Webinar
 
01:18:42
In this webinar Oracle Ace, Craig Shallahamer, will demonstrate how to do an Oracle time based analysis including integrating the OS situation into our analysis and finding the true “top” SQL. This journey includes a trip into Oracle’s library cache, memory access control and some interesting ways to improve SQL statement performance. Overall performance sucks as far as the users are concerned. After months of meetings management finally wants you to get involved. You run an AWR report for one of the most intense hours and notice the top “event” is "DB CPU" followed by "cursor: pin S wait on X”. This is where the webinar begins!
Views: 736 OraPub, Inc.
What Is Oracle Elapsed Time, Wall Time And It's Relationship With Parallelism
 
01:12
Blog link: http://blog.orapub.com/20140818/What-Is-Oracle-Database-Elapsed-Time-And-Wall-Time-With-A-Parallelism-Twist.html In this post I'm focusing on SQL elapsed time, adding parallelism into the mix and then revisiting wall time. What initially seems simple can some take very interesting twists! If you are into tuning Oracle Database systems, you care about time. And if you care about time, then you need to understand the most important time parameters: what they are, their differences, how they relate to each other and how to use them in your performance tuning work. This is video is clip from the OraPub Online Institute seminar, Tuning Oracle Using an AWR Report.
Views: 701 OraPub, Inc.
What is DB Time - DBPerf Video 12
 
03:56
In this video you will understand what is DB TIme in an Oracle Database. . 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: 2648 Ramkumar Swaminathan
Performance Management - DBPerf Video 08
 
01:02
In this video you will understand what it is to manage performance... . 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: 1671 Ramkumar Swaminathan
Relationships of Physical and Logical Storage structures in an Oracle Database - DBArch Video 22
 
06:14
In this video you will understand the Relationships between the Physical files and Logical Components - Tablespace, Segments, Extents and Oracle Blocks in an Oracle Database . 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: 17004 Ramkumar Swaminathan
Extended Insight reveals why SQL elapsed times differ on two machines
 
05:14
In this brief video, you'll see a real life example of how InfoSphere Optim Performance Manager Extended Insight was used to determine why running a batch of SQL statements had very different elapsed times when run from different machines. Produced by Marcia Miskimen.
Tackling Time Troubles About Date Types in Relational Databases
 
46:46
Dealing with time related data can be more complicated than what one might expect at first thought. Leap years, time zones and daylight saving time switches can cause confusion and lead to runtime errors or poorly performing SQL code. We will look at some major pitfalls that should be avoided and discusses best practices when dealing with time data. Björn Rost is an Oracle Developer Champion, ACE Director, and one of Pythian's top Oracle experts. A popular presenter, Björn travels the world attending technology conferences, sharing insights, and learning with his wide network of peers. Björn also organizes the OTN EMEA tour and served as president of IOUG's RAC special interest group and. He is always challenging himself, personally through physical activities including triathlons, and professionally through his ongoing quest to increase his knowledge of Oracle, automation and stream data processing. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 214 Oracle Developers
Hibernate Tip: How to log the execution time of a query
 
03:16
Get more recipes like this one in my new book Hibernate Tips: More than 70 solutions to common Hibernate problems: https://goo.gl/XfywNk Today I want to answer a performance related question that someone asked me on my blog. Here it is: Some of my queries seem to be slow. Can Hibernate measure and log the execution time of a query? The answer is: Yes! It can do that and a lot more. Let me show you how. If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Join the free Member Library: https://goo.gl/dtyIIC Read the accompanying post: https://www.thoughts-on-java.org/hibernate-tips-log-execution-time-query/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 1664 Thoughts On Java
Performance Engineering - DBPerf Video 06
 
07:41
In this video you will understand the concept of Performance Engineering. Performance Engineering is much more than just identifying the functionality. . 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: 3017 Ramkumar Swaminathan
Minimize your Trips to Db2 and Reduce your Db2 Elapsed and CPU times
 
56:36
Presented by Linda Claussen, Themis, Inc. Most relational tuning experts agree that the majority of performance problems with applications that access DB2 are caused by poorly coded programs or improperly coded SQL. A great deal of time is spent on tuning your SQL but how much time are you spending tuning or conducting performance reviews of your application code? This session takes a close look at reducing the total number of SQL statement and reducing your trips to DB2 by implementing coding techniques that can reduce multiple SQL statements to single requests.
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 28027 Jeff Smith
Identifying High Risk Oracle SQL Before The Upgrade - Seminar Intro
 
11:36
Everyone knows identifying the high risk Oracle Database SQL AFTER the upgrade is easy. But before the upgrade? That's difficult. You need to be Identifying High Risk SQL Before The Upgrade. Comparing SQL elapsed times is simply not good enough. Any differences between production and test makes this approach futile. Why? Because there are different business scenarios, workloads, Oracle releases, application releases, hardware configurations... you get the idea. In this seminar I aggressively deal with these complex issues, regardless of the upgrade type. If you are involved with helping to ensure a smooth upgrade, you need to put into practice what I teach in this seminar. It's practical, insightful and a lot of fun. What you are watching in the seminar Introduction. For details go to http://www.orapub.com/video-seminar-id-high-risk-sql-upgrade What You Will Learn - Why SQL elapsed times can be different on "similar" systems - How to use workload intensity and database time to ID at-risk SQL - Why "similar" systems can have very different workload intensities and database time profiles - How to quickly profile two systems using a time based methodology - How to properly compare SQL elapsed times on systems with different CPUs - How to gather CPU "speed" data - How to standardize SQL elapsed times for appropriate comparison - How workload intensity factors into SQL elapsed times - How different system workloads can falsely tag SQL as risky - How different system workloads can miss risky SQL - Why functionally focused benchmarks make SQL elapsed time comparisons unreliable - How to identify risky situations when the same SQL is used in different business scenarios, runs with - different bind variables and uses different interim table names - How to deal with situations when a benchmark runs overlapping business scenarios at the same time - How to develop a statistical "fingerprint" based on module, action or something else - How to pull elapsed time data from AWR tables - How to use the free statistical package R to compare two (think: PROD and QAT) elapsed time fingerprints - How to use the statistical "fingerprint" results to identify a high risk situation Modules 1. The Truth Hurts: Production vs QAT Realities 2. How To "Fingerprint" An Oracle System For Comparison 3. How To Compare SQL On Different CPU Speed Systems 4. How To Compare SQL On Different Workload Systems 5. How To ID Risk In Highly Business Focused Benchmarks - 1 6. How To ID Risk In Highly Business Focused Benchmarks - 2 For more information about OraPub, go to www.orapub.com
Views: 168 OraPub, Inc.
SQL DATEDIFF() Function
 
01:22
The SQL DATEDIFF() is a function, and use to find the difference between two dates.
Views: 931 suresh babu
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: 5336 Redgate Videos
Connection Optimization and Pooling - Demonstration - DBArch Video 20
 
05:38
In this video you will learn how proper connection management by an application to a database can significantly impact response time of database operations. 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: 5978 Ramkumar Swaminathan
Query Tuning 101 Why Use Autotrace
 
01:38
When you're optimizing SQL queries you need to understand what they're actually doing. Explain plan is a commonly used tool with a major flaw - the reported plan and actual plan can be different! This video demonstrates this with a simple query, showing how autotrace reports the correct execution plan for the SQL statement. ============================ 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: 2510 The Magic of SQL
eXtreme Parallel Processing for Oracle
 
00:16
Is your current processing task complex and depending on CPU? Does it take too much time processing your PL/SQL eventhough you have strong HW? Don't have time to rewrite PL/SQL sources to optimize them? If your answer is yes, then our product eXtreme Parallel Processing for Oracle is exactly for you
Views: 55 Petr Jezek
Advanced SQL and the Power of Rewriting Queries
 
57:53
Presented by Tony Andrews, Themis Inc. Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This presentation breaks down many examples of query rewrites and how they can affect performance and optimization. Being strong in SQL is a great skill when it comes to performance and tuning of queries. Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.
Using Skewed Oracle Performance Data To Your Advantage - Seminar Intro
 
07:23
Using Skewed Performance Data To Your Advantage is an important seminar for all DBAs because EVERY Oracle DBA has experienced the effects of skewed performance data, but most don't know how to use that knowledge to their advantage. Have you ever had different groups of users experience different response times from the same exact SQL? Has your IO Admin said the IO response time is fine, but you know single block IOs are taking around 25ms? If you have experienced something like this, then you have likely experienced skewed performance data. I designed this seminar so you will know exactly how to avoid this situation of skewed Oracle wait times and SQL elapsed times. I will teach you how to gather the appropriate data, understand the data and visually demonstrate the situation. This seminar is going to have a deep impact on your Oracle performance work. The skills I teach you will help you devise a sensible solution. Join me for a practical and entertaining journey as we explore the truth about elapsed times and wait events times, turning a potential disaster into your advantage. For details go to http://www.orapub.com/video-seminar-skewed-performance-data This contains eight modules: 1. Introduction: Revealing deception (this video) 2. Understanding your data 3. Common histograms in Oracle performance analysis 4. The problem: Skewed wait times 5. My advantage: Using the skewed wait times 6. The problem: Skewed elapsed times 7. My advantage: Using the skewed elapsed times 8. Resources and seminar close What you will learn: * Know what skewed data is * Be able to communicate why skewed data is a serious problem * Be able to recognize skewed data * Know how to gather individual wait event occurrence times, not average * Know six ways to gather individual SQL execution times, not average * Understand, demonstrate and communicate if skewed data is a problem * Recognize the five common statistical distributions * Be able to describe data using one picture and two statistics * Know histogram construction details * Know how to use the difference between the mean and median * Be able to install and use the free stats package, R * Be able to use the difference between the mean and median * Know how a histogram can cause faulty thinking * Understand why v$event_histogram deceives * Be able to use an AWR and Statspack report to recognize skewed data problems * Know how to create a proper SQL execution time histogram * Know how to create a proper wait event occurrence histogram For more information: http://www.orapub.com
Views: 436 OraPub, Inc.
Oracle Parallel Execution Plans Deep Dive
 
44:24
A presentation about understanding the essentials of Oracle Parallel Execution and how to read the corresponding execution plans
Views: 3310 Randolf Geist
Solved! - Unable to modify table.   Execution Timeout Expired
 
00:36
'B_DEVICE_ALL_SATS (dv)' table - Unable to modify table. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Views: 4205 Maruti AIR Tech
Point in time recovery via flashback
 
05:35
Point in time Recovery in Oracle 11g
Views: 784 Athar Fahad
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: 3488 Redgate Videos
User and Schema - DbArch Video 33
 
04:31
In this video you will understand whats the difference between an Oracle User and Schema. You will also get to know about some of the most frequently created objects in a Schema. 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: 6729 Ramkumar Swaminathan
How To Kill All Database Processes On SQL Server
 
06:42
SQl management studio provides lot of facilities to manage SQL processes. The “Activity monitor screen” which will show you some very useful and important information about SQL processes. It will show you all active processes, there status, number of open transactions for each process, the application by which the process is generated, Wait time CPU and memory utilisation, and the host name, means the host or the machine by which the process is initiated etc. If a process is hanging, it will show the process icon with an hour glass. Refresh it several times, sometimes the icon will turn to sleep mode if the process completes its execution. If the icon remains an hour glass, the process may be hanging. Use other info as well to decide if the process is really hanging. If you double click on the process ID it will show the SQL stamen subjected to the execution of the process. If a process is hanging you can identify which application has originated the process, which SQL stamen is hanging and even more from which machine or the host the process is initiated If some application users are complaining about uneven slowness, uneven timeouts etcetera, the reason behind may be one or more processors are hanging. What can you do now? You can restart the SQL server or the service which will disconnect all databases and all applications disturbing all the users. Or otherwise you can take the database to off line and bring it back to online. Or you can disconnect all connections to the database. The disturbance may be lesser than the previous case but still lot of applications and users can be disturbed, especially in an industrial setup. And still you do not know the real reason for the slowness or the malfunctioning as well. So what can you do? Go and examine the processors. Identify exactly which process is hanging. And most probably you will be identifying how and why. So you can find permanent solution. But the immediate solution is you can kill the troubling process or the few. It will solve the issue with minimum disturbance immediately. After identifying the correct process, you can right click on the process ID and click on ‘Kill process’ button. It will kill the selected process. You can kill processors using SQL statements and, using SQL commands you can kill all processors at once as well. Code for Killing Processes Individually USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' EXECUTE ('KILL 53') Code for killing all Processes USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE ('KILL ' + @spid) SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid @spid END
Views: 7618 Rohan Mehtha
ROWID - DBArch Video 32
 
05:20
In this video you will understand what is ROWID in an Oracle Database, where is it stored and what are its components. 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: 4554 Ramkumar Swaminathan
Bad Connections and Bad SQL - DBPef Video 10
 
04:45
You will learn about the top 2 resource hoggers in an Oracle Database... . 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: 2081 Ramkumar Swaminathan
Dates and Times in SQL
 
08:35
An introduction to working with dates and times in SQL Server.
Views: 619 Database by Doug
How To Tell If There Is An Oracle OS Memory Shortage - Webinar
 
01:18:37
How To Tell If There Is An OS Memory Shortage - Webinar An operating system memory shortage can cause very strange and intense performance situations. In this webinar, we will explore different ways to tell if there is a memory shortage and how this affects Oracle processes. Using a simple shell script, Craig is moving towards slowing increased memory usage. Then, we will watch what is happening using the vmstat, iostat and sar commands. And of course, we will also be monitoring the active Oracle sessions, key SQL statement elapsed times and key throughput metrics. As you will see, a memory bottleneck (rather, memory pressure) can cause some really strange performance behavior.
Views: 110 OraPub, Inc.
Is performance by luck or chance - DBPerf Video 05
 
01:24
. 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: 1907 Ramkumar Swaminathan
Oracle Parallelism Concepts
 
20:42
Oracle Parallelism Concepts
Views: 2293 The Silent DBA
Introduction to AWR - DBPerf Video 16
 
05:27
In this video you will understand what are V$ views and whats in the AWR. 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: 4854 Ramkumar Swaminathan
How Oracle Determines Wait Time When It Releases Control
 
01:23
Have you ever wondered how the Oracle Database 12c (and earlier versions) determines the wait time when it has absolutely no control over how long the wait will take? If so, then read on in my blog posting: http://blog.orapub.com/20140630/How-The-Oracle-Database-Determines-Wait-Time-When-It's-Not-Set.html Check out OraPub's Online Institute where this topic is part of the seminar, Introduction To Oracle Time Based Analysis. https://resources.orapub.com/OraPub_Online_Seminars_About_Oracle_Database_Performance_s/100.htm
Views: 550 OraPub, Inc.
Parallel SQL
 
42:36
Joel Bernstein from Alfresco broke his Lucene/Solr Revolution presentation into two parts. During the first half he talks about everything that SQL can do with Solr. The second half is an in-depth look at how SQL works. Later in the presentation he talks about Streaming Expressions which solves two problems that the streaming API has. Presented at Lucene/Solr Revolution. Learn more: https://activate-conf.com/
Views: 751 Lucidworks
What is an AWR Report? - DBPerf Video 17
 
03:27
In this video you will understand what is an AWR report. What does it contain? How should an AWR report be taken? 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: 6738 Ramkumar Swaminathan
Troubleshooting and Tuning - DBPerf Video 07
 
04:29
In this video you will understand the process of Troubleshooting and Tuning an Oracle database performance issue. . 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: 2569 Ramkumar Swaminathan
The Optimum Histogram Utility DEMO 2- Maximize Oracle Performance and SQL Execution Efficiency
 
14:36
Description Demonstration of the influence of the Optimum Histogram utilities on the estimation accuracy of the Oracle Optimizer in a 11.2.0.1 Oracle Database. Tests highlight the increase in estimation accuracy on the optimizer and impact on execution plan selection. Tests conducted against a numeric column in a heap table and execution plan results and statistics captured to indicate impact on the optimizers execution plan selection of the OHU histograms. IMPORTANT NOTE: This utility is not a substitute for oracle's dbms_stats which calculates highly valuable statistics for oracle objects. It is an add on utility that can be used on columns with skewed distribution. Please see demonstration one for overview of architecture
Views: 542 Doug Laughlin
What is that one thing that can fix all performance issues - DBPerf Video 03
 
02:04
. 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: 2883 Ramkumar Swaminathan
Oracle Performance - Result Cache Exercises
 
11:09
Oracle Performance - Result Cache Exercises
Views: 770 The Silent DBA
Detailing Oracle CPU Consumption: The Missing Link - Seminar Introduction
 
05:23
Detailing Oracle CPU Consumption: The Missing Link helps Oracle Database Administrators answer this question, "What's Oracle doing with all that CPU?" For details go to http://www.orapub.com/video-seminar-detailing-cpu-consumption Here's the problem: While Oracle has the world's most advanced database wait time instrumentation, Oracle does NOT instrument CPU consumption. This presents the Oracle DBA with a tuning handicap because CPU consumption can be a significant component of database time. The unintentional result can be solutions with a wait time bias and solution guessing. In this session you will learn how to determine where Oracle is consuming CPU down to the Oracle kernel code function level and how this relates to the broader performance situation. Now you will be able to more effectively develop solutions to reduce both CPU consumption and wait time. Important: The solution created to solve the CPU detail limitation is Linux based. While I'm confident there are very similar solutions in other operating systems, I do not explore this. What You Will Learn - How to answer the question, "Is that process doing anything or stuck?" - How to answer the question, "So what is Oracle doing with all that CPU?" - How to overcome the problem of understanding limitation when there is little wait time but lots of CPU time. - Finding the Oracle kernel function when there could be a possible bug. - Helping you understand what Oracle is doing, "under the hood." Modules - The problem and what to do about it - My journey to find a solution - Creating the solution based on the Linux "perf" tools - Examples of how to use the tool in production situations For information on how you can watch the whole seminar or for more great eduction from OraPub, go to www.orapub.com
Views: 1995 OraPub, Inc.
Visual SQL Tuning
 
39:04
Views: 1749 kyle Hailey
SQL timeout expired. The timeout period elapsed prior to completion of the operation
 
00:47
Description https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx c # Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Have you set the CommandTimeout ? . If not set the CommmandTimeout (in seconds) check. Most of the times it should work. The below URL gives you more information about CommandTimeout. https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx This property is the cumulative time-out (for all network packets that are read during the invocation of a method) for all network reads during command execution or processing of the results. A time-out can still occur after the first row is returned, and does not include user processing time, only network read time. For example, with a 30 second time out, if Read requires two network packets, then it has 30 seconds to read both network packets. If you call Read again, it will have another 30 seconds to read any data that it requires.
Views: 8430 Rohan Mehtha
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: 14627 SkillBuilders
Tuning Oracle Using An AWR Report - Seminar Intro
 
12:19
Tuning Oracle Using An AWR Report teaches Oracle DBAs how to make Oracle Database systems fast using standard Oracle reports and performance data. This seminar will lead you through the entire process turning you into a respected performance analyst. Your solutions will be spot-on and everyone will know it. When users call about a performance problem, you will know what to do, do it fast, and be able to explain the situation with clarity and confidence. For details to go http://www.orapub.com/video-seminar-tuning-oracle-using-an-awr-report PART ONE of this seminar builds your strong foundation. You will learn how an Oracle Time Based Analysis combined with OraPub's 3-Circle Analysis are used to methodically expose problems and develop solutions. You will understand the larger performance picture that escapes most DBAs. It is foundational and it sets you up for success! PART TWO of this seminar focuses on constructing a time based diagnostic framework, developing targeted tuning solutions fast, and turning this all into a compelling story. Your solutions will make sense and your analysis will be clear. Your peers and management will trust and respect your work. Do NOT watch this seminar if you are looking for training about all the AWR report sections or how to work through an AWR report from top to bottom desperately searching for problems and solutions. If this is you, then I recommend you purchase one of the many available AWR books and also my Oracle Performance Firefighting book. BUT, if you are looking to solve any performance problem that comes your way based on an AWR report, then this seminar is exactly what you want. Tuning Oracle Using An AWR Report - Part 1 1. The Big Picture: How The Pieces Fit Together 2. Why A Time Based Analysis Is Awesome 3. Oracle Processes Are CPU Suckers! 4. Oracle Processes Hate To Wait! - Part 1 5. Oracle Processes Hate To Wait! - Part 2 Tuning Oracle Using An AWR Report - Part 2 1. Building A Diagnostic/Troubleshooting Framework - Part 1 2. Building A Diagnostic/Troubleshooting Framework - Part 2 3. Finding Multiple Performance Solutions Fast! - Part 1 4. Finding Multiple Performance Solutions Fast! - Part 2 5. How To Create A Great Performance Story - Part 1 6. How To Create A Great Performance Story - Part 2 7. Resources: The Learning Never Stops! For more information go to www.orapub.com
Views: 17921 OraPub, Inc.
Confused by sp_who2 (Dear SQL DBA Episode 30)
 
14:38
Learn why the output for the built in sp_who2 can be confusing, and better tools to get you more information, fast. Note: technical content begins about a minute into the video. Prefer a written version? Go to https://www.littlekendra.com/2017/02/16/confused-by-sp_who2-dear-sql-dba-episode-30/
Database Performance  - Introduction - DBPerf Video 01
 
03:03
In this video you will understand how to approach Database Performance Management . 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: 6275 Ramkumar Swaminathan