RP3440 want to use as Oracle database

[ShaileshBhanderi]

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.

[Steven E. Protter]

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

[TTr]

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]

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]

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]

> 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]

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

[ShaileshBhanderi]

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