Data Transferring is Slow – from back end to front end

5 pts.
Tags:
Oracle 11g Database

==> My System:

Processer - Xeon 8 Cores @ 3.8GHz

RAM - 20 GB

Storage – 11 HDD SAN - RAID 5 configured I/O Rate – 260 MB/s

Network – Cisco 1 Gbps Intranet

Front End – Using C#.Net desktop Application, PL/SQL Developer (write PL/SQL)

==> Database:

Oracle 11g (11.2.0.3) Standard Edition on Windows Server 2008 R2 64bit (OLTP use)

Have more than 60 tables.

Most tables have above 8 million records

Reports are generated which output gives approx. 5 millions records and send to front end.

==> My Problem:

Data fetched and processed on complex query is good enough. But when procedure or query execute which output may have millions of data. Sending to front end or PL/SQL developer (test procedure/query). My problem starts here. Oracle database processed data (no high CPU or HDD usage on server side). Network usage show 2-3 MB per second transfer rate. Data starts coming into Client side slow like 800 records in 1 second. Its millions of data to come, so taking too much time to complete data arrive on front end. So management is not happy with this, its report on front side taking minutes to display. How can I improve this? I need faster data on Client side.

0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: