Lock held by distributed in doubt transactions for some transaction id

Friday, August 13, 2010

If you will get an error like this "locked held by distributed in doubt transactions for some transaction id". Please follow the following steps to recover from locking.

  • Try to find out the locked transaction id from the server error logs.
  • Execute select * from dba_2pc_pending in DB console. You should be able to see the particular locked transaction Id under "local_tran_id" column, and "state" for this should be PREPARED in dba_2pc_pending table.
  • Login to the database as sysdba. Execute the following command - sqlplus './as sysdba' rollback force "locked transaction id" Now if you will check dba_2pc_pending table again, the "state" should be changed to FORCED ROLLBACK for the transaction id.
  • Now you should not get the above error any more. You can also execute commit force "locked transaction id" to avoid this error.

Microsoft Windows 7 PC better than MAC

Wednesday, August 11, 2010


Windows 7 powered PC is better than Mac. I agree with this new campaign that Microsoft has started. Microsoft added a new section to their Windows 7 site titled "PC vs Mac".

It's the first time i have seen Microsoft going this way of directly marking their products as better than those of their competitors.  Apple has been doing this for past 4-5 years in more than 60 campaigns targeting "Get a Mac".

Well, now when i see what Microsoft has mentioned as comparison i am in total agreement of what they have to say, especially when it comes to most popular Games not available for Mac and the entertainment options that Microsoft has.

I know number of people who buy MAC just to show off that they are different from other or to show off that they are gadget freaks as they can afford a MAC. However, in their hearts they know how good their so called gadget is.

Following are the points, directly from Windows 7 PC vs Mac page, that I believe are correct:


HAVING FUN: Macs might spoil your fun.

There are some things you simply can't do out of the box with a Mac like watch, pause, rewind, and record TV like a DVR.

It's showtime.
You can't get a Mac that ships with a Blu-ray player, TV tuner, Memory Stick reader, or built-in 3G wireless. You can with PCs running Windows 7.

Game on!
Most of the world's most popular computer games aren't available for Macs. And Macs can't connect to an Xbox 360. PCs are ready to play.

Direct TV connection.
Most Macs can't hook up to your TV unless you buy a converter dongle. Many PCs running Windows 7 are designed to connect directly to TVs, so you can watch movies and see photos on the big screen.

WORKING HARD: Macs don't work as well at work or at school.


If most of the computers in your office or school run Windows you may find it harder to get things done with a Mac.


Sharing documents and spreadsheets.

If you use Apple's productivity suite, sharing files with PC users can be tricky. Your documents might not look right and your spreadsheets might not calculate correctly.

Giving presentations.

You'll have to buy a separate hardware dongle to plug your Mac into a standard VGA projector. Most PCs with Windows 7 hook up easily.

Protecting your drives.

On a Mac, out of the box, you can only encrypt your home folder. With Windows 7 Ultimate, you can encrypt your entire hard drive and even USB drives. So your stuff can be safer wherever you go.

SHARING: Macs don't like to share.

At least half the fun of having a computer is sharing the stuff that matters to you with other people. This is harder to do on a Mac.

Securely share your movies, music, and photos.

With a Mac, it's harder to set up secure sharing for your photos, music & movies, documents, and even printers with other computers on your home network. With HomeGroup, it's easy to connect all the computers in your house running Windows 7.

It's easy with a PC.

On a Mac, you have to manually set up photo sharing, manually set up music and movie sharing, manually set up file sharing, and manually set up printer sharing. It's easy to automatically and securely network with all the computers in your house when they're running Windows 7.

CHOICE: Macs don't let you choose.

PCs give you a lot more choice and capabilities for your money. You can get the PC you want, in the size and color you want, with the features you want. You just don't have as many options with a Mac.

Loaded with features.

You can't get a Mac with a Blu-ray player, TV tuner, Memory Stick reader, or built-in 3G wireless. PCs running Windows 7 often come with features that aren't available on even the highest end Macs, including Blu-ray, eSATA, multi-format card readers, Touch, and mobile broadband.

Available in your favorite color.

Macs only come in white or silver. PCs are available in a full spectrum of colors across a range of price points.

More digital media.

With PCs running Windows 7, you can play the videos and music stored on your home PC while you're on the go, for free. Apple charges $99/year for its online service.

Followers

 

2009 ·Techy Freak by TNB