Oracle Personal Edition 10g AS a Client Database , sutaibility, performance , Runs on 1 gb machines

Posted on 2009-02-20
Medium Priority
Last Modified: 2013-12-18
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.
Question by:pras_gupta
  • 2
  • 2
LVL 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 675 total points
ID: 23695686
I haven't ever tried Personal Edition, but I have worked extensively with Standard Edition and Enterprise Edition on WIndows machines.  I also have some experience with XE, which we've used for at least one production application for a couple of years with no problems.  The Oracle versions I have used can all "run" on a personal computer that has 1 CPU, 1 disk drive and 1 GB of RAM.  But maybe "walk" or "crawl" would be better ways to descibe the performance you will likely see that way.  You also have to figure out how to do the replication if you have a distributed database.  Will these Personal Edition copies be just read-only copies that are updated periodically from the main server, or do you need to support bi-directional replication coming back to the main server from each personal machine periodically?  That could get complex to manage.

Author Comment

ID: 23696143
Replication is not going to be a problem as we alerady have setup to replicate and distribute data with Access ,w e will keep the same with Oracle.
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.
LVL 35

Accepted Solution

Mark Geerlings earned 675 total points
ID: 23696329
Yes, that is the dilemna: how to tune Oracle so it has enough memory to work in to be efficient but leave enough memory for other programs running on a personal computer.  On a Windows computer with less than 4GB of RAM, you shouldn't ever let Oracle have more than 50% of the physical RAM for the Oracle SGA, and that's with a machine dedicated to runnign Oracle.  In your case, you also have to leave memoery for other programs and with only 1GB of RAM, you may need to limit Oracle to an SGA of only 250MB.  You have to split that between buffer_cache and shared_pool.  If you use any Java in Oracle, you will also need 30-50MB of space in the SGA for the java_pool.

Ideally to run Oracle on a personal computer, you have at least 2GB of RAM, so Oracle can have an SGA of about 500MB.

Use the Windows Performance Monitor to see where your bottleneck is, whether that is CPU, memory, page file usuage, or disk I/O.
LVL 48

Assisted Solution

schwertner earned 75 total points
ID: 23705465
It depends what of the Oracle features will you use and how big will be the Data Base. Also what kind of connectivity will you use. Personal edition is mostly intended to be used as desktop Data base, not as corporate DB. It has some restrictions: named users numbers and time limitation:


Oracle Database 10g Database Server describes the most recent major version of the
Oracle Relational Database Management System (RDBMS) family of products that
share common source code. This family includes:
" Personal Oracle, a database for single users thats often used to develop code for
implementation on other Oracle multiuser databases
" Oracle Standard Edition, which was named Workgroup Server in its first iteration
as part of the Oracle7 family and is sometimes simply referred to as Oracle
" Oracle Enterprise Edition, which includes all Standard Edition functionality and
additional functionality
" Oracle Lite, used primarily for mobile applications

Author Closing Comment

ID: 31549406
Thanks for all the help. Finally we got rid of using Oracle Server on client machines and used SQL Server express instead.

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month14 days, 15 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question