2014-12-01
2,260 reads
transactions
2013-10-28
2,262 reads
2013-10-14
2,465 reads
2013-08-26
2,189 reads
Monitor current transactions and get all required information
Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,283 reads
Open transactions on a database
This script will show you all open transactions from any query windows.
2015-09-23 (first published: 2013-01-14)
3,825 reads
2012-11-13
2,263 reads
2012-09-04
2,669 reads
2012-06-29
2,637 reads
2012-06-08
2,613 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
puzzeled with "exec sp_cursor 180150007,40,1"
I've noticed in one of our applications a cursor uses operation 40 and that...
Not wanting to use a Cursor, but...
Ok, need someone to talk me off the cursor ledge on this one. I...
Ask SSC