Transaction hangs

Putz Ronald

Hy!

I have got a big problem. I have a programm which uses SQLAPI to communicate
with an Oracle 9I data base. Every second i maken an update of 500 rows in
the data base.
Now the following error occurs.
After a while my programm hangs in the execute statement and doesn´t respond
anymore.

Can anybody help me with this problem?

Ronny

Jul 19 '05 #1

Subscribe Post Reply

3288

sybrandb

"Putz Ronald" <rp***@etm-ag.com> wrote in message news:<10***************@newsmaster-03.atnet.at>...

Hy!

I have got a big problem. I have a programm which uses SQLAPI to communicate
with an Oracle 9I data base. Every second i maken an update of 500 rows in
the data base.
Now the following error occurs.
After a while my programm hangs in the execute statement and doesn´t respond
anymore.

Can anybody help me with this problem?

Ronny

Likely all your online redologs need archiving, and you didn't enable
automatic archival or your archive logs are improperly sized.
Check the alert<SID>.log, which is located in the directory, stored in
the background_dump_dest parameter, or connect as internal and issue
archive log list, possibly followed by archive log all.
However, as your error description is too vague, one really needs more
clues as to what is going on. My fear however is, you don't have a
clue about Oracle, which is the reason, why your post simply states
'It doesn't work'
And crystal balls have since long sold out here.

Regards

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #2

by: iqbal | last post by:

Hi, I have 2 sql servers (A and B) and have established a link between them using sp_addlinkedserver. I have created a table (test) on sql server A. I have created a view (test) on sql server B...

Microsoft SQL Server

Distributed Transaction in different web services

by: Avanish Pandey | last post by:

Hello All We have 3 differen services (in 3 different server) Service A,B,C . We want to implement distributed transaction when call methods of B and C from A. Is it possible? if yes then how? ...

.NET Framework

manage transaction to avoid locks

by: extmb | last post by:

Hi, I am quite puzzled how SQLServer manages transactions. Whatever the isolation level I set when performing an insertion, other connections do not have access to the table in select mode. ...

Microsoft SQL Server

Detect if Distributed Transaction is used or just SQL 2005 internal transaction?

by: John Lee | last post by:

Hi, I have few questions related to .NET 2.0 TransactionScope class behavior: 1. Check Transaction.Current.TransactionInformation.DistributedIdentifier to identify if distributed transaction...

C# / C Sharp

process.start() program hangs

by: Alexander Widera | last post by:

hello, if i start a program (an exe-file) with Process.Start(...) I don't have the required permissions that the programm needs (i could start the programm but the program needs special rights)....

ASP.NET

os.popen3 hangs in Windows XP SP1, SP2. Python 2.5 & 2.4. Consistent test case.

by: Pierre Rouleau | last post by:

Hi all, I have a consistent test case where os.popen3() hangs in Windows. The system hangs when retrieving the lines from the child process stdout. I know there were several reports related to...

Python

Question about Transaction isolation level="readCommitted"

by: D. | last post by:

I have a question about the "readCommitted" transaction isolation level. I have a client that is updating a record on a table. I suspend the execution after the UPDATE but before the commit...

Microsoft SQL Server

transaction restart

by: Christian Welzel | last post by:

Hi there, currently i'm looking for a way to repeat a rolled back transaction in a nice way. my problem: in my webapp (a browser game) i get a lot of deadlocks in the mysql innodb tables. mysql...

PHP

Transaction hangs

by: Putz Ronald | last post by:

Hy! I have got a big problem. I have a programm which uses SQLAPI to communicate with an Oracle 9I data base. Every second i maken an update of 500 rows in the data base. Now the following...

Oracle Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics