Home
Search results “Locking and latching oracle”
SCPT 41: Types of Locks and Latches in Oracle
 
07:11
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 21364 Oresoft LWC
Oracle Database Memory Serialization Control (latches & mutexes)
 
14:14
Oracle Database Memory Serialization Control (latches & mutexes) teaches Oracle DBAs the ends and outs about Oracle memory structure control. Oracle effectively creates the illusion of simultaneous memory structure manipulation. And it's our job to ensure this illusion remains a mystery to our users. To help you keep this illusion real, in this seminar I will lead you into the mysterious world of Oracle memory structure serialization control by exploring latches and mutexes: what they are, how they work, how we monitor their performance, how we tell if there is a significant problem and how we systematically diagnose the situation. I think you will soon understand why I think Oracle serialization control rocks! For details go to http://www.orapub.com/video-seminar-serialization-control PART ONE of this seminar focuses on why latches and mutexes are so important to Oracle's operations and how Oracle uses latches and mutexes in its kernel code. I also dig into how Oracle's time model relates to latching. This enables you to properly diagnosis and communicate to others why or why not latches/mutexes are a significant performance issue. Finally, I get into how Oracle increases concurrency by effectively using multiple latches of the same type to increase memory structure concurrency. It's fascinating and very important for DBAs who want to pursue a career focused on Oracle performance tuning. PART TWO begins by focusing on advanced latch spin control and detailing three ways to identify the problem latch. Then I'll begin digging deep into mutexes, including why they are important, why Oracle began using them and the acquisition algorithm. I'll even get into advanced mutex control using Oracle instance parameters. We will observe Oracle using mutexes by operating system tracing Oracle processes. It's pretty cool and key for any DBA who wants to become a performance expert. What You Will Learn In Part 1 & 2 - Why Oracle processes must ensure serial access control to Oracle memory structures - What are Oracle latches and mutexes - How Oracle latches are different from mutexes - The latch and mutex acquisition algorithms - How L&M activity relates to Oracle's time model - How to monitor for real L&M problems using Oracle's time model and an AWR report - Steps to methodically approach diagnosing and coming up with performance solutions - The differences between latches and mutexes - How Oracle implement mutexes in its library cache - How to use advanced latch spin control - What options DBAs have to influence mutex behavior L&M = Latches And Mutexes Modules Part 1: 060 Oracle Serialization Control - Part 1 1. Why the simultaneous memory structure illusion must exist and why it works so well 2 Oracle processes, L&M and memory structures, the general L&M acquisition algorithm 3 L&M time accounting and how this relates to the Oracle time model and the AWR report 4. Oracle latch specifics: concurrency limitations, child latches, multiple latches and how latches "back off." Part 2: 062 Oracle Serializatoin Control - Part 2 1. Using latch specific spin count control to your advantage and three ways to identify the problem latch 2. Why mutexes are advantageous to increase concurrency 3. Detailing the Oracle mutex algorithm 4. Advanced mutex control and observering Oracle mutex usage in detail For more information to go www.orapub.com
Views: 2868 OraPub, Inc.
04 03 Contention and Latch Waits
 
10:08
ORACLE
Views: 396 oracle ocm
Understanding and Optimizing Oracle Latches/Mutexes - Webinar
 
01:04:39
Understanding and Optimizing Oracle Latches/Mutexes. Oracle memory serialization control is core to Oracle database operations. One of the most fascinating topics in Oracle internals and performance optimization is memory serialization. We will look at the circumstances in which serialization is used, how it works, how to influence its operation, and how to diagnose problems. It's a complex situation; in order to get the upper hand on serialization control, this presentation will explore the lock (a little), the latch (a lot), and the mutex (a whole lot). Topics will include: performance diagnosis, how Oracle implements latches and mutexes, and related internal algorithms. Special attention will be given to the library cache mutex operations. This is a practical, yet deep internals presentation filled with amazing discoveries about how Oracle works. For more information go to www.orapub.com
Views: 412 OraPub, Inc.
Oracle Locks Explained Part 1
 
12:02
Oracle Locks explained. How to Kill a User session in oracle database- Neway IT Solutions
Views: 2245 NewayITSolutions LLC
Troubleshooting a Complex Oracle Performance Issue
 
01:28:00
In this session Tanel will walk you through troubleshooting a yet another complex performance issue that he has faced in past. Again, the initial symptoms point to a different direction than the actual root cause, so a systematic approach was needed.
Views: 4147 Tanel Poder
Mutex Lock
 
01:18
This video is part of the Udacity course "GT - Refresher - Advanced OS". Watch the full course at https://www.udacity.com/course/ud098
Views: 30618 Udacity
Latches
 
13:03
Latches in Oracle
Views: 668 Hemant K Chitale
19mm LED latching switch wiring
 
06:19
How to wire a halo ring LED light latch switch. Also known as an angel eye led switch. I couldn't find a good tutorial online so I decided to put one up. Link to switch https://ebay.to/2GVYyK0 Diagram here: http://www.velocity-laboratories.com/?p=126 Stuff I need for production! http://a.co/iM4PGFF http://s21.postimg.org/6ukq4uso7/22mm.jpg http://www.tomshardware.com/answers/id-1728604/wiring-setup-blue-led-22mm-12v-stainless-steel-switch-momentary-push-button.html
Views: 126638 Velocity Labs
Understanding And Resolving Oracle CBC Wait/Latch Contention - Introduction
 
07:10
Understanding And Resolving Oracle CBC Wait/Latch Contention When a server process needs to access a buffer it must access the cache buffer chain (CBC) structure to determine if the buffer is already in the buffer cache. With just the right workload mix, performance can be a problem. Learning about the relevant Oracle internals and how to diagnose and solve CBC performance problems is what this seminar is all about. For more information go to www.orapub.com
Views: 1105 OraPub, Inc.
SCPT 41 : Types of Locks and Latches in Oracle
 
07:11
latches and enqueues are both types of locks. latches are lightweight serialization devices. enqueues are heavyweight serialization devices. A semaphore is an operating system supplied serialization device that one might use to implemented latching or enqueues.
How an intense and diverse SQL statement workload can cause Oracle parsing problems
 
09:19
Make your library cache angry! This video is about how an intense and diverse SQL statement workload can cause Oracle parsing problems. There are many reasons for Oracle parsing related performance issues and many ways to identify them. So, I am narrowing the scope by focusing on one possible cause, that is, an intense and diverse SQL statement workload. I will use Oracle's wait interface to identify the root cause. Sound dry and boring? To make this a little more interesting and a whole lot more fun, I'm going to approach this from a non-traditional, almost backward perspective. After explaining some of the Oracle internals, I'm going to create a parsing intensive workload and then watch what happens... in real time. The educational impact is so powerful, I recorded a video This is video is part of Craig's blog post: http://blog.orapub.com/20170126/how-an-intense-and-diverse-sql-workload-causes-oracle-parsing-problems.html For more information go to www.orapub.com
Views: 295 OraPub, Inc.
What are Latches
 
06:47
Latch Overview
Views: 4113 Mike
Understanding And Resolving Oracle Free Buffer Wait Contention - Seminar Intro
 
06:19
This is the introduction to my video seminar, Understanding And Resolving Oracle Free Buffer Wait Contention. Free buffer waits is one of the most feared of all Oracle wait events. It requires just the right workload mix and configuration to appear. When it does appear, it affects the entire application. As Oracle DBAs, our job is to regain control of the situation and restore application performance. But it is complicated and making the wrong move can make the situation even worse! So, how do you quickly improve performance with a clear understanding of the situation? That's the focus of this seminar. This seminar is designed to take you on a journey. The journey starts with Craig clearly explaining what a free buffer wait is. Then he delves into Oracle's buffer cache, focusing on the least recently used (LRU) lists and the associated algorithms. Craig even role plays as an Oracle foreground process and an Oracle buffer header, locking the details into your brain. Now the details brought together making the cause and effect clear so the presented solutions make perfect sense! Taking it further, two solutions are implemented and the results analyzed. Join Oracle ACE Director Craig Shallahamer as he take you on an unforgettable journey into the Oracle buffer cache zeroing in on understanding and resolving Oracle free buffer waits. For details go to http://www.orapub.com/video-seminar-understanding-eliminating-oracle-free-buffer-waits For more information about OraPub go to www.orapub.com
Views: 1334 OraPub, Inc.
How to CAUSE Oracle free buffer waits
 
06:33
This is a snippet from my online video seminar, Understanding And Resolving Oracle Free Buffer Wait Contention. Check it out here: http://www.orapub.com/video-seminar-understanding-eliminating-oracle-free-buffer-waits
Views: 1093 OraPub, Inc.
L06 - Index Locking & Latching [CMU Database Systems Spring 2017]
 
01:06:52
Slides PDF: http://15721.courses.cs.cmu.edu/spring2017/slides/06-latching.pdf Reading List: http://15721.courses.cs.cmu.edu/spring2017/schedule.html#feb-02-2017 Andy Pavlo (http://www.cs.cmu.edu/~pavlo/) 15-721 Database Systems (Spring 2017) Carnegie Mellon University
Views: 1263 CMU Database Group
Lunch n Learn   Important Oracle Wait Events
 
09:56
Oracle Wait Events DB File Scattered Read and DB FIle Sequential Read...tips and techniques...
Views: 5031 Dan Hotka
PL/SQL: Locks
 
08:43
In this tutorial, you'll learn the types of locks & how locks occurs while executing a query.
Views: 8244 radhikaravikumar
Oracle Midlands #13: All About Table Locks - Franck Pachot
 
54:41
Timestamps: 0:45 - Basics 5:03 - TX lock demo 9:30 - TM lock info 21:04 - Foreign key index demo 28:48 - 10g, 11g, 12c locking differences 41:50 - New online operations in 12c 46:26 - Event 10704 trace 50:34 - Deadlock demo 53:42 - Q&A Franck discusses different types of locking scenarios to consider with your systems. The slides are available at: Google: https://drive.google.com/folderview?id=0B0DLaAfeW6uKZmJ3TXE0WGtLYlE Dropbox: https://www.dropbox.com/sh/9koxoemak8ts7j6/AADozVVYLoK_FdDZbQGC6TYta This event was sponsored by Red Stack Technology (http://redstacktechnology.com/). See more events at http://OracleMidlands.com/ Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. "Fair Dealing" under UK Copyright, Designs and Patents Act 1988.
Views: 823 Oracle Midlands
CMU Advanced Database Systems - 06 Index Locking & Latching (Spring 2019)
 
01:19:47
Slides PDF: https://15721.courses.cs.cmu.edu/spring2019/slides/06-indexes.pdf Reading List: https://15721.courses.cs.cmu.edu/spring2019/schedule.html#feb-04-2019 Prof. Andy Pavlo (http://www.cs.cmu.edu/~pavlo/) 15-721 Advanced Database Systems (Spring 2019) Carnegie Mellon University https://15721.courses.cs.cmu.edu/spring2019/
Views: 534 CMU Database Group
How to manager Oracle database locks and deadlocks with Oracle Enterprise Manager 12C
 
02:21
Video tutorials on How to manager Oracle database locks and deadlocks with Oracle Enterprise Manager 12C For more Database Administration articles and scripts go to www.aodba.com & www.verticablog.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 3452 AO DBA
0608 How to Resolve Lock Conflicts
 
00:57
ORACLE
Views: 101 oracle ocm
Parallel Execution In an Oracle RAC environment
 
03:14
In an Oracle RAC environment, a SQL statement executed in parallel can run across all of the nodes in the cluster. For more information please visit https://www.koenig-solutions.com/oracle-database-12c-rac-administration-training.aspx
Views: 53 Koenig Solutions
DBMS - Latches
 
01:42
DBMS - Latches Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited
How to find Oracle Database locked session using Oracle Enterprise Manager 12C
 
02:09
Video tutorial on how to find Oracle Database locked session using Oracle Enterprise Manager 12C. For more Database Administration articles and scripts go to www.aodba.com & www.verticablog.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 5290 AO DBA
What is enq TX row lock contention
 
00:09
What is enq TX row lock contention Find More details Here: http://oracletech2u.blogspot.com/2014/03/what-is-enq-tx-row-lock-contention.html
Views: 233 oratech ahmed
SQL Server Interview | What is Latch, What is the difference between Latch and Lock in SQL Server
 
01:42
SQL Server DBA interview Question "What is Latch? What is the difference between Latch and Lock in SQL Server" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 8954 TechBrothersIT
Inside SQL Server Latches - Bob Ward
 
01:25:24
The SQL Server database engine uses latches for internal synchronization to critical operations. So why would you care about what a latch is? Well, if you have ever monitored a SQL Server closely, you know you can't escape latches. Come to this advanced session exploring the internals of how SQL Server uses the concept of latches for synchronization of key internal data structures. This talk is a very advanced "500" session that may include the use of advanced diagnostics such the Windows debugger and discussion of Windows APIs. I will assume the audience has a basic working knowledge of the SQL Server engine including an understanding of some of the more common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests and sys.dm_os_wait_stats.
Views: 2961 PASStv
Types of locks.mp4
 
01:50
Views: 52 Kelsey Nash
How to install AeroCatch hood pins.
 
17:03
Hey guys, in this video I step you through installing some AeroCatch (120-2000) hood pins. Set aside about 4-8 hours depending on your tooling for the install, a bit longer if you let the paint cure. Overall not really difficult but more challenging than regular hood pins for sure. AeroCatch 120-2000 flush Hood latch and pin kit. http://amzn.to/2EOtEFP Waves by LAKEY INSPIRED https://soundcloud.com/lakeyinspired Creative Commons — Attribution-ShareAlike 3.0 Unported— CC BY-SA 3.0 http://creativecommons.org/licenses/b... Music provided by Music for Creators https://youtu.be/5CXlD4dD7ck Wonder by LAKEY INSPIRED https://soundcloud.com/lakeyinspired Creative Commons — Attribution-ShareAlike 3.0 Unported— CC BY-SA 3.0 http://creativecommons.org/licenses/b... Music provided by Music for Creators https://youtu.be/cQYojPnI3s0 Good Morning by LAKEY INSPIRED https://soundcloud.com/lakeyinspired Creative Commons — Attribution-ShareAlike 3.0 Unported— CC BY-SA 3.0 http://creativecommons.org/licenses/b... Music provided by Music for Creators https://youtu.be/RH1gC45vlMc
Views: 21618 Cody Yankey
2015 05 04 11 19 Oracle Wait Events   The Good Bad Ugly
 
12:24
May is Oracle Wait Events Month. This video covers the background and basics of what Oracle Wait Events are. I also cover how to get more information
Views: 848 Dan Hotka
Understanding Locking Resources in Sql server   Part 1
 
05:00
There are resources in sql server on which locks can be placed. Please watch complete video for more detail
Views: 1641 SqlIsEasy
Test: Library Cache Pin during recompile stored procedure
 
04:37
SELECT sys_context('USERENV', 'SID') FROM dual; set lines 130 set pages 1000 SELECT substr(DECODE(o.kglobtyp, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13, 'CLASS'),1,15) "TYPE", substr(o.kglnaown,1,30) "OWNER", substr(o.kglnaobj,1,30) "NAME", s.indx "SID", s.ksuseser "SERIAL" FROM sys.X$KGLOB o, sys.X$KGLPN p, sys.X$KSUSE s WHERE o.inst_id = USERENV('Instance') AND p.inst_id = USERENV('Instance') AND s.inst_id = USERENV('Instance') AND o.kglhdpmd = 2 AND o.kglobtyp IN (7, 8, 9, 12, 13) AND p.kglpnhdl = o.kglhdadr AND s.addr = p.kglpnses ORDER BY 1, 2, 3 ; http://surachartopun.com/2008/12/recompiled-stored-procedure-library.html
Views: 873 Surachart Opun
Oracle Wait Events  (From  Performance Tuning Training Videos)
 
02:38
Small excerpt from "Oracle performance Tuning-DBA Track" Course. http://www.dbvidya.com/course/performance-tuning-for-dba/ [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: 491 DbVidya
ORACLE Lighting - How To Install A 12V In-Line On/Off Switch for LED Lights
 
02:19
ORACLE LED Lighting can be one of the simplest, yet striking ways to upgrade your. car. But, no matter what 12V products you choose to install, there's going to be some wiring necessary. Today, we're going to look at the simple process of installing an in-line switch to turn the power on and off your ORACLE LED Lights. This video was created to help our customers understand the basics of wiring and their options when installing our products. NOTE - ORACLE ColorShift products will still require the correct remote. This video simply describes how to disrupt power between the battery and the LEDs. For more information, check out our complete line-up of Remotes and Switches here: www.oraclelights.com/collections/oracle-remotes-and-switches
Views: 602 ORACLE Lighting
Lock Modes - Locks in SQL Server - Part 2
 
04:01
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg The Microsoft SQL Server Database Engine locks resources using different lock modes that determine how the resources can be accessed by concurrent transactions. There are more than 20 types of Lock modes in SQL Server. Here we list out Most Important lock modes.
Views: 523 IT Port
Lock Modes - Locks in SQL Server - Part 2 Tamil
 
04:30
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg The Microsoft SQL Server Database Engine locks resources using different lock modes that determine how the resources can be accessed by concurrent transactions. There are more than 20 types of Lock modes in SQL Server. Here we list out Most Important lock modes. Explained in Tamil
Views: 211 IT Port
Gun lock demonstration - semi-automatic rifle
 
01:16
Demonstration by Ramsey County Sheriff's Office of how to install a cable gun lock on a semi-automatic rifle. Ramsey County is providing free cable locks while supplies last. Learn more at www.ramseycounty.us/gun-safety
Views: 19152 Ramsey County
Oracle Database - Relocate the AUD$ 30 Sec Tip #2
 
01:52
Oracle Database - Best Practice: Relocate the AUD$ (Audit_Trail) outside the system tablespace. *****Email [email protected] for step-by-step example and to schedule a free health assessment of your Oracle environment - including solutions - No strings attached. Jeff Dean Oracle DBA samara-tech.com
Views: 150 SamaraTech LLC.
09 06 Monitoring Index Usage
 
04:27
ORACLE
Views: 141 oracle ocm
the difference between latching pushbutton and momentary pushbutton
 
00:18
1st switch is latching function, also called self-locking, push to switch on, push again to switch off. 2nd is momentary function, also called resettable, push and hold to switch on, release to switch off.
Views: 351 Michael Li
What is a sub-query Oracle Database
 
00:45
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Jeep Wrangler Barricade Locking Fuel Door - Textured Black (2007-2016 JK) Review & Install
 
02:08
Shop Locking Fuel Door: http://terrain.jp/2inPFLl Subscribe for New Jeep Videos Daily: http://terrain.jp/SubscribeXTyt Upgrade your stock Wrangler fuel door with the Barricade Locking Fuel Door. This fuel door will ensure that the safety of your fuel cap and make sure that your fuel is under full protection. http://www.extremeterrain.com/barricade-locking-fuel-door-jk-j100725.html If you want to upgrade the look of your Jeep, plus guard against siphoning or vandalism, this Locking Fuel Door is great. It has a look that matches other mods, plus the stock components on the outside of your rig. You can install this Barricade Locking Fuel Door on any 2007-2016 Wrangler JK. It comes with a three-year manufacturer's warranty, plus two keys, just in case you lose one. Barricade uses a lightweight yet strong aluminum to make this part. As a result, you don't have to worry about corrosion or damage from debris flying around on the trail. The wrinkle black finish withstands exposure to the elements. Installation is pretty simple, although you do need to do some drilling and have a torpedo level on hand. You can have this job squared away in under half an hour, making it one of the easier modifications to do on your Jeep. Item # J100725 ---------------------------------------------------------------- Give ExtremeTerrain a follow for the latest Jeep Wrangler news, videos, pictures and content! SUBSCRIBE at http://www.youtube.com/extremeterrainvideos Facebook: http://www.facebook.com/extremeterrain Twitter: http://www.twitter.com/extremeterrain Google+: http://www.google.com/+extremeterrain Instagram: http://www.instagram.com/extremeterrain ExtremeTerrain.com is your off-road outfitters! We strive to carry a giant selection of aftermarket Jeep parts for Jeep Wranglers who like to hit the trail, the beach, cruise, crawl or go off-road. We carry a full line of off-road lights, accessories, lift kits, body armor, wheels, tires and more! With FREE Shipping on orders over $75 and the best customer service in the industry, we have you covered when it comes to any JK, TJ or YJ Jeep Wrangler. Make sure to chat with one of our Jeep Experts if you have any questions or want help planning your Jeep Project or Jeep Build! http://www.extremeterrain.com
Views: 20347 ExtremeTerrain.com
Oracle Sessions Monitoring and Tuning Fundamentals 2 of 4
 
55:56
In this tutorial you will learn how to monitor locks, latches, wait events in oracle.
Views: 1251 DBA Pro
Jeep Wrangler JK power door lock install. Video 3 of 4
 
10:45
2017 wrangler install of avital 2101L
Views: 1728 MrHillbilly1962
Intent - Locks in SQL Server - Part 6
 
06:10
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg The Database Engine uses intent locks to protect placing a shared (S) lock or exclusive (X) lock on a resource lower in the lock hierarchy. Intent locks are named intent locks because they are acquired before a lock at the lower level, and therefore signal intent to place locks at a lower level. Intent locks serve two purposes: --------------------------------------------------- a) To prevent other transactions from modifying the higher-level resource in a way that would invalidate the lock at the lower level. b) To improve the efficiency of the Database Engine in detecting lock conflicts at the higher level of granularity. if a transaction has an exclusive lock on a row, SQL Server places an intent lock on the table. When another transaction requests a lock on a row in the table, SQL Server knows to check the rows to see if they have locks. If a table does not have intent lock, it can issue the requested lock without checking each row for a lock Isolation Level - https://youtu.be/ESET4zuNLoM Script for Active_Locks Function --------------------------------------------------- Create Function Active_locks () returns table return select Top 10000000 case dtl.request_session_id when -2 then 'orphaned distributed transaction' when -3 then 'deferred recovery transaction' else dtl.request_session_id end as spid, db_name(dtl.resource_database_id) as databasename, so.name as lockedobjectname, dtl.resource_type as lockedresource, dtl.request_mode as locktype, es.login_name as loginname, es.host_name as hostname, case tst.is_user_transaction when 0 then 'system transaction' when 1 then 'user transaction' end as user_or_system_transaction, at.name as transactionname, dtl.request_status from sys.dm_tran_locks dtl join sys.partitions sp on sp.hobt_id = dtl.resource_associated_entity_id join sys.objects so on so.object_id = sp.object_id join sys.dm_exec_sessions es on es.session_id = dtl.request_session_id join sys.dm_tran_session_transactions tst on es.session_id = tst.session_id join sys.dm_tran_active_transactions at on tst.transaction_id = at.transaction_id join sys.dm_exec_connections ec on ec.session_id = es.session_id cross apply sys.dm_exec_sql_text(ec.most_recent_sql_handle) as st where resource_database_id = db_id() order by dtl.request_session_id
Views: 768 IT Port

Rithvik and asha dance video
Apple logic dance music
Sereshka russian blues music
Pop music history puzzles
Thai instrumental music playlist