Parse Time Really Bad on Personal Oracle

I'm working at a site with Personal Oracle 7 installed on Windows 95. The application using Oracle is Powerbuilder. The response is pretty dismal. The machines are laptops with between 16M and 40M of memory.

I have altered session set sql_trace true and examined the corresponding trace file after running TKPROF. It seems that almost all the time is being spent in PARSE regardless of the machine I am running on. I've never seen this before but my experience with Personal Oracle 7 is limited. Normally I would expect lots of time to be spent on execute or maybe fetch.  It the whole trace period is covering 9 seconds it looks like the parse is about 8.5 seconds or more. Replication option is installed on the PC's; I have tried altering the shared pool size both up and down within a range of 3500000 to 10000000 and it does not seem to make any noticeable difference.    

Are there any tricks with PO7 you are aware of? Is this just something we are going to have to live with?

Pete Merks Received on Mon Mar 31 1997 - 00:00:00 CEST