pras_gupta
asked on
Oracle Personal Edition 10g AS a Client Database , sutaibility, performance , Runs on 1 gb machines
Hi, Our enterprise application runs as in both Online and offline mode. For offline mode it uses Microsoft accesss as Data Store. Now we want to use Oracle 10g Personal Edition as Our client database, so that we can use stored procedure and have code base for both server and client. Oracle XE can not be used because Oracle XE is not supported by Oracle.
Out user machines runs with 1 GB of RAM.
Please suggest what is the best way to deploy Oracle PE to get smallest footprint and best performance. It is alright to use PE as client DB or it is too much for offline application.
Any suggested customizations or Alternatives. We have rules out Oracle Database lite because it doesn't support Pl/ SQL SP. Thanks.
Out user machines runs with 1 GB of RAM.
Please suggest what is the best way to deploy Oracle PE to get smallest footprint and best performance. It is alright to use PE as client DB or it is too much for offline application.
Any suggested customizations or Alternatives. We have rules out Oracle Database lite because it doesn't support Pl/ SQL SP. Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all the help. Finally we got rid of using Oracle Server on client machines and used SQL Server express instead.
ASKER
Concern I have is with the Oracle Personal Edition performace, I can see when the service is running it is taking 250- 300 mb of memory even when we are not doing anything. So as you said it may make our user's system walk or crawl. Are there ways where we can make the Oracle PE setup as small footprint as possisble. We do not need to do lot of enterprise function. The only requirement we have is to have a Data base system which can run PL/SQL stored procedures, support xml.