Home
Search results “Find oracle locked objects”
How to Get locked Objects in SQL Server
 
08:38
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Generally, There are two ways to get what are the objects are Locked. First way with SP_LOCK, We can get the Locked Object details in a Particular Session Or SQL Server Engine. Second way is Used with DMV, Sys.dm_trans_lock it returns the Locked Objects with Some more data's when compared to SP_LOCK. Both are explained with Simplest Example in this Video. To Get Locked Objects ----------------------------------- Select S2.host_name, S1.Resource_type, (Case when S1.resource_type IN ('RID', 'PAGE') then s5.name when S1.resource_type IN ('DATABASE') then s6.name else S4.Name end) Name, S1.resource_associated_entity_id, S1.request_mode, S1.request_type, S1.request_status, S1.request_session_id, ISNULL(S3.rows , 0) Rows From Sys.dm_tran_locks S1 Inner join Sys.dm_exec_sessions S2 on S1.request_session_id = S2.session_id left join sys.partitions S3 on S1.resource_associated_entity_id = S3.partition_id left join sys.objects s5 on s3.object_id = S5.object_id left join sys.objects S4 on (case when S1.resource_type = 'OBJECT' THEN S1.resource_associated_entity_id else null End) = S4.object_id left join sys.sysdatabases s6 on S1.resource_database_id = s6.dbid Where S1.resource_database_id = DB_ID() With Requested SQL Server Statement ------------------------------------------------------------- Select S1.*, S2.text From sys.sysprocesses S1 cross apply sys.dm_exec_sql_text (Sql_handle) S2 Where spID = SessionID
Views: 249 IT Port
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: 4816 AO DBA
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 7056 Abinash Sahoo
How to lock objects in Redgate SQL Source Control
 
02:26
Microsoft MVP Alessandro Alpi explains how to use the database object locking feature in Redgate SQL Source Control. SQL Source Control is an add-on for SSMS that lets you version control your database changes using your existing version control system. Find out more and try SQL Source Control for free http://www.red-gate.com/sql-source-control).
Views: 1127 Redgate Videos
How to Easily Identifying Oracle Locks
 
02:10
How to Easily Identifying Oracle Locks. For more information, please go to: http://www.embarcadero.com/products/dbartisan-xe
Views: 2021 DBPowerStudio
Batman Arkham Knight - Bleake Island - All Riddler Trophy Locations
 
28:12
There are 37 Riddler Trophies on Bleake Island. Batman Arkham Knight has 315 Riddler Collectibles in total (179 Trophies, 40 Riddles, 6 Bomb Rioters, 90 Breakable Objects). Find all of their locations to complete Riddler's challenges and to lock him up in GCPD. This will earn you the "Riddle Me That" trophy / achievement. It's also required for 100% game completion and to initiate the full Knightfall Protocol. You can interrogate Riddler Informants on the streets of Gotham to unlock the collectible locations on your world map. Riddler informants are highlighted in green color. Instead of killing them you must press Triangle (PS4) / Y (XB1) to interrogate them. It's recommended that you beat the story first before collecting anything! This is to ensure that you have all the required gadgets and can access all areas. You can keep track of your progress in the Riddle Section of your world map. There you can see which objects you have found in each area. Please note that all 90 breakable objects together count only as 18 of the 243 Riddler challenges (every fifth one counts as one complete challenge). The Riddler trophies are green question mark items that you must pick up (usually locked away in rooms that require certain gadgets). The Riddles are little Puzzles and require you to scan certain objects in the world from a specific distance. The bomb rioters are thugs with bomb implants and you must shoot them with an electric charge. The breakable objects need to be destroyed with your batmobile. Overview of Collectibles by Area: Bleake Island = 37 Trophies, 11 Riddles, 3 Riot Bombers, 15 Breakable Objects Miagani Island = 38 Trophies, 10 Riddles, 3 Bomb Rioters, 15 Breakable Objects Founders' Island = 41 Trophies, 10, Riddles, 0 Bomb Rioters , 15 Breakable Objects Stagg Enterprises Airships = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Panessa Studios = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Arkham Knight HQ = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects All Riddler Collectibles Playlist: https://www.youtube.com/playlist?list=PLRr5L69yg_kGj9roh6fYVG49GbPKMYb20 TIMELINE: #1 - 0:05 #2 - 0:32 #3 - 0:57 #4 - 1:20 #5 - 1:56 #6 - 3:28 #7 - 4:16 #8 - 5:33 #9 - 5:58 #10 - 6:33 #11 - 6:59 #12 - 8:06 #13 - 8:25 #14 - 9:49 #15 - 10:49 #16 - 11:24 #17 - 11:44 #18 - 12:03 #19 - 12:52 #20 - 13:17 #21 - 14:34 #22 - 15:07 #23 - 15:46 #24 - 16:19 #25 - 16:57 #26 - 18:03 #27 - 18:33 #28 - 18:57 #29 - 19:18 #30 - 20:25 #31 - 21:25 #32 - 21:55 #33 - 23:28 #34 - 25:14 #35 - 26:01 #36 - 26:31 #37 - 27:10 Helped you out? Support this channel: http://www.powerpyx.com/help/ SUBSCRIBE: http://www.youtube.com/subscription_center?add_user=powerpyx ~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow PowerPyx: http://www.powerpyx.com http://www.youtube.com/PowerPyx http://www.facebook.com/PowerPyx http://www.twitter.com/PowerPyx ~~~~~~~~~~~~~~~~~~~~~~~~~
Views: 1563270 PowerPyx
Batman Arkham Knight - Bleake Island - All Riddle Locations & Solutions
 
06:33
There are 11 Riddles on Bleake Island. Batman Arkham Knight has 315 Riddler Collectibles in total (179 Trophies, 40 Riddles, 6 Bomb Rioters, 90 Breakable Objects). Find all of their locations to complete Riddler's challenges and to lock him up in GCPD. This will earn you the "Riddle Me That" trophy / achievement. It's also required for 100% game completion and to initiate the full Knightfall Protocol. You can interrogate Riddler Informants on the streets of Gotham to unlock the collectible locations on your world map. Riddler informants are highlighted in green color. Instead of killing them you must press Triangle (PS4) / Y (XB1) to interrogate them. It's recommended that you beat the story first before collecting anything! This is to ensure that you have all the required gadgets and can access all areas. You can keep track of your progress in the Riddle Section of your world map. There you can see which objects you have found in each area. Please note that all 90 breakable objects together count only as 18 of the 243 Riddler challenges (every fifth one counts as one complete challenge). The Riddler trophies are green question mark items that you must pick up (usually locked away in rooms that require certain gadgets). The Riddles are little Puzzles and require you to scan certain objects in the world from a specific distance. The bomb rioters are thugs with bomb implants and you must shoot them with an electric charge. The breakable objects need to be destroyed with your batmobile. Overview of Collectibles by Area: Bleake Island = 37 Trophies, 11 Riddles, 3 Riot Bombers, 15 Breakable Objects Miagani Island = 38 Trophies, 10 Riddles, 3 Bomb Rioters, 15 Breakable Objects Founders' Island = 41 Trophies, 10, Riddles, 0 Bomb Rioters , 15 Breakable Objects Stagg Enterprises Airships = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Panessa Studios = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Arkham Knight HQ = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects All Riddler Collectibles Playlist: https://www.youtube.com/playlist?list=PLRr5L69yg_kGj9roh6fYVG49GbPKMYb20 TIMELINE: #1 - 0:05 #2 - 0:42 #3 - 1:06 #4 - 1:57 #5 - 2:41 #6 - 3:31 #7 - 4:00 #8 - 4:27 #9 - 4:55 #10 - 5:31 #11 - 5:52 Helped you out? Support this channel: http://www.powerpyx.com/help/ SUBSCRIBE: http://www.youtube.com/subscription_center?add_user=powerpyx ~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow PowerPyx: http://www.powerpyx.com http://www.youtube.com/PowerPyx http://www.facebook.com/PowerPyx http://www.twitter.com/PowerPyx ~~~~~~~~~~~~~~~~~~~~~~~~~
Views: 576478 PowerPyx
Destiny 2 - WOW! DREAMING CITY SECRETS!
 
13:31
Destiny 2 Forsaken! Dreaming City Secrets! Ascendant Challenge! How to Open Chests! All Supers! Spider Bounty! Power Gear! ✅ Check out Razer's awesome gear: http://rzr.to/gQsQG ✅ FOLLOW ME ON TWITTER: https://twitter.com/MoreConsole ✅ FOLLOW ME ON TWITCH: http://www.twitch.tv/moreconsole/profile ✅ FOLLOW ME ON FACEBOOK: https://www.facebook.com/pages/Destiny-Fans/590719657610614?ref=hl Check out this Destiny 2 Database for every single item in the game: https://light.gg/ #loot
Views: 371236 MoreConsole
Destiny 2: Tincture of Queensfoil Guide! - Secret Chests! Ascendant Challenge! | Forsaken
 
10:48
Guide to what the Tincture of Queensfoil does, and how to use it to unlock secret areas and secret chests in the Dreaming City! As well as how to complete the Ascendant Challenge Bounty! → BEST NEW FORSAKEN SUPERS: https://www.youtube.com/watch?v=HxD2mij_mb8 → SAVE ON ASTRO PRODUCTS: https://astro.family/Kackis Guide for how to use the Tincture of Queensfoil legendary consumable in the Dreaming City to unlock secret areas, secret chests, and how to complete the Ascendant Challenge Bounty from Petra to get powerful gear! --- Official Merch: TBA --- My Twitter: https://twitter.com/RickKackis --- My Twitch Channel: http://www.twitch.tv/kackishd/profile
Views: 360574 KackisHD
Identifying and Tuning Queries that Cause Oracle Wait Events
 
07:22
Identifying and Tuning Queries that Cause Oracle Wait Events. For more information, please go to: http://www.embarcadero.com/products/db-optimizer-xe
Views: 24638 DBPowerStudio
Oracle DBA Justin - How to manually expire a user account's password in an Oracle database
 
04:35
How to manually expire a user account's password in an Oracle database
Views: 2502 jbleistein11
How to Get locked Objects in SQL Server Tamil
 
07:43
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Generally, There are two ways to get what are the objects are Locked. First way with SP_LOCK, We can get the Locked Object details in a Particular Session Or SQL Server Engine. Second way is Used with DMV, Sys.dm_trans_lock it returns the Locked Objects with Some more data's when compared to SP_LOCK. Both are explained with Simplest Example in this Video. To Get Locked Objects ----------------------------------- Select S2.host_name, S1.Resource_type, (Case when S1.resource_type IN ('RID', 'PAGE') then s5.name when S1.resource_type IN ('DATABASE') then s6.name else S4.Name end) Name, S1.resource_associated_entity_id, S1.request_mode, S1.request_type, S1.request_status, S1.request_session_id, ISNULL(S3.rows , 0) Rows From Sys.dm_tran_locks S1 Inner join Sys.dm_exec_sessions S2 on S1.request_session_id = S2.session_id left join sys.partitions S3 on S1.resource_associated_entity_id = S3.partition_id left join sys.objects s5 on s3.object_id = S5.object_id left join sys.objects S4 on (case when S1.resource_type = 'OBJECT' THEN S1.resource_associated_entity_id else null End) = S4.object_id left join sys.sysdatabases s6 on S1.resource_database_id = s6.dbid Where S1.resource_database_id = DB_ID() With Requested SQL Server Statement ------------------------------------------------------------- Select S1.*, S2.text From sys.sysprocesses S1 cross apply sys.dm_exec_sql_text (Sql_handle) S2 Where spID = SessionID
Views: 69 IT Port
SQLDay 2015 | DBA | From Locks to Dead-locks. Concurrency in SQL Server - Andreas Wolter
 
55:42
In this session we take a look at essential mechanisms inside SQL Server, which influence administrators as well as developers and should be known thoroughly. Why does SQL Server have to lock objects, which effects does this have (performance and data integrity) and how we can influence these things. · can indexes prevent locking? · why is NOLOCK not a good idea when dealing with critical data? · when and what happens at Lock-Escalation? · what does table-design have to do with blocking? · why everyone should know error number 1205 – how deadlocks can occur and what can prevent them? · how is „optimistic concurrency“ implemented in SQL Server? As usual: lots of (code) demos
Views: 2770 PLSSUG
Querying some V dollar views
 
11:05
#Oracle #V$Views Querying V$ performance views
Views: 952 Hemant K Chitale
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 334990 Chitu Okoli
sql lock
 
01:00:44
Views: 72 man-han Tsai
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: 641 IT Port
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 80692 Manish Sharma
DESTINY 2 FORSAKEN : SECRET ASCENDANT CHEST LOCATIONS IN THE DREAMING CITY
 
08:53
All known locations for ascendant chests within the dreaming city, these can contain weapons,armour and gifts to give as offerings in return for more weapons and armour
Views: 15328 Mida Life Crisis
Update - Locks in SQL Server - Part 4
 
07:48
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Update (U) locks prevent a common form of deadlock. In a repeatable read or serializable transaction, the transaction reads data, acquiring a shared (S) lock on the resource (page or row), and then modifies the data, which requires lock conversion to an exclusive (X) lock. If two transactions acquire shared-mode locks on a resource and then attempt to update data concurrently, one transaction attempts the lock conversion to an exclusive (X) lock. The shared-mode-to-exclusive lock conversion must wait because the exclusive lock for one transaction is not compatible with the shared-mode lock of the other transaction; a lock wait occurs. The second transaction attempts to acquire an exclusive (X) lock for its update. Because both transactions are converting to exclusive (X) locks, and they are each waiting for the other transaction to release its shared-mode lock, a deadlock occurs. To avoid this potential deadlock problem, update (U) locks are used. Only one transaction can obtain an update (U) lock to a resource at a time. If a transaction modifies a resource, the update (U) lock is converted to an exclusive (X) 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: 441 IT Port
Configuring the Oracle Social Network Desktop Client (Release 10)
 
01:10
Learn how to download and configure the Oracle Social Network Desktop Client. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
PowerCenter Object locks
 
11:07
the agenda of this video includes: Object locks Different types of locks Lock compatibility martrix and how to remove the locks
Views: 893 Informatica Support
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 6613 BhagyaRaj Katta
Regular Expressions (Regex) Tutorial: How to Match Any Pattern of Text
 
37:55
In this regular expressions (regex) tutorial, we're going to be learning how to match patterns of text. Regular expressions are extremely useful for matching common patterns of text such as email addresses, phone numbers, URLs, etc. Almost every programming language has a regular expression library, so learning regular expressions with not only help you with finding patterns in your text editors, but also you'll be able to use these programming libraries to search for patterns programmatically as well. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Regular-Expressions Python Regex Tutorial: https://youtu.be/K8L6KVGG-7o If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/
Views: 154841 Corey Schafer
SQL tutorial 42: How to Unlock user using SQL Developer By Manish Sharma RebellionRider
 
04:32
In this tutorial you will learn how to unlock account using SQL Developer. Using the steps used in this tutorial you can unlock any user account such as HR,OE,Scott in oracle database. Another part of user management in Oracle Database. Keep watching Enjoy SQLing Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Website: www,Rebellionrider.com Blog: http://bit.ly/unlock-user-using-sql-developer Previous Tutorial: How to unlock user using SQL Alter User command http://youtu.be/sMqq9MSVmQo Tutorial 38: http://youtu.be/GS4udgR44Ls Links of how to create user tutorial Create user using SQL Developer http://youtu.be/GS4udgR44Ls Create user using Create user command http://youtu.be/4QbK2Y-1LZw Create user using EM http://youtu.be/zGjh-Bb3HrI ------------------------------------------------------------------------- -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 22212 Manish Sharma
Tech Tip: How to Avoid Locking Out the Microsoft SQL sa Account
 
01:41
Security is great ... except when you lock your keys in your car. Don't forget this setting change when setting up your Microsoft SQL sa Account for EPDM and you won't accidentally get locked out.
Lock Manager
 
03:21
Locks are placed on certain objects in Savance Enterprise to prevent multiple users from editing at the same time. This training video covers how these locks are managed.
Views: 268 SavanceEnterprise
Python SQLite Tutorial: Complete Overview - Creating a Database, Table, and Running Queries
 
29:49
In this Python SQLite tutorial, we will be going over a complete introduction to the sqlite3 built-in module within Python. SQLite allows us to quickly get up and running with databases, without spinning up larger databases like MySQL or Postgres. We will be creating a database, creating a table, insert, select, update, and delete data. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Python-SQLite If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/ #Python
Views: 134176 Corey Schafer
SQL script to insert into many to many table
 
14:52
Text Article http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many.html Slides http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many_6.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss how to insert data into a table that has many-to-many relationship Create table Students ( Id int primary key identity, StudentName nvarchar(50) ) Go Create table Courses ( Id int primary key identity, CourseName nvarchar(50) ) Go Create table StudentCourses ( StudentId int not null foreign key references Students(Id), CourseId int not null foreign key references Courses(Id) ) Go Students - Id column is identity column Courses - Id column is identity column StudentCourses - StudentId and CourseId columns are foreign keys referencing Id column in Students and Courses tables As you can see, StudentCourses is a bridge table that has many to many relationship with Students and Courses tables. This means a given student can be enrolled into many courses and a given course can have many students enrolled. Below is the question asked in an interview for SQL Server Developer role. Write a SQL script to insert data into StudentCourses table. Here are the rules that your script should follow. 1. There will be 2 inputs for the script Student Name - The name of the student who wants to enroll into a course Course Name - The name of the course the student wants to enroll into 2. If the student is already in the Students table, then use that existing Student Id. If the student is not already in the Students table, then a row for that student must be inserted into the Students table, and use that new student id. 3. Along the same lines, if the course is already in the Courses table, then use that existing Course Id. If the course is not already in the Courses table, then a row for that course must be inserted into the Courses table, and use that new course id. 4. There should be no duplicate student course enrollments, i.e a given student must not be enrolled in the same course twice. For example, Tom must not be enrolled in C# course twice. Answer : To avoid duplicate student course enrollments create a composite primary key on StudentId and CourseId columns in StudentCourses table. With this composite primary key in place, if someone tries to enroll the same student in the same course again we get violation of primary key constraint error. Alter table StudentCourses Add Constraint PK_StudentCourses Primary Key Clustered (CourseId, StudentId) Here is the SQL script that inserts data into the 3 tables as expected Declare @StudentName nvarchar(50) = 'Sam' Declare @CourseName nvarchar(50) = 'SQL Server' Declare @StudentId int Declare @CourseId int -- If the student already exists, use the existing student ID Select @StudentId = Id from Students where StudentName = @StudentName -- If the course already exists, use the existing course ID Select @CourseId = Id from Courses where CourseName = @CourseName -- If the student does not exist in the Students table If (@StudentId is null) Begin -- Insert the student Insert into Students values(@StudentName) -- Get the Id of the student Select @StudentId = SCOPE_IDENTITY() End -- If the course does not exist in the Courses table If (@CourseId is null) Begin -- Insert the course Insert into Courses values(@CourseName) -- Get the Id of the course Select @CourseId = SCOPE_IDENTITY() End -- Insert StudentId & CourseId in StudentCourses table Insert into StudentCourses values(@StudentId, @CourseId) If required, we can very easily convert this into a stored procedure as shown below. Create procedure spInsertIntoStudentCourses @StudentName nvarchar(50), @CourseName nvarchar(50) as Begin Declare @StudentId int Declare @CourseId int Select @StudentId = Id from Students where StudentName = @StudentName Select @CourseId = Id from Courses where CourseName = @CourseName If (@StudentId is null) Begin Insert into Students values(@StudentName) Select @StudentId = SCOPE_IDENTITY() End If (@CourseId is null) Begin Insert into Courses values(@CourseName) Select @CourseId = SCOPE_IDENTITY() End Insert into StudentCourses values(@StudentId, @CourseId) End Use the following statement to execute the stored procedure Execute spInsertIntoStudentCourses 'Tom','C#'
Views: 77138 kudvenkat
Recovery Locking Deadlock BY SQL Server 2008 R2 + EX. File .txt
 
09:46
Recovery Locking Deadlock BY SQL Server 2008 R2 Link : http://www.filecondo.com/dl.php?f=8ce9921xUgvM
Views: 242 MixZer_0o7
PL/SQL: Without using Length function
 
06:22
In this tutorial, you'll learn how to get the length of a string PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 2082 radhikaravikumar
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: 3153 AO DBA
Exclusive - Locks in SQL Server - Part 5
 
05:50
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Exclusive (X) locks prevent access to a resource by concurrent transactions. With an exclusive (X) lock, no other transactions can modify data Repeatable read and Higher Isolation level transactions can’t read that locked data and Rest of the levels can read. No Lock hints Can read this data. 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: 279 IT Port
MSSQL - Understanding and Deciphering a Deadlock Graph XML
 
16:21
Best Most Useful Links for Understand a Deadlock (XML) in SQL Server 1) Compatible Locks Table - http://technet.microsoft.com/en-us/library/ms186396(v=sql.105).aspx 2) Understanding Deadlocks - https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/ In your example waitresource="KEY: 6:72057594090487808 (d900ed5a6cc6) 1) Database - retrieve the database involved in the deadlock with SELECT * FROM sys.databases WHERE database_id IN (6) 2) Table or Index - retrieve the table or index involved in the deadlock SELECT b.name AS TableName, c.name AS IndexName, c.type_desc AS IndexType, * FROM sys.partitions a INNER JOIN sys.objects b ON a.object_id = b.object_id INNER JOIN sys.indexes c ON a.object_id = c.object_id AND a.index_id = c.index_id WHERE partition_id IN ('72057594090487808') 3) Exact Row - retrieve the exact row or page, in your specific case the wait resource was a KEY, so you search the "column" %%lockres%% (yes the column name is actually %%lockres%%). If your table is not too out of date or if it is not a DELETE operation, then you will find the exact row from that hash, after you have determined which table that "partition id" or "hobt_id" is from then alter and run the below code (disclaimer - the hashes and page locations may have changed by the time you are doing the debugging, though unlikely with the key hashes) SELECT sys.fn_PhysLocFormatter(%%physloc%%) AS PageResource, %%lockres%% AS LockResource, * FROM InsertTableNameFromStep2Here WHERE %%lockres%% IN ('(d900ed5a6cc6)') Keep in mind that usually 2 resources are conflicting which caused the deadlock. However, it doesn't necessarily have to be both of the statements provided in the deadlock graph which is doing both of the locking. It is also possible that a statement prior, but within the same transaction (but not identified in the deadlock graph) locked 1 of the 2 resources. But 1 of the 2 statements in the deadlock is definitely involved in locking 1 of the 2 resources causing the deadlock at the time the deadlock was logged.
Views: 7446 CodeCowboyOrg
CRAZIEST Stories In Greek Mythology!
 
12:16
Check out these top stories in greek mythology! This top 10 list of tales from ancient greece explain everything from powerful greek gods to facts and myths and mythical creatures! Subscribe For New Videos! http://goo.gl/UIzLeB Watch our "STRANGEST Artifacts Ever Discovered!" video here: https://youtu.be/gG0XGt3jFZA Watch our "SECRETS Casinos DON'T Want You To Find Out!" video here: https://youtu.be/hAoABuvzOZM Watch our "RAREST And Most EXPENSIVE Cars In The World!" video here: https://youtu.be/MtCnWSqqilg 6 . Pandora’s Box Everyone knows you shouldn’t open Pandora’s box! But do you know exactly why?? Who is Pandora? And where’d she get the box in the first place?? The story of Pandora begins with a feud between the gods. Zeus had given Prometheus and Epimetheus the job of creating all life on earth. Kind of a big responsibility!! And they had to be pretty creative!!! 5. Odysseus and the Cyclops After spending 9 years at the battle of Troy, the triumphant Odysseus and his men set sail for home, but on their way, they were blown of course. It would take them years and many obstacles before they could get back. At one point, they came across an island, and looking for some respite from their journey, they decided to make landfall. 4. Perseus and Medusa Perseus was the son of the god Zeus, and the human woman Princess Danae. An Oracle had told her father that her son (his grandson) would kill him so he locked her away in a tower. Zeus discovered her and paid her a visit because of course she was quite beautiful, and Perseus was born. 3. King Midas King Midas had it all. He ruled over the country of Phrygia and had everything a King could ever want. But beyond the luxurious castle, extravagant food, and a beautiful daughter that would one day rule, the only thing he truly cared about was his gold. He would spend most of his days counting his gold, and covering himself in it and bathing in it. He was pretty obsessed! 2. Theseus and the Minotaur King Minos of Crete had a problem. His wife, Pasiphae, had cheated on him- sleeping with a bull that had been sent by Zeus. She became pregnant, and gave birth to the Minotaur, a half man, half bull monster. Embarrassed by the affair, but unwilling to kill the Minotaur, King Minos decided to hide it in the Labyrinth underneath the Palace of Knossos. 1. Jason and the Golden Fleece Jason was the rightful heir to the kingdom of Iolcus, but his uncle Pelias had stolen the throne from his father. Fearful that he would lose grip on power, Pelias had Jason’s father locked up and, to save his life, Jason’s mother smuggled him out of the city where he was raised by a centaur. When he was old enough, Jason set out to regain what was rightfully his. Origins Explained is the place to be to find all the answers to your questions, from mysterious events and unsolved mysteries to everything there is to know about the world and its amazing animals!
Views: 280355 Origins Explained
Oracle DBA Justin - How to drop/delete Statspack from an Oracle database
 
05:50
How to drop/delete Statspack from an Oracle database
Views: 2891 jbleistein11
Assassin's Creed Origins - Sphinx SECRET Tomb - How to Get Legendary ISU ARMOR  in Sphinx Mystery
 
10:35
Isu Armor Outfit. Assassin's Creed Origins Secret Mystery Tomb hidden deep within the Sphinx. This tomb is accessible only after completing all 12 Align the Stars locations and requires 50 Silica that can be looted within all the tombs. This question mark location will lead you to the Legendary Isu Armor Outfit. The Isu Armor does not provide any stat boost, it's cosmetic only, as is all outfits in Assassin's Creed Origins Join me and other trophy hunters in the official PS4Trophies Discord Server - https://discord.gg/PS4Trophies ► Support me on Patreon - https://www.patreon.com/PS4Trophies Twitch ► http://www.twitch.tv/ps4trophies Twitter ► https://twitter.com/PS4_Trophies Website ► http://www.ps4trophiesgaming.com/ #PS4Trophies #Trophy #Walkthrough #Gameplay #LetsPlay ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ★ This Game includes the following trophies ★ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Earn Them All! (Platinum) Earn every trophy. I'm a Legend (Bronze) Be equipped with only Legendary equipment. I'm Done Learning (Silver) Activate a Master ability. Overheating (Bronze) Witness raining bugs in the desert. For Those About to Die… (Silver) Complete all arena events in the Krokodilopolis Arena. Fatality! (Silver) Finish an arena boss with an Overpower Attack. Ben-Hur (Bronze) Win the first Hippodrome tournament. Road Rage (Bronze) Destroy an opponent in a Hippodrome race. The Harder They Fall (Silver) Defeat the war elephants Qetesh & Resheph. Slasher (Bronze) Kill 3 enemies with one hit. The Arrow Whisperer (Silver) Kill an enemy with the predator bow from more than 60 meters while controlling the arrow. Words of Wisdom (Bronze) Complete all hermit locations. Circle of Life (Bronze) Feed a predator with a corpse. Shadow of Egypt (Silver) Kill 10 enemies in a row without being detected. I Know My Land (Bronze) Defog the whole map. Raider of the Lost Tomb (Bronze) Complete a tomb. I Can See My House From Here! (Bronze) Reach the "Top of the World" in the Black Desert territory. Set-up Date (Bronze) Bring a tamed lion to a crocodile. Reporter (Bronze) Take 1 photo in 5 different territories. Overdesign (Bronze) Kill a poisoned level 35+ enemy with the torch in less than 30 seconds. Archer of the Month (Silver) Headshot kill an enemy with the bow while in the air. BOOM! (Bronze) Kill 30 enemies by shooting a fire arrow at oil jars. Rider's Licence (Bronze) Use all types of vehicle at least once. Old Habits (Silver) Complete all locations. Reduce, Reuse, Recycle (Bronze) Sell 100 trinkets at once. You still need 8880... (Bronze) Reach level 20. Stargazer (Silver) Complete all 12 Stone Circles. Master Diver (Silver) Complete 15 underwater locations. Defy Authority (Bronze) Defeat a Phylakes. Handy Man (Bronze) Craft 20 items. Roooaaarrrrr! (Bronze) Tame a lion.
Views: 2772254 PS4Trophies
All "Weakest Curse" Ascendant Chest Locations! - (Destiny 2 Forsaken)
 
11:27
Here's a guide for all the hidden ascendant chests in the Dreaming City during the Weakest Curse week. Once you open all of these chests, you unlock a Triumph. To access those hidden platforms you need to consume a Tincture of Queensfoil, found in world and region chests or purchased from the secret skull vendors. If you want an easy way to get Queensfoil, watch this video here: https://www.youtube.com/watch?v=FxeXQJjL--E TIMESTAMPS: Chest 1 - 0:29 Chest 2 - 1:09 Chest 3 - 2:46 Chest 4 - 3:41 Chest 5 - 4:32 Chest 6 - 5:16 Chest 7 - 6:26 Chest 8 - 7:15 Chest 9 - 8:57 Chest 10 - 10:15 This was recorded on an Xbox. Why are there so many random words below?? Youtube only allows a limited number of tags to be attached to a video. Instead of using the usual tag field, I write out the tags below. Destiny 2 d2 all hidden tincture tinctures of queensfoil ascendant plane vision buff portal taken blight challenge bounty tier ii iii i quesst step secret vendor skull ahamkara hidden lost sector wanted enemy bounty locations weekly spider vendor ghost fragments edz pathfinder's crash excavation site xii the pit widow's walk quarry drain titan nessus mercury pariah's refuge mindbender secret treasure chest key ancient's haunt methane's flush ascendant realm boss fight baron battle hive dreadnaught ship tomb ship adventure cryo cryo-pod pod heroic how to turn event trigger cabal hive boss ogre baron captain arc orb vent cell ghost fragment wanted bounty destiny redux gear solstice of heroes tricks tips oracle chest ship heroic world record upgrade black spindle hammer event map strike nightfall prestige raid whisper the worm secret quest exotic loot guide strategy how to get weapons armor legendary public mission campaign story emote new news cheese glitch easy easiest fast quick farm orbs loadout forsaken dlc collection tokens class supers level date release ninja pups element orb farm exploit mods component new news random rolls weapon baryon bough awoken ace of spades banshee slot slots how to acquire stack hoard quick easy easiest secret quest mission event public location collectible guide collections shaders buy material planet planetary glimmer legendary shards engram engrams exotic rare uncommon masterwork core tier hand cannon sniper shotgun fusion rifle catalyst armsweek cayde spider vendor variks petra dreaming city blind well last wish details gear armor year 1 year 2 delete save d1 emblem returning bow house of wolves curse of osiris dark below warmind dlc september changes patch update taken king ttk is it worth it speedrun tutorial speed everything we know you should fashion video game map pvp mode breakthrough gambit strikes scoring bounties prepare prep head start level up 600 light power damage total buff buffs best easter egg trials of the nine faction rally iron banner vendor supers warlock titan hunter is it good auto features modifiers chest dead ghosts sword grimoire triumph titles story raid boss encounters worlds first bungie destinygame huge release date time lore queen prince cutscenes game movie dismantle bright dust eververse store annual pass ornaments season 4 get early shader delete deletion august 28th update 2.0 prison bosses escape rewards blessing of light live right now 15 10 20 big changes huge amazing best ward of dawn rally barricade rift healing empowering tractor cannon special ammo xbox console blood cleaver art ace of spades awoken raid last wish
Views: 159836 Ninja Pups
Video Tutorial: How to Monitor OracleDB ACTIVE/INACTIVE Sessions on WebLogic?
 
05:24
Case: Monitoring ACTIVE/INACTIVE Oracle Database Sessions on WebLogic? I have prepared a short screencast tutorial about monitoring DB sessions on WebLogic. It can be extended by adding machine, inst_id fields from gv$session and gv$sqlarea. Read Blog Post: http://blog.wlsdm.com/how-to-monitor-oracledb-active-inactive-sessions-on-weblogic/ WebLogic contains lots of inbox JDBC MBeans to monitor DB transactions. The most important ones are; ActiveConnectionsCurrentCount @ JDBCDataSourceRuntimeMBean ActiveConnectionsAverageCount @ JDBCDataSourceRuntimeMBean WaitingForConnectionCurrentCount @ JDBCDataSourceRuntimeMBean ConnectionDelayTime @ JDBCDataSourceRuntimeMBean FailedReserveRequestCount @ JDBCDataSourceRuntimeMBean LeakedConnectionCount @ JDBCDataSourceRuntimeMBean
Missing Index Hints in SQL Server Management Studio by Amit Bansal
 
16:24
In this video, you will learn why you should not blindly follow the SSMS Missing Index Hints. Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ -http://www.twitter.com/SQLMaestros -https://www.facebook.com/SQLMaestros -Email us: [email protected] Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development Do you know about Data Platform Summit? http://www.DPS10.com
Views: 847 SQLMaestros
Install SQL Developer and unlock the oracle Hr Schema
 
06:36
Shows how to Install and configure SQL developer, unlock the Hr schema and alter oracle database privileges/roles
Views: 7366 Victor
GOD OF WAR 1 Walkthrough - Complete Game
 
05:21:13
God of War Gameplay Walkthrough Complete Game for Playstation 2 , Playstation 3 This God of War Gameplay Walkthrough will also include a full Review and the Ending. SUBSCRIBE►http://bit.ly/291hmppA-New-Beginning Twitter ►http://bit.ly/293LdPtA-New-Beginning Facebook ►http://bit.ly/292t8QRA-New-Beginning Gameplay : God of War is a third-person single player video game viewed from a fixed camera perspective. The player controls the character Kratos in combo-based combat, platforming, and puzzle game elements, and battles foes who primarily stem from Greek mythology, including undead soldiers, harpies, minotaurs, Medusa and her Gorgons, cyclopes, wraiths, Sirens, satyrs, centaurs, cerberuses, and boss opponents—the Hydra and a giant minotaur known as Pandora's Guardian. Platforming elements require the player to climb walls and ladders, jump across chasms, swing on ropes, and balance across beams to proceed through sections of the game. Some puzzles are simple, such as moving a box so that the player can use it as a jumping-off point to access a pathway unreachable with normal jumping, but others are more complex, such as finding several items across different areas of the game to unlock one door. Throughout the game world, the player finds chests colored green, blue, or red, and each chest contains orbs of the corresponding color. Green orbs replenish the player's health, blue orbs replenish magic allowing further usage, and red orbs provide experience for upgrading weapons and magic—allowing new, more powerful attacks—and replenishing the Rage meter, which, if full, allows for the usage of the Rage of the Gods ability. Red orbs are also collected by killing foes and destroying certain inanimate objects. The player can also find Gorgon Eyes and Phoenix Feathers in unmarked chests. The Eyes and Feathers increase the length of the Health and Magic Meters, respectively; finding eighteen of an item maximizes a meter and in turn, the player's power. Characters include: The protagonist of the game is Kratos (voiced by Terrence C. Carson), a Spartan warrior who serves the Olympian Gods. Other characters include a host of Greek gods, such as Athena (Carole Ruggier), the Goddess of Wisdom and Kratos' ally and mentor; Ares (Steven Blum), the God of War and main antagonist; Poseidon (Fred Tatasciore), the God of the Sea; Aphrodite (Carole Ruggier), the Goddess of Love and Sexuality; Zeus (Paul Eiding), the King of the Gods; Artemis (Claudia Black), the Goddess of the Hunt; and Hades (Nolan North), the God of the Underworld. Several of the gods aid Kratos with magic or weapons. Minor characters include the Oracle of Athens (Susan Blakeslee), the gravedigger (Paul Eiding), the body burner (Christopher Corey Smith), and the boat captain (Keith Ferguson). Other characters appear in flashbacks, including Kratos' wife Lysandra (Gwendoline Yeo), his child Calliope, the Barbarian King, and a Village Oracle (Susan Blakeslee). The game is narrated by Linda Hunt. If you enjoyed the video, please hit the LIKE button! It really helps
Views: 7012945 theGamerKratos
Identify Most Resource Intensive Queries - SQL in Sixty Seconds #028
 
00:55
During performance tuning conversation the very first question people often ask is what are the queries offending the server or in another word let us identify the queries which are the most resource intensive. In this quick video we will learn to identify those queries which are resource intensive. Go here for Script and Resources: http://bit.ly/QUoILR
Views: 5319 Pinal Dave
BluePrism - Login Agent || Reality & Useful
 
12:32
Hi Friends, Now we will discuss about Login Agent ----------------------------------------------------------------------- It referes the Machine operations like Lock the screen, reading machine name, and checking the machine is logged in or is locked few more operations are existed in the Login Agent. ----------------------------------------------------------------------- Download Link: Login Agent VBO http://jmp.sh/9n2eLmH We will go one by one 1. I created a Business Object and we will check is logged in or is locked the screen using Login Agent. I got the True for is logged, means I am logged into the account in my machine. 2. will check for screen lock Obviously the screen is not locked that's why we got False. Let's try to lock the screen Ya, The system is locked, may be you cannot see because it depends on recording software. You try it will work. 3. We will get the username or machine name using Get Credentials Name ohh, I got internal exception saying that "Internal : Environment variable not defined" Because the Action 'Get Credential Name' expecting the environment variable to read the name. let's create the expected environement variable and named with 'Login Format String' and value for this variable is {0} I am going to create this variable in environment variables along with the value and the type is Text. Now we will run the bot. Wow, I got the name of login account what else we have we have few more change password and logout Try from your side these will work. No additional configurations required for those Change Password and Logout. Thank You for watching Video
Views: 6492 Reality & Useful
The Horribly Slow Murderer with the Extremely Inefficient Weapon by Richard Gale
 
10:17
The epic story of one man's encounter with the most relentless murderer of all time. Real movie in the works! Details: https://www.youtube.com/watch?v=gbqKLJtOaGw Subscribe! http://bit.ly/subscribeRG See the entire HSM series: http://bit.ly/hsmseries Exclusive content on Facebook! http://www.facebook.com/RichardGaleFilms Rate The Horribly Slow Murderer on the imdb! http://www.imdb.com/title/tt1301160/ Spoon us on Twitter! https://twitter.com/richardgalefilm T-Shirts! http://richardgalefilms.spreadshirt.com/ Mini-Series: http://www.youtube.com/watch?v=tN8bzdRV8co Check out SPOON WARS! ----o http://www.youtube.com/watch?v=rHKXh5VRalY GINOSAJIFEST AWARDS! ----o http://www.youtube.com/watch?v=I6Kldp8DJqs Tweet! http://bit.ly/spoooon Facebook! http://www.facebook.com/RichardGaleFilms Watch the newest Videos! SPOON WARS http://www.youtube.com/watch?v=rHKXh5VRalY Ask Jack 1: SPAGHETTI DINNER OF THE DAMNED http://www.youtube.com/watch?v=UH2_CjPS2NE SPOON vs. SPOON http://www.youtube.com/watch?v=t9-faa56l-s SAVE JACK - THE INTERACTIVE EXPERIENCE http://www.youtube.com/watch?v=VenEVnc3vqg EPIC SPOONKILLER CONTEST! http://www.youtube.com/watch?v=kzpU7vs838o SPOONKILLER CONTEST WINNERS! http://www.youtube.com/watch?v=nDrtDMKwZT0 Coming Soon to DVD: The relentlessly entertaining Horribly Slow Murderer Collector's Edition!!! Named Best Short Film of 2009 by Rue Morgue Magazine! Winner of 15 Film Festival Awards! Featured on G4TV's Attack Of The Show! YouTube Honors: #1 - Top Rated (This Month) - Film & Animation #1 - Top Favorited (This Month) - Film & Animation #4 - Most Viewed (This Month) - Film & Animation #8 - Most Discussed (This Month) - Film & Animation #5 - Top Favorited (ALL TIME!) - Film & Animation #11 Top Rated (ALL TIME!) - Film & Animation Produced, Written and Directed by Richard Gale Cast: Jack Cucchiaio........Paul Clemens The Murderer...........Brian Rohan The Mystic................Fay Kato The Girlfriend...........Melissa Paladino The Doctor...............Mike Kacey Narrator....................Richard Gale Music by Christopher Brady Jack's Ass-kicking theme: "C'mon Score" Composed by Niels Bye Nielsen Special Makeup FX by Dean Jones and Paul Clemens Seal of the Ginosaji designed by Fay Kato Details at http://www.richard-gale.com Vietnamese title : Con ma kiên trì nhất thế giới ________________________________________
Views: 33952745 RichardGaleFilms
BluePrism - Email Attachments - Get Inbox Mails || Reality & Useful
 
29:21
HI Friends, Now we will discuss about Email Attachments. Like, I have a collection and I will add file location details into that collection and I will attach the files added to collection over mail. ------------------------------------------------------------------ 1. Let's create the process 2. First I need to prepare the collection with data 3. I am going to add filed name as 'Path' and adding the files Here is my data Why I am adding files list to collection? Because The file attachements we need to pass the collection object. 4. We will configure the Email service 5. Let's send mail with attachment Here in the Attachments parameter I am passing the collection data Before running the bot, let's have a check in gmail the permission is enabled or not Yes, It is enabled Now run it and check See, I got the mail with attachement files. ------------------------------------------------------ Now We will create another bot, and read the mails from inbox. mean I am using same Bot as of now. Here I will retrieve the mails from mail box 1. Use Action stage same Email POP3/SMTP VBO and take the 'List messages' Action 2. It will give the output as collection having predefined fields. Subject From name From address Date Sent Message Id Let's run the application In my mail having two messages. I got it into collection. I have subject, and from addess But I didn't get the message. let's get the messages from two mails and add it into another collection along with message id 3. Create another collection for this with the fields message id and body text 4. Use the 'Get Message' Action to read body from mail Pass the Message Id. for this we need to use loop and I got the output values are body and content-type 5. Adding the empty row and assigning the body and message id to collection Let's create another field as content-type Let's run the bot Sorry, Mappings wrong See, we got the message body and content-type for both mails Along with message body one mail having attachements let's save those attachments into folder Create a folder as attachments in desktop Use the Save Attachments Action and pass Message Id and save location folder let's check the data and attachments I missed to give folder name we got the data and attachments from inbox Thank you for watching video
Views: 14140 Reality & Useful
How to Search SQL Query Text in Stored Procedures and Ad-Hoc Queries
 
04:44
Have you ever wanted to search across all queries on your SQL Server? In today's video, we take a look at how to search the SQL query body/text of ad-hoc queries, stored procedures, functions, and views. Blog post containing code templates for easy copy/pasting: https://bertwagner.com/2017/11/14/how-to-search-stored-procedures-and-ad-hoc-queries/ Previous video that talks about searching for implicit conversions: https://youtu.be/mLcDzxCTfHY Follow me on Twitter: https://twitter.com/bertwagner Want to receive my latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/
Views: 464 Bert Wagner

tips for an atheist dating a christian
best auckland dating website
christian dating websites nz
christian dating websites south africa
dating american ladies online