- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle8i performance on SuperDome and XP512
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
тАО10-22-2001 09:49 AM
тАО10-22-2001 09:49 AM
if you want to play a little with a SuperDome server and a XP512 DiskArray, you just have to come to hp russia, it seems ;-)
Right now, I do have a chance to do some high-end benchmarking on that combination, so I would like to get your experience on that!
What do think (or even know) about to tune this beast? 16 CPUs, 16 GB of RAM, 2 FC-links to XP512, 5 ParityGroups of the fast 18 GB drives (but in RAID5), 64bit Oracle 8.1.6, whole nights to toy around with :-)
I am thinking about trying
- about 10GB of SGA in 1GB chunks to "stripe" RAM over CPU-blocks
- POPS with 256MB pages for data (10 GB of SGA)
- timeslice=11 or 12
- async I/O (yes, this is dangerous)
- Veritas VM to do LoadBalancing on the FC links
- Raw-Devices for Oracle, of course (data, and redo-logs)
- No-ArchiveLog-Mode (dangerous, too)
- High Performance Mode for the CHIP used
- Using a Brocade FC-Switch to actually use 4 CHIPs over the switch to connect to the 2 FC-links from the SuperDome
Sadly, *my* XP512 is a little bit *narrow* on the CacheRAM side, so using CacheLUN for the redo-logs is not an option :-(
So, Ladies and Gentlemen, what is missing?
Just tell me, please, as I will summarize (as we used to say in the *good ol' days* of HPADM).
HP-UX? Disk-I/O? Oracle8i? XP512? SAN? else?
hey, I am quite curious, as I did not expect this to be possible here (yes, I have seen the Kremlin and the Red Square, already :-) and spending evenings/nights that way could be at least, say, entertaining? (the hotel is just 5m away).
Quite curiuos,
Wodisch
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2001 09:54 AM
тАО10-22-2001 09:54 AM
Re: Oracle8i performance on SuperDome and XP512
After not being able to answer your question on the high-performance CHIPS mode on the XP512, what makes you think we can answer anything "else"?
Sounds like you are really enjoying yourself over there!
harry
live free or die
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2001 10:04 AM
тАО10-22-2001 10:04 AM
Re: Oracle8i performance on SuperDome and XP512
what are you doing there - an answer within a minute, or so?
Working hard on your "hat" it seems :-)
Understanding this as your "moral support" this is worth at least a single point, is it not?
And for the "rest" of you: one can always hope!
Waiting for more answers,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2001 10:20 AM
тАО10-22-2001 10:20 AM
Re: Oracle8i performance on SuperDome and XP512
I usually have a lot of time in between building virtual partitions on an N-class (6 partitions). Good healthy fun!
harry
live free or die
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2001 08:00 PM
тАО10-22-2001 08:00 PM
Re: Oracle8i performance on SuperDome and XP512
How much cache on the XP? Over how many boards?
How much memory for the XP?
How many ACP's do you have in the frame?
How many drives do you have? 20? How have the drives being split up?
Do you have both left and right cabinets? How many on both side? I am guessing Right 1 only?
On the host, do you have AutoPath XP?
You have 4 CHiPs running in High Performance mode. Are all LUN's visable through all CHiPs?
How has the SAN being configured? Any Fiber Zone's? Any Volume Logix?
What sort of expansion are they planning on this box? A SuperDome with 16CPU's, 16Gb memory and only 270Gb of storage!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2001 09:23 PM
тАО10-22-2001 09:23 PM
Re: Oracle8i performance on SuperDome and XP512
well, actually I do not know why the SuperDome is here :-) the XP is just needed for a training...
So we kind of took the chance of "using" it...
And for your other questions:
- 1GB Cache RAM
- 2 ACP pairs
- 10 drives, 18GB in RAID5
- DKC and DKU R1 only
- no AutoPath, no AutoLUN, no CacheLUN
- 2 CHIP pairs
- SAN: XP - Brocade SW - SD
still working to set the CHIPs to HP-mode - we had duplicate IP-addresses with the XP/SVP, seems we are on a not-so-private-LAN here...
Hopefully that accounts for all those problems we have experienced.
TIA,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2001 11:54 PM
тАО10-22-2001 11:54 PM
Re: Oracle8i performance on SuperDome and XP512
You've got 12 per/corecell?
How much memory in the dome?
Is it the same per cell?
How are you configuring your partition/partitions? Whats your cell assignment.. same XBC?
How are you planning your io to the xp in terms of your partitition.
Did you have a look at the TPC.org full results for the hp test where this was done already? (except with fc60's)
You'll get kernel params there too.
Later,
Bill
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2001 12:18 AM
тАО10-23-2001 12:18 AM
Re: Oracle8i performance on SuperDome and XP512
to me it seems you're only missing Oracle 9i to be on top of the world ;-)
regards,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2001 12:34 AM
тАО10-23-2001 12:34 AM
Re: Oracle8i performance on SuperDome and XP512
an Oracle aspect:
Having 10GB of SGA with assumed big part of it for the databasebuffer and big update activity,
take care how you configure your online redo logs.
If they are too small, and switching around all the time, the database might have difficulties to manage the checkpoints.
Since you consider no_archive_mode, it might be well to enlage these as well, to have at least some stuff to recover from.
If they are too large, an instance recovery after a shutdown abort may take some time. So usally I go for several midsize online logs (consider even 10 to 20 groups of 50MB-80MB files) this balances the checkpoint stuff, because a log switch enables Oracle to process the first list of updated blocks, but does not block the logwriter as long as there are enough log groups to continue writing.
Another point of management: With the database in no_archive_mode, you will not be able to do online backups....(if application permits, or snapshotmounts (of the rawdevices) for offline backups possible, OK).
The thing you should watch out for is an alert-log-message stating "Checkpoint incomplete". Each time you have this, it means, the entire database waits for the dbwr to complete a checkpoint, before it permits the logwr to overwrite an online redo logfile.
But to be honest, I never had to deal with a machine like this. Do not know if this is relevant in this case.
Have fun with this toy.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2001 02:08 AM
тАО10-23-2001 02:08 AM
Re: Oracle8i performance on SuperDome and XP512
http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=101032105
http://www.tpc.org/results/FDR/TPCC/hp.9000ses.v5.010319.fdr.pdf
Oracle8 Enterprise Edition v8.1.7.1
TPC-C Throughput 197,024
a snap at 8,522,104 US $
256GB memory: 2.4M$!
The SD32000 was only 280k!
(only PA8600 and 48way SD)
I like the use of banks of the AutoRaids for swap space... wow!!!
Later,
Bill