Q
Problem solve Get help with specific problems with your technologies, process and projects.

Inconsistent data retrieval speeds

We use Oracle databases to store analytical data that is organized for viewing by runs. The databases are structured identically.

We have two W2K servers with Oracle8 installed. When it comes to data retrieval from the server onto the local client's hard drive, one server provides an instantaneous transfer BUT the other takes about a half hour for one run to transfer.

The same scenario holds true for two NT servers with Oracle7 installed. Again, one results in an instantaneous transfer BUT the other takes about a half hour for one run to transfer.

We have determined that this is not a LAN issue. Do you know if anyone has experienced similar occurrences? If so, please provide us with a probable cause and solution.

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close