- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8.1.7.0 bad performances over 11.i. Why...
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-29-2003 12:56 AM
тАО01-29-2003 12:56 AM
Oracle 8.1.7.0 bad performances over 11.i. Why?
Otherwise, the same database over other machine, ( smaller ), running 11.0 goes very fast.
I have been looking for information and I have found something about install patches like PHSS_24303 over 11.00, so witch is the patch to 11.i. ( this is because I think the problem could be I need to install some patch ).
Please, Help.
Thanks in advance.
Juanma.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2003 01:32 AM
тАО01-29-2003 01:32 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
this is the recommend patches for oracle 8.1.7 to hp-ux 11.11
6. C++ runtime libs
Current Revision of Patch:
PHSS_26946 - s700_800 11.11 HP aC++ -AA runtime libraries (aCC A.03.37)
Patch in latest Support Plus Patch Bundle? Yes, as PHSS_22898.
5. asyncio driver patch
- slow database startup with large SGAs
Current Revision of Patch:
PHKL_25506 - s700_800 11.11 asyncio driver patch
Patch in latest Support Plus Patch Bundle? Yes, as PHKL_25506.
4. ONC/NFS General Release/Performance Patch
Current Revision of Patch:
PHNE_26388 - s700_800 11.11 ONC/NFS General Release/Performance Patch
Patch in latest Support Plus Patch Bundle? Yes, as PHNE_26388.
3. ld and linker tools cumulative patch
Current Revision of Patch:
PHSS_26560 - s700_800 11.11 ld(1) and linker tools cumulative patch
Patch in latest Support Plus Patch Bundle? No.
2. libc cumulative patch
Current Revision of Patch:
PHCO_27740 :s700_800 11.11 libc cumulative patch
Patch in latest Support Plus Patch Bundle? Yes, as PHCO_25452.
1. libc cumulative header file patch
Current Revision of Patch:
PHCO_24402 :s700_800 11.11 libc cumulative header file patch
Patch in latest Support Plus Patch Bundle? Yes, as PHCO_24402.
please also give us the output of the kmtune -l
and alos tell us if you can see what is overload when your perforamce is not good
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2003 01:32 AM
тАО01-29-2003 01:32 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
1.check the kernel parameters as whether they are properly tuned.
you can cross check the two systems.
One of the imp. parameter is the buffer cache parameter.
The default value is half the memory allocated.
dbc_max_pct.Make sure that you bring this value down.
2.How about the swap setup?
3.How about the I/O distribution for the database.
Have you distibuted the datafiles and logfiles accordingly.Were you running asynchronous mode on the other server/Were there any extra mount options in the 11.0 server for good performance.
2.How about the Oracle database setup.
Are the Initialization parameters in the init
check whether the database on 11.0 running on dedicated or shared server mode?
check whether the temp and rollback segments are okay in the database?
check and revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2003 02:19 AM
тАО01-29-2003 02:19 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
1. Are you running MTS or dedicated server mode?
2. What is the database initiation parameters? Are they the same?
3. have you applied the latest available patchset for the base release 8.1.7? i.e. 8.1.7.4 PATCH SET
Please post these details.
Thanks
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2003 03:01 AM
тАО01-29-2003 03:01 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
I will try to install the recomended patch.
I will tell you how it works.
Juanma.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2003 07:57 AM
тАО01-29-2003 07:57 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
The problem is that Oracle updates run very slow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 02:40 AM
тАО01-30-2003 02:40 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
You could compare the results between the two server and verify if db parameters are correctly setted up.
Stefano
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 03:08 AM
тАО01-30-2003 03:08 AM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
The other thing you can do now is to enable timed_statistics and run a Statspack report.
If you have already located the program which is causing the problem, try to use SQL TRACE and analyze the tkprof output.
If you need further help, let us know.
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 12:23 PM
тАО01-30-2003 12:23 PM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
Try this data collection script to find out.
P
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
тАО07-24-2003 03:11 PM
тАО07-24-2003 03:11 PM
Re: Oracle 8.1.7.0 bad performances over 11.i. Why?
We are experiencing the same problem with very slow Oracle updates. I was wondering if you ever resolved this issue.
Thanks