performance
From: Sharif Joya <joya_at_MCS.COM>
Date: 22 Nov 1994 07:54:51 -0600
Message-ID: <3ast7b$q1o_at_Mercury.mcs.com>
Date: 22 Nov 1994 07:54:51 -0600
Message-ID: <3ast7b$q1o_at_Mercury.mcs.com>
Hi EveryBody:
Please help me how to find out where the trouble is:
Front-end : PowerBuilder
Back-end: Oracle 7.x/Sun Solaris 2.3
At front-end, a simple query like SELECT * FROM TABLE takes lot of time. Average table records are 3000.
I see every table has properly indexed. queries look good. What are the commands or tips can help me see trouble at front level or may be traffic or database. Any kind of suggestion, opinion will be highly appreciated.
Thanks
joya
joya_at_mcs.com Received on Tue Nov 22 1994 - 14:54:51 CET