Oracle Personal Edition 10g AS a Client Database , sutaibility, performance , Runs on 1 gb machines
Posted on 2009-02-20
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.