Tagged Questions
4
votes
4answers
161 views
Oracle 11g delete by unique key slow
We have been plagued by a deadlock issue for quite some time that relates to deletes and inserts on the same table. It happens sporadically, but had been increasing in frequency. It would manifest ...
2
votes
1answer
75 views
LoadBalancing JDBC DataSource Connect without URL
When using JDBC I like the new DataSource-way to establish the connection. Further I like the isolated set-Methods for the properties like setUser, setPassword, setDriverType, setServerName, ...
4
votes
1answer
381 views
Session in “Sql*net message from client”, but is active
I've Googled around, and my impression is that
Sql*net message from client
suggests the Oracle DBMS is waiting for the client to send new commands to the DBMS, and therefore any time spent in ...
9
votes
1answer
278 views
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Background: I'm working on http://sqlfiddle.com (my site), and am trying to prevent one avenue of abuse possible there. I'm hoping that by asking about a problem I'm currently addressing, I don't ...
3
votes
1answer
2k views
Oracle 11g hunting down the deadlock, maybe foreign key?
I am trying to understand why a deadlock occurs in my database. The trace tells me that two updates on the same table are locking. In table is the first table to be written to in an transaction, only ...
1
vote
2answers
495 views
Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?
I've and Oracle (11 Enterprise) schema with a table
CREATE TABLE USER.WSP_BUNDLE (
NODE_ID RAW(16) NOT NULL,
BUNDLE_DATA BLOB NOT NULL
);
CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
0
votes
1answer
2k views
What is the JDBC URL for Oracle's Data Guard Fast-Start Failover?
Currently I have...
url=
"
jdbc:oracle:thin:@
(
DESCRIPTION=
(
ADDRESS_LIST=
(LOAD_BALANCE=OFF)
(FAILOVER=ON)
(
ADDRESS=
(PROTOCOL=TCP)
...
