Everyone a great god, and I met problems, using c # client to access Oracle do Select queries, often appear caton case, query the database deadlock statement has not been found!
Appeared the problem, often appear on the query specific data items, such as the number is a data of 001 stuck when this the data query, query the other data is normal at this moment, but the manual change data in the database OO1 to 002, then the query is normal, is the record of as long as there is problem for part of the content change can read properly, who knows what is going on?

CodePudding user response:

Whether to use the select... For update to query?

CodePudding user response:

Not just use query did not update

CodePudding user response:

refer to the second floor csdn_ggg response:

not just use query did not update

The well:

1, log database, select distinct sid from v $mystat acquire sid, execute queries, stuck;
2, query the v $session (if it is below the 11 g version, query the v $session_wait, if it is a RAC environment, in v to gv), mainly for the above Chad SID corresponding to the EVENT field, in addition, there are a few fields to note down: BLOCKING_INSTANCE, BLOCKING_SESSION, SQL_ID,

According to the information obtained from v $session, then do further diagnosis

CodePudding user response:

Don't see problems, amount of data and network also want to see!