Home
Search results “Find oracle locked objects”
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: 5640 AO DBA
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: 347 IT Port
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: 9935 Abinash Sahoo
How to Create ROW LEVEL LOCK  1 Of 2
 
05:01
Hi... Friend In this video we learn how to create ROW LEVEL LOCKING IN ORACLE DATABASE 11g
Views: 84 PGT POINT
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: 1221 Redgate Videos
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section 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: 9725 Manish Sharma
Database Exclusive lock vs Shared Lock (Explained by Example)
 
11:47
In this episode we discuss the differences between exclusive lock and shared lock (also known as two phase locking) with an example. We define the both and list their advantages and disadvantages. Exclusive and shared lock are very important artifacts in DBMS systems. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⇨ [x] Proxy vs Reverse Proxy  https://goo.gl/ZYFQAi ⇨ [x] Stateful vs Stateless Applications  https://goo.gl/Fubfi6 ⇨ [x] Virtual Machines vs Containers https://goo.gl/fiECVb ⇨ [x] Database ACID - Atomicity https://goo.gl/ER9PPj ⇨ [x] Database ACID - Consistency https://goo.gl/VpLAeN ⇨ [x] Database ACID - Dirty read https://goo.gl/pkB528 ⇨ [x] Database ACID - Phantom read https://goo.gl/rnyzuA ⇨ [x] Database ACID - Non repeatable read https://goo.gl/8kgEjN ⇨ [x] Database ACID - Read uncommitted https://goo.gl/4igWUq ⇨ [x] Database ACID - Read committed https://goo.gl/twgAKL ⇨ [x] Database ACID - Repeatable read https://goo.gl/vDcP6M ⇨ [x] HOW I GREW MY YOUTUBE SUBS TO 2000 WITH A $25 MIC https://goo.gl/cM5VFx ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Views: 1762 Hussein Nasser
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: 7729 BhagyaRaj Katta
SQL Server DBA Tutorial 143-How to Find out How Much Memory is Allocated to SQL Server Instance
 
06:51
In this video you will learn how to find how much memory is allocated to SQL Server instances using various methods. Methods include by viewing SQL Server memory configuration via SSMS, using SQL Server dynamics system view and how to configure SQL Server Minimum (min) and Maximum (Max) memory using SQL Server Memory Configuration. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-find-out-how-much-memory-is.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 9576 TechBrothersIT
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: 3689 AO DBA
Querying some V dollar views
 
11:05
#Oracle #V$Views Querying V$ performance views
Views: 1164 Hemant K Chitale
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: 730 IT Port
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: 103593 kudvenkat
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: 344 SavanceEnterprise
How to find all the tables with Identity Column in SQL Server Database- SQL Server Tutorial Part 45
 
09:42
SQL Server / TSQL Tutorial Scenario: How to find all the tables with Identity Column in SQL Server Database How would you find all the tables in a SQL Server Database which has identity Column? Link to scripts used in the video http://www.techbrothersit.com/2016/02/how-to-find-all-tables-with-identity.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 1994 TechBrothersIT
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: 92141 Manish Sharma
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: 886 IT Port
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: 609683 PowerPyx
How to Unlock or  Lock Oracle Sample Schema User Account after Installation
 
04:51
How to easy Unlock Oracle Sample Schema User Account after installation. For more interesting vids subscribe @ http://www.youtube.com/subscription_center?add_user=rctvids
Views: 2923 RCT vids
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: 1680819 PowerPyx
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: 10768 Victor
Blocked Process Threshold | Blocked Queries | SQL Long Running Queries
 
17:46
This session will help you understand the following : 1. ) What is Blocked threshold process? 2.) Which queries are considered as long-running queries in sql server? 3.) Ways to capture the sql long running queries? Thanks for watching! By sql try Session By sql
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: 2147 DBPowerStudio
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: 390816 Chitu Okoli
Informatica : Resolving Lock Conflicts Between Objects
 
08:08
How will you resolve lock conflicts between informatica objects?
Views: 451 Mandar Gogate
Detecting and Resolving lock conflicts - ETIT 427 - ADBA - IP University Syllabus
 
07:05
Detecting and Resolving lock conflicts - ETIT 427 - ADBA - IP University Syllabus For Students of B.Tech, B.E, MCA, BCA, B.Sc., M.Sc., Courses - As Per IP University Syllabus and Other Engineering Courses
Sequence object in SQL Server 2012
 
12:22
create sequence in sql server In this video we will discuss sequence object in SQL Server. Sequence object Introduced in SQL Server 2012 Generates sequence of numeric values in an ascending or descending order Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012_26.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html 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 Creating the Incrementing Sequence : The following code create a Sequence object that starts with 1 and increments by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 Generating the Next Sequence Value : Now we have a sequence object created. To generate the sequence value use NEXT VALUE FOR clause SELECT NEXT VALUE FOR [dbo].[SequenceObject] Output : 1 Every time you execute the above query the sequence value will be incremented by 1. I executed the above query 5 times, so the current sequence value is 5. Retrieving the current sequence value : If you want to see what the current Sequence value before generating the next, use sys.sequences SELECT * FROM sys.sequences WHERE name = 'SequenceObject' Alter the Sequence object to reset the sequence value : ALTER SEQUENCE [SequenceObject] RESTART WITH 1 Select the next sequence value to make sure the value starts from 1 SELECT NEXT VALUE FOR [dbo].[SequenceObject] Using sequence value in an INSERT query : CREATE TABLE Employees ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) -- Generate and insert Sequence values INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') -- Select the data from the table SELECT * FROM Employees Creating the decrementing Sequence : The following code create a Sequence object that starts with 100 and decrements by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 100 INCREMENT BY -1 Specifying MIN and MAX values for the sequence : Use the MINVALUE and MAXVALUE arguments to specify the MIN and MAX values respectively. Step 1 : Create the Sequence object CREATE SEQUENCE [dbo].[SequenceObject] START WITH 100 INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 Step 2 : Retrieve the next sequence value. The sequence value starts at 100. Every time we call NEXT VALUE, the value will be incremented by 10. SELECT NEXT VALUE FOR [dbo].[SequenceObject] If you call NEXT VALUE, when the value reaches 150 (MAXVALUE), you will get the following error The sequence object 'SequenceObject' has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated. Recycling Sequence values : When the sequence object has reached it's maximum value, and if you want to restart from the minimum value, set CYCLE option ALTER SEQUENCE [dbo].[SequenceObject] INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 CYCLE At this point, whe the sequence object has reached it's maximum value, and if you ask for the NEXT VALUE, sequence object starts from the minimum value again which in this case is 100. To improve performance, the Sequence object values can be cached using the CACHE option. When the values are cached they are read from the memory instead of from the disk, which improves the performance. When the cache option is specified you can also specify the size of th cache , that is the number of values to cache. The following example, creates the sequence object with 10 values cached. When the 11th value is requested, the next 10 values will be cached again. CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 CACHE 10 Using SQL Server Graphical User Interface (GUI) to create the sequence object : 1. Expand the database folder 2. Expand Programmability folder 3. Right click on Sequences folder 4. Select New Sequence Next video : Difference between SEQUENCE and IDENTITY in SQL Server
Views: 39238 kudvenkat
Shared - Locks in SQL Server - Part 3
 
06:49
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control. No other transactions can modify the data while shared (S) locks exist on the resource. Shared (S) locks on a resource are released as soon as the read operation completes, unless the transaction isolation level is set to repeatable read or higher, or a locking hint is used to retain the shared (S) locks for the duration of the transaction. 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: 586 IT Port
SQL Server DBA Tutorial 115-How to Create Linked server in SQL Server
 
13:46
In this video you will learn how to create Linked Server in SQL Server using SQL Server Management studio as well as T-SQL Script. It also explains best practices of creating Linked servers in SQL Server, when it is best idea to create linked server, requirement of remote synonyms to have Linked server created. Security best practices of Linked server and how to create linked server using other providers such as ODBC, SSAS and SQL Server client 11.0. blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-create-linked-server-in-sql.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 79326 TechBrothersIT
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: 382 IT Port
MSSQL - Understanding Isolation Level By Example (Serializable)
 
08:46
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Serializable, Read Committed, Read Uncommitted, Repeatable Read --===================================== -- Windows/Session #1 --===================================== SELECT @@SPID IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] DEFAULT(GETDATE()) NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 2 DELETE FROM SampleTable WHERE ID = 4 WAITFOR DELAY '00:0:10' COMMIT TRAN --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT @@SPID BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable ROLLBACK SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is REPEATABLE READ -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN --===================================== -- Windows/Session #4 --===================================== ----------------------------------------------------- -- This window/session is SERIALIZABLE -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN
Views: 14953 CodeCowboyOrg
Audit table changes in sql server
 
06:45
sql server 2008 ddl trigger audit sql server table changes tracking In this video we will discuss, how to audit table changes in SQL Server using a DDL trigger. Table to store the audit data Create table TableChanges ( DatabaseName nvarchar(250), TableName nvarchar(250), EventType nvarchar(250), LoginName nvarchar(250), SQLCommand nvarchar(2500), AuditDateTime datetime ) Go The following trigger audits all table changes in all databases on a SQL Server. CREATE TRIGGER tr_AuditTableChanges ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN DECLARE @EventData XML SELECT @EventData = EVENTDATA() INSERT INTO SampleDB.dbo.TableChanges (DatabaseName, TableName, EventType, LoginName, SQLCommand, AuditDateTime) VALUES ( @EventData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(250)'), @EventData.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2500)'), GetDate() ) END In the above example we are using EventData() function which returns event data in XML format. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server_12.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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
Views: 46572 kudvenkat
Resetting Your Oracle Database Password with Oracle SQL Developer
 
02:43
Resetting your Oracle Database user password just got a LOT easier in version 4.2 of SQL Developer. In this video, the product manager shows you JUST how much easier.
Views: 28120 Jeff Smith
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
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: 421598 KackisHD
Difference between sequence and identity in SQL Server
 
05:29
sql server identity vs sequence In this video we will discuss the difference between SEQUENCE and IDENTITY in SQL Server This is continuation to Part 134. Please watch Part 134 from SQL Server tutorial before proceeding. Sequence object is similar to the Identity property, in the sense that it generates sequence of numeric values in an ascending order just like the identity property. However there are several differences between the 2 which we will discuss in this video. Identity property is a table column property meaning it is tied to the table, where as the sequence is a user-defined database object and is not tied to any specific table meaning it's value can be shared by multiple tables. Example : Identity property tied to the Id column of the Employees table. CREATE TABLE Employees ( Id INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(50), Gender NVARCHAR(10) ) Example : Sequence object not tied to any specific table CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 This means the above sequence object can be used with any table. Example : Sharing sequence object value with multiple tables. Step 1 : Create Customers and Users tables CREATE TABLE Customers ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO CREATE TABLE Users ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO Step 2 : Insert 2 rows into Customers table and 3 rows into Users table. Notice the same sequence object is generating the ID values for both the tables. INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Tom', 'Male') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Pam', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'David', 'Male') GO Step 3 : Query the tables SELECT * FROM Customers SELECT * FROM Users GO Output : Notice the same sequence object has generated the values for ID columns in both the tables To generate the next identity value, a row has to be inserted into the table, where as with sequence object there is no need to insert a row into the table to generate the next sequence value. You can use NEXT VALUE FOR clause to generate the next sequence value. Example : Generating Identity value by inserting a row into the table INSERT INTO Employees VALUES ('Todd', 'Male') Example : Generating the next sequence value using NEXT VALUE FOR clause. SELECT NEXT VALUE FOR [dbo].[SequenceObject] Maximum value for the identity property cannot be specified. The maximum value will be the maximum value of the correspoding column data type. With the sequence object you can use the MAXVALUE option to specify the maximum value. If the MAXVALUE option is not specified for the sequence object, then the maximum value will be the maximum value of it's data type. Example : Specifying maximum value for the sequence object using the MAXVALUE option CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MAXVALUE 5 CYCLE option of the Sequence object can be used to specify whether the sequence should restart automatically when the max value (for incrementing sequence object) or min value (for decrementing sequence object) is reached, where as with the Identity property we don't have any such option to automatically restart the identity values. Example : Specifying the CYCLE option of the Sequence object, so the sequence will restart automatically when the max value is exceeded CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 5 CYCLE Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html 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
Views: 37357 kudvenkat
Compress and Decompress in SQL Server | SQL data compress | data decompress in sql
 
14:00
This video talks about Compress and Decompress in SQL Server SQL data compress sql tutorials learn sql 2016 data decompress in sql sql compress sql decompress sql interview questions sql 2016 new functions sql decompress examples sql compress examples data compress examples in sql data decompress examples in sql data compression in sql sql server data compression Data Compression in SQL Pros and Cons how to compress data in sql server For Some more interview questions and answers.. https://www.youtube.com/watch?v=vbp2yPyUf9o https://www.youtube.com/watch?v=yUoDrqSRt6A https://www.youtube.com/watch?v=QOHxfeJ8VWE https://www.youtube.com/watch?v=x5iVbr94FqE https://www.youtube.com/watch?v=92OSTvW0Ge8 https://www.youtube.com/watch?v=DBCCk8Yn7SM https://www.youtube.com/watch?v=NmqTJSHN8Ic https://www.youtube.com/watch?v=D8uiujYQTxw https://www.youtube.com/watch?v=upZsqwxZX2M https://www.youtube.com/watch?v=4EvEeN0pUBo https://www.youtube.com/watch?v=vwdeItscq7o https://www.youtube.com/watch?v=ZTSw89A1ZUg https://www.youtube.com/watch?v=sqX62jK0Vc8 https://www.youtube.com/watch?v=DLn01pA1qcA
Views: 255 Training2SQL MSBI
Performance Tuning with Statistics IO
 
08:08
There's no on way to performance tune a query. Today, I show you my preferred way to get started using a quick and easy technique that everyone should have in their arsenal. Blog post with all demo code and links: https://bertwagner.com/2017/12/05/how-to-use-statistics-io-to-improve-your-query-performance/ Music by Joakim Karud http://youtube.com/joakimkarud 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: 787 Bert Wagner
How To Kill All Database Processes On SQL Server
 
06:42
SQl management studio provides lot of facilities to manage SQL processes. The “Activity monitor screen” which will show you some very useful and important information about SQL processes. It will show you all active processes, there status, number of open transactions for each process, the application by which the process is generated, Wait time CPU and memory utilisation, and the host name, means the host or the machine by which the process is initiated etc. If a process is hanging, it will show the process icon with an hour glass. Refresh it several times, sometimes the icon will turn to sleep mode if the process completes its execution. If the icon remains an hour glass, the process may be hanging. Use other info as well to decide if the process is really hanging. If you double click on the process ID it will show the SQL stamen subjected to the execution of the process. If a process is hanging you can identify which application has originated the process, which SQL stamen is hanging and even more from which machine or the host the process is initiated If some application users are complaining about uneven slowness, uneven timeouts etcetera, the reason behind may be one or more processors are hanging. What can you do now? You can restart the SQL server or the service which will disconnect all databases and all applications disturbing all the users. Or otherwise you can take the database to off line and bring it back to online. Or you can disconnect all connections to the database. The disturbance may be lesser than the previous case but still lot of applications and users can be disturbed, especially in an industrial setup. And still you do not know the real reason for the slowness or the malfunctioning as well. So what can you do? Go and examine the processors. Identify exactly which process is hanging. And most probably you will be identifying how and why. So you can find permanent solution. But the immediate solution is you can kill the troubling process or the few. It will solve the issue with minimum disturbance immediately. After identifying the correct process, you can right click on the process ID and click on ‘Kill process’ button. It will kill the selected process. You can kill processors using SQL statements and, using SQL commands you can kill all processors at once as well. Code for Killing Processes Individually USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' EXECUTE ('KILL 53') Code for killing all Processes USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE ('KILL ' + @spid) SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid @spid END
Views: 7976 Rohan Mehtha
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.
Oracle Administration 38= Shutdown a Database   Enterprise Manager
 
07:16
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Concurrency Versus Locking
 
02:19
Independent software development consultant, trainer, and writer Kevlin Henney uses a busy London intersection to illustrate the difference between concurrency and locking -- and why in most cases locking is the wrong strategy.
Views: 1211 Oracle Developers
Identifying and Fixing Performance Problems using Execution Plans
 
01:07:21
Check Out Our Performance Tuning Blog - http://blog.pragmaticworks.com/topic/performance-tuning This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query’s execution plans differ. Multiple methods for accessing execution plans including graphical, DMV’s, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.
Views: 438 Pragmatic Works
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: 7322 Reality & Useful
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: 1007 Informatica Support
How to create a DB deadlock situation and a session recovery
 
08:00
This Video KB shows how to create a database deadlock siutation using a database client and a PowerCenter workflow, and then recover the workflow. ​
Views: 1306 Informatica Support
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. GOD-OF-WAR 1Remastered►http://bit.ly/2S8OTEN 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: 7819790 theGamerKratos
The Truth Is Out There - Anomaly Detection in DPA - SolarWinds Lab #75
 
46:18
Learn More: https://slrwnds.com/SWLab75 In this episode, Head Geeks™ Patrick Hubbard and Thomas LaRock are joined by special guest, Distinguished Engineer Karlo Zatylny, to talk about the latest release of SolarWinds® Database Performance Analyzer, which includes anomaly detection powered by machine learning. Connect with SolarWinds: THWACK IT Community: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds LinkedIn: http://www.linkedin.com/company/solarwinds Instagram: http://instagram.com/solarwindsinc/
Views: 451 solarwindsinc
Hide database window, Hide menu, Disable shortcut menu, Disable Special Keys : MS Access
 
08:10
Make database more secure by hiding database window, hiding menu, disabling shortcut menu, disabling Access Special Keys see related How To: http://www.iaccessworld.com/hide-navigation-pane-full-menu-shortcut-menu/
Views: 144013 Nana Sara
Basics of Transact-SQL: Batches, Scripts, GO, and Statements
 
13:11
This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here: http://www.learnitfirst.com/Course161 Here, you will look at some T-SQL fundamentals. Trainer Scott Whigham focuses in on the details of batches, scripts, GO, and statements, covering all of the basic knowledge you will need to understand these concepts. Some of it may be familiar to you if you've worked with any sort of scripts before. What happens if you put "GO" in the wrong place? What is a batch? This video contains a few examples using SQL statements to get you started. Highlights from this video: - Review of what an SQL script is - What is a statement terminator? - Executing every statement or specific statements in a file - Using the Parse command and much more...
Views: 6308 LearnItFirst.com