Search results “Oracle v sql elapsed time”
SQL Execution/Elapsed Time - DBPerf Video 11
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: 1888 Ramkumar Swaminathan
Demonstrating Oracle DB Elapsed Time and Wall Time With Parallel Query
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: 1198 OraPub, Inc.
What Is Oracle Elapsed Time, Wall Time And It's Relationship With Parallelism
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: 661 OraPub, Inc.
Oracle SQL Monitoring - Performance Analysis
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: 5154 Redgate Videos
SQL Developer Password Reset
Get the complete OBIEE 12c Data Modeling course at https://www.udemy.com/obiee-12c-data-modeling-course/?couponCode=SANRUSHA11
Tackling Time Troubles About Date Types in Relational Databases
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: 203 Oracle Developers
The SQL DATEDIFF() is a function, and use to find the difference between two dates.
Views: 856 suresh babu
Oracle Performance Tuning Training Video Tutorial information.
http://www.dbvidya.com/blended-training/ [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: 354 DbVidya
Real Time SQL Monitorin Demo in Oracle SQL Developer
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 24751 Jeff Smith
What is DB Time - DBPerf Video 12
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: 1918 Ramkumar Swaminathan
Extended Insight reveals why SQL elapsed times differ on two machines
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.
What is Fast Recovery Area and how to configure it- Backup&Reco Video 6
In this video you will learn about FRA - Fast Recovery Area, what is used for and how to configure it. 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: 3431 Ramkumar Swaminathan
Advanced SQL and the Power of Rewriting Queries
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’.
Identifying High Risk Oracle SQL Before The Upgrade - Seminar Intro
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: 163 OraPub, Inc.
Oracle Parallel Execution Plans Deep Dive
A presentation about understanding the essentials of Oracle Parallel Execution and how to read the corresponding execution plans
Views: 2937 Randolf Geist
Dates and Times in SQL
An introduction to working with dates and times in SQL Server.
Views: 531 Database by Doug
Relationships of Physical and Logical Storage structures in an Oracle Database - DBArch Video 22
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: 13266 Ramkumar Swaminathan
Statistics and Query Plans
If you want to tune queries, you have to look at query plans and you have to understand what they’re showing you. One thing people look for when tuning is “bad cardinality estimates”. If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session on statistics and query plans. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance issues. Expect lots of demos so you can truly understand what statistics are, how they're used, and why their management is so essential for good performance.
Views: 73 Sarah H
Using Skewed Oracle Performance Data To Your Advantage - Seminar Intro
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: 431 OraPub, Inc.
User and Schema - DbArch Video 33
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: 5179 Ramkumar Swaminathan
Solved! - Unable to modify table.   Execution Timeout Expired
'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: 2720 Maruti AIR Tech
Top Five Oracle Performance Tuning Tips - Introduction
Oracle performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will detail five steps to quickly identify performance issues and resolve them. So, what will you learn? How to quickly fine tune a SQL statement. How to identify performance inhibitors to help avoid future performance issues. And finally, how to recognize and understand how new Oracle features can change and/or support different execution plans. Awesome! For information on how you can watch the full webinar, or for more great Oracle education, go to www.oraoub.com
Views: 90 OraPub, Inc.
Analyzing and Troubleshooting Oracle Parallel Execution
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: 3441 Redgate Videos
How To Tell If There Is An Oracle OS Memory Shortage - Webinar
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: 93 OraPub, Inc.
4BS:.Anjiprasad....oracle network database links
4BS:- Anjiprasad..........oracle database links connect one database to other
How To Kill All Database Processes On SQL Server
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: 6585 Rohan Mehtha
Visual SQL Tuning
Views: 1723 kyle Hailey
ROWID - DBArch Video 32
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: 3586 Ramkumar Swaminathan
oracle parallelism
Views: 154 Fatma Aksu
SQL: Explain Plan for knowing the Query performance
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 97713 radhikaravikumar
What is an AWR Report? - DBPerf Video 17
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: 5398 Ramkumar Swaminathan
Connection Optimization and Pooling - Demonstration - DBArch Video 20
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: 4588 Ramkumar Swaminathan
SQL timeout expired. The timeout period elapsed prior to completion of the operation
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: 7664 Rohan Mehtha
Parallel SQL
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: 728 Lucidworks
The Optimum Histogram Utility DEMO 2- Maximize Oracle Performance and SQL Execution Efficiency
Description Demonstration of the influence of the Optimum Histogram utilities on the estimation accuracy of the Oracle Optimizer in a 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: 535 Doug Laughlin
Bad Connections and Bad SQL - DBPef Video 10
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: 1545 Ramkumar Swaminathan
Watch Oracle DB Session Activity With My Real-Time Session Sampler
Watch Oracle DB Session Activity With My Real-Time Session Sampler For details about this tool, I created a special posting in my blog, A Wider View. Have a look! http://blog.orapub.com/20140811/Watch-Oracle-DB-Session-Activity-With-The-Real-Time-Session-Sampler.html The rss.sql tool is included in the OraPub System Monitor (OSM) toolkit (v13j), which can be downloaded http://resources.orapub.com/OSM_OraPub_System_Monitor_p/osm.htm Watching session activity is a great way to diagnose and learn about Oracle Database tuning. There are many approaches to this. I wanted something simple, useful and modifiable. I wanted no Oracle licensing issues. And, I wanted something I could give away. The result is what I call the Oracle Real-Time Session Sampler (OSM: rss.sql). The tool is simple to use. Based on a number of filtering command line inputs, it repeatedly samples active Oracle sessions and writes the output to a file in /tmp. You can do a "tail -f" on the file to watch session activity in real time!
Views: 675 OraPub, Inc.
Using the TSQL DateDiff Function
A short tutorial (with demo) on using the T-SQL DateDiff function on Microsoft SQL Server.
Views: 1117 Steve Stedman
What is that one thing that can fix all performance issues - DBPerf Video 03
. 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: 2135 Ramkumar Swaminathan
Is it easy or difficult to deal with Database Performance?? - DBPerf Video 02
In this video you learn how to approach learning about Performance Management / Tuning... . 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: 2411 Ramkumar Swaminathan
Two Queue Or Not To Queue, That Is The Question - Seminar Intro
Two Queue Or Not To Queue, That Is The Question will help you tune Oracle systems faster and with a greater depth of understanding. The insights you gain provide both a tactical and strategic performance tuning advantage. From driving in traffic to being served at a restaurant, every person feels the impact of queuing theory. Queuing theory beautifully relates time and work into experiences we can feel; like utilization, workload intensity, response time, elapsed time, user experience and systems architecture design. Queuing theory can be well...theoretical! But Oracle ACE Director Craig Shallahamer turns this topic upside down making it a fantastic learning experience. For details go to http://www.orapub.com/video-seminar-to-queue-or-not For details on OraPub go to www.orapub.com Modules 1. Setting The Stage 2. You Can't Escape A Queuing Theory World 3. The Work And Time Relationship 4. Craig's Hamburger Stand - Definitions 5. Utilization Explored 6. Response Time Explored 7. Going Deeper Part 1 - CPU and IO Subsystems 8. Going Deeper Part 2 - Changing Parameter Values 9. How Queuing Theory Is Used By DBAs 10. Seminar Close What You Will Learn - How to tune Oracle systems faster by understanding queuing theory - How to merge queuing theory into Oracle database performance tuning - What truly is response time - How response time relates to workload intensity, utilization... user experience - How to explain a performance incident from a practical queuing theory perspective - How every person is immersed in a queuing theory world - How an Oracle time-based analysis intimately relates to queuing theory - Why increasing an Oracle workload can hurt performance - How to understand the classic response time curve - How the response time curve relates directly to SQL elapsed time - What are the key queuing theory parameters - Why performance slows when CPUs and IO devices get busy - How to get the busyness for your CPU and IO subsystem - How to calculate the CPU subsystem utilization from v$osstat - Why CPU and IO subsystems are different queuing systems - What happens when we tweak queueing theory input parameters - How is utilization and response time are affected by more or faster CPUs - How does adding more IO devices affect SQL statement elapsed time - How does queuing theory relate to a SQL statement's elapsed time - Why pushing more work through your Oracle system consumes more CPU and potentially more wait time - How can I determine the response time for a SQL statement - How queuing queuing theory relates to performance tuning - How queuing theory parameters relate to my Oracle database activity - How applying queuing theory focuses my performance tuning solutions - How queuing theory can be used in forecasting and predictive analysis - How can I tell if a performance solution is bogus using queuing theory - How can I pick better tuning solutions using queuing theory - How I can use my AWR or Statspack report from a queuing theory perspective
Views: 363 OraPub, Inc.
Funcionamento PARSE - ORACLE
Funcionamento hard parse e soft parse em uma instancia Oracle-- Created using PowToon -- Free sign up at http://www.powtoon.com/join -- Create animated videos and animated presentations for free. PowToon is a free tool that allows you to develop cool animated clips and animated presentations for your website, office meeting, sales pitch, nonprofit fundraiser, product launch, video resume, or anything else you could use an animated explainer video. PowToon's animation templates help you create animated presentations and animated explainer videos from scratch. Anyone can produce awesome animations quickly with PowToon, without the cost or hassle other professional animation services require.
Views: 355 DBA Maker
Introduction to AWR - DBPerf Video 16
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: 3697 Ramkumar Swaminathan
What is in your bowl ? - DBPerf Video 9
What is important is not how much resources you have... but what you do with your resources . 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: 1430 Ramkumar Swaminathan
DB2 10.1 - Time Travel Query
In this video, you will learn how you can use DB2 V10.1 Time Travel Query to: - Transparently keep a system history of all data changes using system data versioning. - Formulate simple queries that access data at any desired point in the past using a business data validity period. - Combine system history capabilities with point in time business queries using bitemporal data management.
Views: 3852 Clara Liu
ORA 00054  resource busy and acquire with NOWAIT specified
ORA 00054 resource busy and acquire with NOWAIT specified Find More details Here: http://oracletech2u.blogspot.com/2014/03/ora-00054-resource-busy-and-acquire.html
Views: 1136 oratech ahmed
Tuning Oracle Using An AWR Report - Seminar Intro
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: 17549 OraPub, Inc.
Hassan Chafi, Research Manager, Oracle Labs @ MLconf ATL
PGX: An In-Memory, Parallel Graph Analytic and Query Engine Brief Description: In-memory (and distributed) graph analytic engine that is tightly coupled with a relational database. Long Description/Abstract: We present a graph processing system in which a graph database is tightly integrated with a graph analytic engine. Our graph database, based on existing NoSQL and relational databases, provides scalable management of graph data for transactional workloads. Our graph analytic engine, on the other hand, enables rapid execution of analytic workloads. We first introduce PGX, our in-memory graph analytic engine which initially loads up the graph data from the database and periodically synchronizes afterward. The parallel execution engine of PGX is very efficient – e.g. counting triangles in billion-edge graphs in 2 minutes. The users can also submit their custom graph algorithms written in a domain-specific language; PGX automatically parallelizes them for execution. Then we introduce PGX.DIST, our distributed graph analytic engine. We show that PGX.DIST is up to orders of magnitude faster than the state-of-art graph analytic engine. The DSL compiler can help running the same algorithm on both PGX and PGX.DIST, transparently. * Graph database tightly integrated with graph analytic engine * Fast, parallel in-memory graph analytic engine * Distributed graph analytic engine * Use of Domain-Specific Language for graph analytics
Views: 616 MLconf