General
cancel
Showing results for 
Search instead for 
Did you mean: 

RP3440 want to use as Oracle database

ShaileshBhanderi
Occasional Advisor

RP3440 want to use as Oracle database

Hi All,
We have currently RP3440 machine with 1 core Duo, 1ghz with 8 GB RAM. We can upgrade this server with maximum capacity,It is not issue. We want to use as oracle database for following requirements.

1. TPS are 25-30/s required.
2. application users will be 10-15 and will continuous access database.
3. 5,000,000 rows will insert in oracle database(will have simple table with 5-6 columns with indexing).
4. lookup from tables will have 100k/ hour. This is simple query from application for find parameter base on condition from above created tables.

can any one suggest what could performance we can achieve with RP3440 machine with max capacity. Does we can achieve above performance with RP3440? Please suggest.

Note: We have spare RP3440 machine, So we have to utilize it,So please no other hardware option.
7 REPLIES
Steven E. Protter
Exalted Contributor

Re: RP3440 want to use as Oracle database

Shalom,

An RP3440 system seems capable of handling this amount of data. We have systems where I work handling much larger Oracle databases.

I don't really see the need to add memory unless you plan a huge SGA for the oracle database, which you don't specify requirements for.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
TTr
Honored Contributor

Re: RP3440 want to use as Oracle database

Without doing the math this machine should be capable to handle your database. Based on your 5 million rows and 5-6 columns I am guessing that your database might be anywhere from 100MB to 1GB.

You may consider upgrading your memory to 16GB so that you can be generous with the oracle internal memory structures (SGA, sort areas etc.)

What kind of storage do you have available?

What is the "100k/hour" in your question #4?
ShaileshBhanderi
Occasional Advisor

Re: RP3440 want to use as Oracle database

Hi,

Point 4 : is about lookup from oracle database.
like normal query from application... select from where . ( result will be 1-1)
So such update or delete query will continuous access by application. This query are around 100000 / hourly will fire on database to get parameters from existing tables.

If some one have RP3440 machine running with oracle database, than please share performance with your database capacity.
ShaileshBhanderi
Occasional Advisor

Re: RP3440 want to use as Oracle database

Hi,

I forgot to mention it has EVA 8000 SAN storage and I am planning to get 2 mount point, 10 GB for oracle binary installation and 150-200 GB for oracle database.

BR
Shailesh
TTr
Honored Contributor

Re: RP3440 want to use as Oracle database

> EVA 8000 SAN storage and I am planning to get 2 mount point, 10 GB for oracle binary installation and 150-200 GB for oracle database.

You should consider putting the oracle binary in the internal disks.

You should spread your database data over more volumes, I would say 8. Use one or two for redo logs, several for data files. You need archive log areas and maybe disk backup areas.
Steven E. Protter
Exalted Contributor

Re: RP3440 want to use as Oracle database

Shalom,

For OLTP Oracle recommends RAID 1 or 1/0 storage for redo, index and data. Archive logs can be raid 5 because they are fast sequential writes.

You still have not made clear the SGA requirements of the application. How the application is written from the the sql efficiency point of view and memory use standpoint is critical to overall performance.

List:
sql statement efficiency
SGA configuration
Database key/index read design.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
ShaileshBhanderi
Occasional Advisor

Re: RP3440 want to use as Oracle database

I had used sever as oracle database and its wroking fine.