1
vote
1answer
1k 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 ...
1
vote
2answers
549 views

Running multiple Oracle Databases on the same machine

we have hr system for government that serves about 50 governmental organizations the company who created the system want to change the structure of the current system which is one database serving all ...
0
votes
1answer
46 views

Can I predict to have query performance problems against a two column xref table with 25 million records?

I'm prototyping a design. In the design, I am considering creating a thin xref table (two integer fields) that would contain approximately 25 million records. Is this a crazy idea or would I still ...