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
Demonstrating Oracle DB Elapsed Time and Wall Time With Parallel Query
 
03:37
From my blog posting: http://blog.orapub.com/20140907/Watch-Oracle-Database-Elapsed-Time-And-Wall-Time-With-Parallel-Query.html 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)
Views: 1124 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: 606 OraPub, Inc.
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: 88484 radhikaravikumar
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: 2439 Randolf Geist
Oracle 11g New Features : SQL Plan Management  (Baselining)
 
22:15
Oracle 11g SQL Plan Management, a.k.a. Baselining, will solve the major issues of change control. We can give you an absolute guarantee - if you configure this as part of your upgrade - that SQL statement execution (performance) will never regress. You may also like our new and free Oracle 12c video tutorials, https://www.skillbuilders.com/free-oracle-database-tutorials . This tutorial is particularly relevant: it provides a review of baselining then reveals 12c performance features https://www.skillbuilders.com/free-oracle-database-tutorials/oracle-12c-sql-performance-features-agenda-session/
Views: 10030 SkillBuilders
Funcionamento PARSE - ORACLE
 
02:21
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: 340 DBA Maker
ITSE 1345 Intro to Oracle SQL & PL/SQL
 
20:34
More than an introduction, this video serves as a refresher for the baseline knowledge necessary for this course...
Views: 127 Chris Burns
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: 195 Oracle Developers
What is DB Time - DBPerf Video 12
 
03:56
In this video you will understand what is DB TIme in an Oracle Database.
Back to the Future: Oracle SQL Performance Firefighting using AWR with Karen Morton
 
59:27
Download the presentation slides, code samples, and a free download of DB Optimizer at http://embt.co/1M7vSe6 Most of us have been in the situation where, for no apparent reason, performance for key SQL takes a nose-dive after having previously performed well. So, how do you handle this situation and stabilize performance back to acceptable levels? One approach is to go back in time using execution data stored in AWR. In many cases, AWR may contain what you need to revert your problem SQL to a better performing alternative.
Oracle Troubleshooting Guide
 
09:44
https://ora-data.blogspot.in/2017/07/oracle-troubleshooting-tips.html Oracle DBA troubleshooting is very important and advance for DBA’s life. We all should know and understand the troubleshooting ways. Here we have some points and the ways which can be helpful in troubleshooting. One thing I would like to share here that troubleshooting is not a rocket science but people make it like a rocket science hehehh. Even if rocket science also we can do it friends. Friends, please just try once and follows these below points. I am sure it will be very useful. There are many more points technical but I tried to explain in very simple ways to kick start. As per my experiences I have seen some people feel as troubleshooting is either hard or they afraid. WHY TROUBLESHOOTING IS HARD: 1. You feel as you can’t do it even without any try. Already they have mindset. 2. You think it will take time but it takes time for everyone. You know one SECRET, no one know everything, even seniors also check in metalink or google. Only one thing is different i.e. Observations as per experiences. Otherwise everything is same. Whatever we/they do, you can also do. 3. You afraid about mistakes but we need to try on test server which everyone does it. Never give up. Today if you try for 1 hr and got solution, tomorrow you will be king of it. If you do not get solution in 1 hr, take it as challenge and try till get the solution. Every one learns like this only. Simple Steps to START TROUBLESHOOTING: 1. You must Read error carefully. 2. Must check alert logs accordingly. 3. Check for related error either in Metalink or Google. 4. Understand or observe the error 100%. Do not be hurry in investigations. After checking Metalink or Google, never do hurry to execute solution. First understand the solution 100% thoroughly. Check what is required in the given solution. Some Important Suggestions: For Example: Suppose, there is given any “rm” command in solution. As per my DBA experiences never ever use “rm or rm –rf” command. If required check 7 times before using this command. Actually I forget this command; I don’t know “rm or rm-rf” command hehehh. If it is very necessary, then take the backup of file and then remove. Before executing solution check for any SQL DML command or any other SQL SCRIPTS statements which can impact like DML or any Transactional etc… And if you are not sure then check on test servers and check with your seniors. I guarantee that just follow these simple above steps. You will see yourself changes. If any more suggestions, I will keep update here. And also if you have any more points please let us know which will be helpful for all of us.
Views: 709 ORACLE SUPPORT
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: 5000 Rohan Mehtha
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: 10 OraPub, Inc.
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: 413 OraPub, Inc.
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.
Visual SQL Tuning
 
39:04
Views: 1621 kyle Hailey
PL/SQL 1 - PL SQL environment and variables.
 
05:20
https://drive.google.com/file/d/0BxYoN5rLDBaRSGlZYnI3eHZjQzA/edit?usp=sharing Course objective SQL - PL / SQL: what's the difference? Environment PL / SQL Benefits of PL / SQL Features PL / SQL PL / SQL and then? Example 1 Declare --Optional /* Variables, constants, cursors*/ Begin --Mandatory /* Statements PL/SQL Clauses PL/SQL*/ null; Exception --Optional /*Actions to be performed when an exception is thrown or when an abnormal termination occurred*/ when others then null; End; --Mandatory ----------------------------------- Example 2 set serveroutput on ; BEGIN dbms_output.put_line('Hello World') ; END ; ------------------------------------------------ Example 3 SET SERVEROUTPUT ON DECLARE v_pls_value1 PLS_INTEGER := 0; v_pls_value2 PLS_INTEGER := 1; v_simple_value1 SIMPLE_INTEGER := 0; v_simple_value2 SIMPLE_INTEGER := 1; v_start_time NUMBER; v_end_time NUMBER; BEGIN v_start_time := DBMS_UTILITY.GET_TIME; FOR i in 1..50000000 LOOP v_pls_value1 := v_pls_value1 + v_pls_value2; END LOOP; v_end_time := DBMS_UTILITY.GET_TIME; DBMS_OUTPUT.PUT_LINE ('Elapsed time for PLS_INTEGER: '|| (v_end_time - v_start_time)); v_start_time := DBMS_UTILITY.GET_TIME; FOR i in 1..50000000 LOOP v_simple_value1 := v_simple_value1 + v_simple_value2; END LOOP; v_end_time := DBMS_UTILITY.GET_TIME; DBMS_OUTPUT.PUT_LINE ('Elapsed time for SIMPLE_INTEGER: '|| (v_end_time - v_start_time)); END; ------------------------------------------------ Example 4 DECLARE TYPE client_t IS RECORD ( numero_v NUMBER(4), nom_v CHAR(20), adresse_v CHAR(20) ) ; client1_v client_t ; BEGIN client1_v.numero_v := 2516 ; dbms_output.put_line(client1_v.numero_v); END ;
Views: 1501 Fdo Luis
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.
Views: 2515 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.
Views: 1009 Ramkumar Swaminathan
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.
Views: 1821 Ramkumar Swaminathan
Identifying High Risk 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: 149 OraPub, Inc.
Oracle "Waiting"
 
04:58
Oracle - Waiting - sur l'album "Tree" (1993)
Views: 276 fidale rebbec
Parameters for Archiving in an Oracle database - Backup&Reco Video 7
 
09:39
In this video you will learn about the various parameters available to configure archiving of redo log files in an Oracle Database.
Views: 1930 Ramkumar Swaminathan
Detailing Oracle CPU Consumption: The Missing Link (Intro)
 
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
Views: 1639 OraPub, Inc.
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: 527 Doug Laughlin
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.
Views: 1157 Ramkumar Swaminathan
Two Queue Or Not To Queue, That Is The Question - Seminar Intro
 
10:26
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: 334 OraPub, Inc.
Introduction to AWR - DBPerf Video 16
 
05:27
In this video you will understand what are V$ views and whats in the AWR
Views: 2127 Ramkumar Swaminathan
SQL Developer Password Reset
 
01:42
Get the complete OBIEE 12c Data Modeling course at https://www.udemy.com/obiee-12c-data-modeling-course/?couponCode=SANRUSHA11
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’.
Read Consistency - Transaction Level - DBArch Video 27
 
04:54
In this video you will learn about the Various levels of Isolation supported by Oracle Database. You will understand at a Transaction Level what are the options available for Read Consistency or Isolation
Views: 1685 Ramkumar Swaminathan
Watch Oracle DB Session Activity With My Real-Time Session Sampler
 
02:41
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: 647 OraPub, Inc.
Curso de Oracle (Tuning) 03 - STATSPACK, UTLBSTAT e UTLESTAT
 
16:28
Curso Oracle PL/SQL Essentials http://bit.ly/1N3upVn Curso Oracle SQL Expert - Certificação 1Z0-047 http://bit.ly/1G4rKWG Curso Oracle Aprendendo SQL - Preparatório exames 1Z0-051/1Z0-061 http://bit.ly/1eqDlsr Curso de Administração de Redes de Computadores http://goo.gl/nXjaXS Neste curso de Tuning no Oracle você irá aprender os principais conceitos de tuning no oracle melhorando consideravelmente as aplicações em ambientes de produção. No Curso de Tuning no Oracle você será direcionado passo a passo durante o aprendizado com ótima qualidade do conteúdo disponibilizado. Este curso é oferecido gratuitamente aqui porém caso tenha interesse em se aprofundar e aprender o oracle a fundo praparando para certificação acesse os links acima. Também acesse o link de administração de redes de computadores para mais conhecimento nesta área tornando-se um profissional completo. http://youtu.be/PERjxUGhRUA Tags: Oracle Curso de Oracle Curso de banco de dados Tuning Cursos gratuitos
Views: 1172 Cursos Interativos
Bad Connections and Bad SQL - DBPef Video 10
 
04:45
You will learn about the top 2 resource hoggers in an Oracle Database...
Read Consistency - Statement Level - DBArch Video 25
 
06:02
In this video you will understand how Statement Level Read consistency is provided by Oracle Database. We shall take some interesting examples to explore how Oracle database implements read consistency at a statement level.
Views: 1860 Ramkumar Swaminathan
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.
Views: 2299 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: 507 OraPub, Inc.
Database Performance  - Introduction - DBPerf Video 01
 
03:03
In this video you will understand how to approach Database Performance Management
Views: 2312 Ramkumar Swaminathan
Bryn Llewellyn - Ten Rules for Doing a PL/SQL Performance Experiment
 
49:15
I’m often asked to comment on a speed difference between two PL/SQL tests. Usually, the tests are presented as SQL*Plus spool files, whose differs in just a couple of tiny details. The times are measured, for just a single test run, using SET TIMING ON and are shown like “Elapsed: 00:00:02.36”, with indefensible precision. Sometimes the times are shorter. This is no way to conduct a performance experiment! This session tells you how to do your experiment properly with reference to a real, and interesting, case study. Though the title says “PL/SQL” the method described applies to any single-user test that runs entirely inside Oracle Database. I said “ten rules” to get your attention. Of course, there are actually rather more rules.
Views: 31 Riga Dev Days
IDUG Tech Talk: How We Code SQL - Does It Matter?
 
51:52
Presented by Jacek Rafalak, ASSECO POLAND SA This presentation would be based on application developer experiences with coding efficient SQL. Introduction to basic concepts on how data can be accessed, what is Indexable , stage1, stage2, boolean term predicates. There will be examples of re-writing queries according to few rules of thumb so it execute more efficiently, What SQL to use, what trying to avoid, how you can influence access path with adding extra predicates, with special 'tricks', etc. This joined presentation with IBM, will also mention how DB2 can do query rewrite for you. With focus on V10 and V11 query re-write possibility: V10: How DB2 modifies IN predicates, simplification of join operations, removal of pre-evaluated predicates, predicates that DB2 generates and predicates generated through transitive closure V11 - How DB2 11 simplify YEAR(col), DATE(col), and SUBSTR(col,1,len) Simplify stage 2 BETWEEN predicate Improve indexability of CASE expression predicate Simplify always true or always false predicate Enhance correlated to non-correlated subquery transformation Predicate push-down enhancement Jacek Rafalak has 16 years' experience working with DB2 on the mainframe platform, database administration and software support. Since 2001 he has worked for DB2 for z/OS Center of Competency and Operation of Systems for Social Security (KSI) in Standard Environments Maintenance Team in Warsaw, Poland at Asseco Poland SA. He is responsibile for DB2 for z/OS Utilities and applications performance. IBM Certified Database Administrator DB2 z/OS. IBM Champion for Information Management. Poland DB2 Users Group leader.
Real-World Performance - 8 - Set Based Parallel Processing
 
10:39
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 demonstrates how set based parallel processing 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.
Export and Import - Backup&Reco Video 9
 
04:20
In this video you will understand about the Export and Import utilities in Oracle Database
Oracle Database LGWR Three Second Rule. Really?
 
03:12
Go to the blog posting: http://blog.orapub.com/20140608/The-Oracle-Database-LGWR-Three-Second-Rule-Really.html I have learned the part of Oracle Database performance tuning is checking if what you have been taught is actually true. What I'm writing about today has been done before in Oracle Database 10g and 11g, but I wanted to document this using 12c. When I was first learning about the Oracle Database process architecture, the instructor said there are a number of reasons the log writer (LGWR) background process will wake up and do "something." In addition to this, if the LGWR was not signaled to wake up, every three seconds it would wake up by itself and check if there was something it needed to do. Is this "three second rule" really true? That's what this posting is all about.
Views: 586 OraPub, Inc.
DB2 Optimization, Performance and Tuning by Themis Education
 
08:04
A few minutes of the Themis course "DB2 for z/OS Optimization, Performance and Tuning" presented by Tony Andrews. Produced by Curl Films. http://www.themisinc.com/CourseDetail.aspx?id=DB1032 http://www.curlfilms.com
Views: 12825 Themis Education
Structure of a Row - DBArch Video 30
 
03:53
In this video you will learn how a Row is structured. You will learn about its header and column data sections.
Views: 1393 Ramkumar Swaminathan
How to Download  & Install Microsoft SQL Server Migration Assistant v6.0 for Oracle
 
26:16
Microsoft SQL Server Migration Assistant v6.0 for Oracle 2016 update ssma for oracle
Views: 208 C Plus+
How to fix Timeout expired. The timeout period elapsed prior to completion of the operation
 
03:36
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. c# - Timeout expired How to remove Timeout expired coding in c# public void CreateSqlCommand() bracket open SqlCommand command = new SqlCommand(); command.CommandTimeout = 50; command.CommandType = CommandType.Text; bracket close How to fix Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
Views: 51644 HINDUSTAN RELIGION