- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- RP3440 want to use as Oracle database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2008 09:37 AM
тАО05-21-2008 09:37 AM
RP3440 want to use as Oracle database
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2008 09:54 AM
тАО05-21-2008 09:54 AM
Re: RP3440 want to use as Oracle database
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2008 03:31 PM
тАО05-21-2008 03:31 PM
Re: RP3440 want to use as Oracle database
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2008 09:43 PM
тАО05-21-2008 09:43 PM
Re: RP3440 want to use as Oracle database
Point 4 : is about lookup from oracle database.
like normal query from application... select
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2008 09:49 PM
тАО05-21-2008 09:49 PM
Re: RP3440 want to use as Oracle database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2008 03:56 AM
тАО05-22-2008 03:56 AM
Re: RP3440 want to use as 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2008 04:08 AM
тАО05-22-2008 04:08 AM
Re: RP3440 want to use as Oracle database
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-17-2008 10:12 PM
тАО09-17-2008 10:12 PM