We are running an oracle database 8i, we have several Ms Access
applications connected by ODBC to this database. The database is very complex ,in
total about 300 tables and of course PL/SQL procedures We also have many different
schemas in this database. But we have a big problem, when we are quering the
database( a procedure runs) it sometimes take so long time to get the result, almost
one hour, but sometimes it just takes about 20 seconds to get the result. Which means
that this doesnt happen everytime.
What do you suggest that I should do?
Do we need to split the database?
Is there any problem with the Accessapplication, i mean is it possibility that
MsAccess cant access oracledatabases always when the database is very big. And that
the reason to slow access to the database should be in the Access environment?
Please help me with any suggestions how to solve this.
/Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).