Is there a way to estimate the write bandwidth from java to an Oracle

We have a large volume of data and want to know how fast it can be written to Oracle. Is there a way to estimate the write bandwidth from java to an Oracle DB? We can use any approach (not necessarily JDBC) if it is faster. For example it would be useful to know for X disk speed, Y processor, then you can write Z bytes/second. Is there a way to estimate such a data rate?

Thanks!

Answers


I don't think there's any standard formula. Among other things it also depends on your schema (e.g whether you have indexes on the tables), the file system, how many disks you have, the RAID level you are using, how the tables, indexes, logs etc are spread out across those disks...

Try it and see is probably the only way.

If there is a way of estimating it given all that, I'd like to know about it too!


Need Your Help

How do I secure REST calls I am making in-app?

python google-app-engine rest restful-authentication tipfy

I have an application that has a "private" REST API; I use RESTful URLs when making Ajax calls from my own webpages. However, this is unsecure, and anyone could make those same calls if they knew t...

Messed up special chars when reading PDF

php pdf web-deployment tcpdf

I'm using a little PHP class (pdf2text) to open and read a "text" PDF.