==> 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)
Oracle 11g (18.104.22.168) 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.