- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g Impact
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-04-2005 08:55 AM
тАО01-04-2005 08:55 AM
I am planning to upgrade Oracle817 to 10g, but looking at the kernel configuration change requirements (quite a few parameters increases), I feel there must be some performance impact on the box.
Is there anyone who can comment this?
Thanks.
Steven
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2005 01:56 PM
тАО01-04-2005 01:56 PM
SolutionYes upgrading from oracle 8i to 10g will involve in kernel parameters changes. When you say impact on the machine, well it depends on what other applications and databases you have got on the same server.
As a systems administrator, one will often be confronted with users who say that the response time on the system is unacceptable. What is unacceptable performance? There are two sides to this:
1) Quantifiable performance and the 2) Unmeasurable performance like user dissatisfaction.
Performance tuning Oracle databases can be divided into three subcategories:
1. Application tuning
2. RDBMS tuning
3. UNIX system tuning
For example the shared memory feature of the Unix operating system is required by Oracle. The System Global Area (SGA) resides in shared memory; therefore, enough shared memory must be available to each Oracle process to address the entire SGA.
If you create a large SGA and a large portion of your machine's physical memory is devoted to the shared memory, it will resulting in poor performance. However, there are also performance benefits to having your entire SGA located in shared memory. Therefore, when sizing your SGA, you need to balance Oracle performance needs with the demands your machine and operating system can meet without suffering performance degradation
So when upgrading the database after you got confirmation that your applications are supported and certified on the new Oracle Database Version you are moving to, it is highly recommended that you do test upgrade/migrate. This will allow you to test the process it self and also you will be able to test the upgraded DB performance under workload similar to the workload on the production DB. Doing so will allow you to discover problems earlier and fix them without affecting the production DB availability to the end users.
The following steps help you diagnose performance problems after upgrade/migrate
1- Clearly identify the problem.
Is the problem in general DB performance problem (i.e. every thing is slow in the DB) or it's specific to a certain application or SQL statement? This is very important question you have to answer before you proceed because it will determine what information we need to collect to identify and solve the problem.
(A) Database level problem
If every thing in the DB is running slower in the new version then a good point to start diagnosing the performance problem is the statspack report and OS statistics. Get a statspack report and OS statistics for the DB now when you have the problem and compare it to similar statspack report and OS statistics taken before upgrade (baseline).
If you identified some SQL statement to be the source of the DB slowdown, then you can also consider getting trace files generated from
(B) SQL statements Problem
If you have identified the problem to be only with certain application and/or SQL statement then you need to concentrate on this SQL statement and find out why it is running slower now and try to tune it. Again getting trace files generated from
Incase of SQL statements performance problems we looks for differences between the execution plans from before and after the upgrade, we look for wait events, statistics like number of physical and logical reads and many other thing available in the trace files.
2- Identify differences
Find the differences between different statistics and trace files you collected from before and after the problem. This information should guide you to the right path to solve the problem.
3- Tune it.
After you identify the problem, you should work on tuning it. The tuning process is outside the scope of this note but you can use the information you collected from step 1 and 2 to search Metalink and you should find plenty of information.
Attached is a document of few features og Oracle 10g regarding performance.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2005 10:20 PM
тАО01-04-2005 10:20 PM
Re: Oracle 10g Impact
for my 10g installation i had to adjust only a few of the parameters in the list:
====================================
KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (2+MSGMNI)
MSGMNI NPROC
MSGSEG 32767
MSGTQL 4096
NCSIZE (NINODE+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC -4)
SEMVMX 32768
SHMMAX AvailMem
SHMMNI 512
SHMSEG 120
VPS_CEILING 64
====================================
Most probably because i had already finetuned it previously for running 9iAS. For sure, you will be requiring more memory...
good luck
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2005 01:36 AM
тАО01-05-2005 01:36 AM
Re: Oracle 10g Impact
I would list a specific example for your opinion:
My box has 4G mem with conf. of dbc_max_pct 5%, min 3%, sga 1.6G, shmmax=1073741824, running Oracle 817.
If going to 10g with the recomm. kernel conf., do I see performance impact? Would more mem be needed, according to your experience?
Very appreciated!
Steven
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2005 02:04 AM
тАО01-05-2005 02:04 AM
Re: Oracle 10g Impact
Are you running the 32bits or 64 bits version (Oracle8i) ?
Shmmax in my view should be greater than your SGA (so in one segment).
Before you upgrade take a baseline for performance you can compare with in the future.
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2005 02:49 AM
тАО01-05-2005 02:49 AM
Re: Oracle 10g Impact
SGA will have to be changed. You will probably need to tune the box in general.
Forget about the upgrade if you have less than 2 GB of Ram on the box. It could push low memory machines into paging mode.
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-05-2005 03:34 AM
тАО01-05-2005 03:34 AM
Re: Oracle 10g Impact
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2005 04:00 AM
тАО01-05-2005 04:00 AM
Re: Oracle 10g Impact
I would put 4Gb for shmmax if you have 4Gb RAM on the box.
This is only a high water mark, it does not mean your SGA has to be that big.
Of course if you have opportunity (and budget) to increase the memory, Oracle will be pleased to use it !
In any case don't page !
http://docs.hp.com/en/TKP-90202/re87.html
http://docs.hp.com/en/939/KCParms/KCparam.ShMmax.html
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2005 04:09 AM
тАО01-05-2005 04:09 AM
Re: Oracle 10g Impact
you may read these threads too.
http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0x8f2e8f960573d611abdb0090277a778c%2C00.html&admit=716493758+1104944507832+28353475
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=745598
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2005 12:06 PM
тАО01-05-2005 12:06 PM
Re: Oracle 10g Impact
Refer to the attached document.
Indira A