Oracle Performance Issues

R

Rachael Sherry

New Member
Hi There

We have created an oracle database that is run off Progress 9.1c. At the moment it is 4 gs in sive. One of our files has over a million records.
When we do a find first it takes almost 4 mins to retrieve the record and display. We also did a large where statement that took 10 mins.

In the oracle_dataserve white papers it states that the find first bulds a results set that includes all the records in the file , performance will only improve if a where statement is used.

Would anyone have an idea of increasing performance with out using a where statement, Is there something maybe we can set in oracle to increase the speed, even connecting to the database through desk top is very slow.

Any help would be deeply appreciated
Thanks
Rachael
 
I'm not sure how much you know about Oracle but I'll try and give some advice which you may already know.

1. After loading the Oracle database run "analyse table xx rebuild index" and "compute statistics" to get the greatest Oracle performance.
2. Have a big sort area size and a specific temporary area for Progress Oracle users
3. Connect to the Oracle database from Progress like this:
mpro holderDatabase -ld holder -1 -B 1000 -db oracleDB -dt ORACLE -ld oDB -U sud -P password -Dsrv qt_lookahead,qt_cache_size,65535,skip-schema-check
4. I've also tried compiling the Oracle shared object library into the Progress exe on UNIX (probably not a good idea)
5. Use schema cache files
6. Recompile code

Not sure if that helps but its a start. Am I way off?

Murray
 
I have found the following to be much faster when accessing Oracle from progress, with results passed back in a dynamic temp-table...

RUN STORED-PROC send-sql-statement LOAD-RESULT-INTO oAssetTTHandle (vSqlQueryText).
 
You must log in or register to reply here.
Back
Top