- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Experts...Can Use Your Tips On Tuning Large Me...
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
тАО01-19-2011 06:05 AM
тАО01-19-2011 06:05 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
Now I have a bit of info on NUMA, and I know how to turn it on. Unfortunately, no where in anything do I recall it give any insights as to what to set some static parms, like filecache_max/min; maxdsiz; maxssiz; shmmax for few. In fact, it doesn't give any parm recommendations that I can recall from my reading the last few days. But it does say that you either go with dynamic configuration or NUMA optimization, but not both.
So...my question would now say:
If they don't go with grid technology and NUMA and they opt to stay with ILM (Interleaved memory).....are there any tips for parm setting you folks might recommend I watch out for with this box?
Thanks,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 06:09 AM
тАО01-19-2011 06:09 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
Back online after a long break.
filecache_max/min;
set these two as you would on older HP-UX. Note that Oracle does sometimes benefit from file cache so you might find increase does help.
Oracle actually dictates some of this in the installer, and violating those rules is done at the peril of the sysadmin. shmmax needs to be equal to physical memory even though it can not possibly be that large.
maxdsiz; maxssiz; shmmax
Regards,
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
тАО01-19-2011 06:30 AM
тАО01-19-2011 06:30 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
I *would* focus "tuning" and turbo-charging your Oracle DB Server environment on two things:
1) Processor binding to certain Oracle Processes
2) FastIO! (aka RAM Disk) for key
I would also advice your DBAs to go with ASM Storage -- preferably 2 or 3 ASM Diskgroups instead of using traditional RAW or CookedIO -- no matter what the overhead projector says on improvements with VxFS/DirectIO.
Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 07:58 AM
тАО01-19-2011 07:58 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 08:04 AM
тАО01-19-2011 08:04 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
Pls. also be aware of:
http://skrajend.blogspot.com/2008/09/numa-after-10204-upgrade-is.html
In case you end up your DB is not using all available CPUs.... That is IF you're on 10Gr2
Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 09:17 AM
тАО01-19-2011 09:17 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
"I would also advice your DBAs to go with ASM Storage -- preferably 2 or 3 ASM Diskgroups instead of using traditional RAW or CookedIO -- no matter what the overhead projector says on improvements with VxFS/DirectIO."
From performance point of view the ASM is good, but not the only solution. Comparable performance can be achieved on filesystem with Oracle Disk Manager (ODM).
Read the doc:
"Improving the performance of single instance Oracle on file systems: Analyzing the impact of Oracle Disk Manager (ODM) ├в a feature of HP Serviceguard Storage Management Suite"
http://bizsupport2.austin.hp.com/bc/docs/support/SupportManual/c01917294/c01917294.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 09:53 AM
тАО01-19-2011 09:53 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
I won't disagree with ya but it is really what the DBA and SysAds are comfy about and which offers the best manageability and less risks. WIth ASM, there is no filesystem/mount point to corrupt, no "volume manager layer" to deal with. Sure with ASM a DBA has to maintain a small DB Instance -- +ASM that acts as manager of provisioned disks - but compared to traditional storage solutions - this is a whole lot simpler and moves the responsibility of manaing and monitoring DB storage to our DBA Amigos...
Say -- is ODM an evolution from Veritas Database Edition sir? Does it use Veritas bits (i.e,. FIlesystem?)
We've used Veritas DBED in the past but moved most of our DBs to ASM on HPUX (and ASMLib flavoured ASM on Linux) -- practically zilch issues compared to when we were on sashimi (raw) and sushi (cooked filesystems with DirectIO).
Cheers!
Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 10:14 AM
тАО01-19-2011 10:14 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
Thanks for the blog pointer. It mentions his problem with only seeing 3 CPU, but it doesn't go into detail though.
For example:
On HPUX NUMA is turned off by default, and he does not mention if HPUX was properly configured for NUMA.
On the Oracle side NUMA, depending on version is controlled through an initialization parmater and only checked at startup time! On 10gR2 and 11gR1 I think it's called "_enable_NUMA_optimization". I don't think even Oracle likes this parm. Now on the 11gR2 there is a new one "_enable_NUMA_support" that Oracle supports.
So on startup, even though Oracle may have the right startup/enable NUMA parm set as "on" for the 10g and later versions - with a caveat that folks miss. Oracle NUMA will first go out and check if the server is set up for NUMA. If it is, then it proceeds with it's next steps to confirm allowing optimization. If the HPUX is NOT set (i.e. LORA_MODE=0), then Oracle NUMA is disregarded and it's optimizations will be disabled.
There's a bunch of other parms and settings that Oracle must give attention to, that clearly in his blog they obviously didn't...but what all of this has shown is that doing a ccNUMA or NUMA configuration requires DBA's & SysAdmin's to work together.
Introducing a whole new concept b/t DBA's and SysAdmins, cause Grid Technology is not for the timid.
Regards,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2011 10:29 AM
тАО01-19-2011 10:29 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
For myself, I will try to be open to the notion of trying/testing Oracle's disk management utility....but at this point in time I can not say that I am in anyway moved to use it in any production environment.
FYI...I was actually a DBA for a very short time, and the one thing it taught me was that I knew nothing about Infrastructure. I say leave HPUX and Storage to the professionals...and unless the DBA is a certified HPUX and certfied Storage person-they shouldn't play with what they do not know.
Just my thoughts,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2011 05:11 AM
тАО01-20-2011 05:11 AM
Re: Experts...Can Use Your Tips On Tuning Large Memory Server
Was hoping to get more parm advice in the event they go with ILM and not NUMA. Although according to one document, Oracle actually has no way of knowing if the box is set up to run with NUMA or not. Now, isn't that interesting!
Guess for tuning parms, if we go ILM (native) I'll have to go by the standards I'm used to and 'tweek' from there.
Kindest regards to all and Many Thanks!
Rita
This thread is now closed.
- « Previous
-
- 1
- 2
- Next »