En eski açık transaction'ı görmek MSSQL ve Oracle

by nurgun 23. August 2009 18:06

Sunucuda çalıştırdığınız sorugular sonuç döndürmüyorsa, bekletiyorsa, büyük ihtimal sunucuda açık transaction kalmıştır. Bu transaction normal uzun süren bir UPDATE’te olabilir veya yazdığımız sorgularda BEGIN TRAN /COMMIT TRAN komutlarını doğru kullanmadığımızdan kaynaklanan sorun da olabilir . En eski açık transactionı görebilmek için:

 

DBCC OPENTRAN

kullanınız, SPID numarasını aldıktan sonra 

sp_who2 64

ile veya blogumdaki ilk yazımdaki 

us_find_stmt

sp ile transaction'ı başlatan kullanıcı ve SQL sorguyu görebileceksiniz

Oracle'da

SELECT * FROM V$TRANSACTION

kullanabilirsiniz

 

Tags: , ,

MS SQL | MS SQL Performans | MS SQL Server Yönetimi

Comments

3/11/2010 7:49:49 PM #

Monkey Baby Bedding

Bedankt voor de blog geladen met zo veel informatie

Monkey Baby Bedding United States | Reply

3/29/2010 11:06:27 PM #

notebook

Hello, good luck for me I was looking for this information for several months ago. Finally I got it all here. Thanks a lot!

notebook United States | Reply

4/5/2010 3:53:44 PM #

11 x 17 Scanner

i discovered your weblog searching a couple of completely different subject on yahoo, bizarre ...... in any case, i spent some minutes studying this and another entries and gonna come back often, i favored it Smile

11 x 17 Scanner United States | Reply

4/27/2010 11:46:45 PM #

Rapidshare

I\'m happy I found this blog, I couldnt discover any info on this subject matter prior to. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

Rapidshare United States | Reply

4/28/2010 10:36:34 AM #

Microsoft Forum

Youre so awesome, man!  I cant believe I missed this blog for so long.  Its just great stuff all round.  Your design, man...too amazing!  I cant wait to read what youve got next.  I love everything that youre saying and want more, more, MORE!  Keep this up, man!  Its just too good.

Microsoft Forum United States | Reply

4/29/2010 8:10:36 PM #

online tutoring job

What you said made a lot of sense.  But, think about this, what if you added a little content?  I mean, I dont want to tell you how to run your blog, but what if you added something to maybe get peoples attention?  Just like a video or a picture or two to get people excited about what youve got to say.  In my opinion, it would make your blog come to life a little bit.

online tutoring job United States | Reply

5/3/2010 3:05:10 AM #

Lawrenceville Chiropractor

Your blog is fine.  I just want to comment on the design.  Its too loud.  Its doing way too much and it takes away from what youve got to say --which I think is really important.  I dont know if you didnt think that your words could hold everyones attention, but you were wrong.  

Lawrenceville Chiropractor United States | Reply

5/3/2010 3:37:58 AM #

lifestyle change

Im a huge fan already, man.  Youve done a brilliant job making sure that people understand where youre coming from.  And let me tell you, I get it.  Great stuff and I cant wait to read more of your blogs.  What youve got to say is important and needs to be read.

lifestyle change United States | Reply

5/28/2010 11:43:02 PM #

Wigs UK

I hope you never stop!  This is one of the best blogs Ive ever read.  Youve got some mad skill here, man.  I just hope that you dont lose your style because youre definitely one of the coolest bloggers out there.  Please keep it up because the internet needs someone like you spreading the word.

Wigs UK United States | Reply

5/30/2010 6:20:43 AM #

P90X Review

This is definitely a blog worth following.  Youve got a great deal to say about this subject, and so much knowledge.  I think that you know how to make people listen to what you have to say, especially with an issue thats so important.  Im glad to know this blog.  Two big thumbs up, man!

P90X Review United States | Reply

5/31/2010 9:08:16 PM #

rent a car worldwide

I was wondering if you ever considered changing the layout of your blog?  Its very well written; I love what youve got to say.  But maybe you could a little more in the way of content so people could connect with it better.  Youve got an awful lot of text for only having one or two images.  Maybe you could space it out better?

rent a car worldwide United States | Reply

6/1/2010 12:22:56 AM #

profit instruments

Sweet. to your in favor of this.

profit instruments United States | Reply

6/1/2010 3:29:30 AM #

power lyrics

I found this post while searching for song lyrics. Thanks for sharing will be sure to follow this blog regularly.

power lyrics United States | Reply

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Nurgün Özgür

Facebook

 

Nurgün Özgür Photo

1993'ten bu yana profesyonel olarak yazılım ve sistem yönetimi konularında çeşitli yerli ve yabanci kuruluşların farklı kademelerinde aktif olarak yer aldım. 2011 yılında emekliliğe ayrıldım.

 

Valid XHTML 1.0 Transitional


Tag cloud


Facebook ile giriş