- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 9i and disk I/O
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
Forums
Discussions
Discussions
Discussions
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
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
08-30-2004 09:23 PM
08-30-2004 09:23 PM
Last week DBAs upgraded the main database from Oracle 8.1.6 to Oracle 9i.
Now it is working but DBAs complain the disk I/O is slower than before and the process launched is slow (some additional processes post-migration).
I noticed the half physical memory is unused (2.6 GB from 5 GB) as opposite to Oracle 8.1.6 did (95 % of Phy memory was used).
The box is a V2500 class server (8 CPUs and 5 GB memory). Disks are LUNs from an XP512 whose cache memory is 12 GB size. The total amount of disk size is aprox. 850 GB (used by Oracle as raw disks).
I notice that the new SGA size is 800 MB while in Oracle 8.1.6 was 2.6 GB); but DBAs emphatize that the problem resides on disk I/O not in memory usage.
I don't know Oracle but my common sense tells that larger memory is used, fewer physical disk access (recall buffer-cache in HP-UX).
What do you think ? I need your advice
Thanx a lot
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2004 09:32 PM
08-30-2004 09:32 PM
SolutionYou mention buffer-cache. This shouldn't really be an issue with oracle since it has its own "cache" within the SGA. If anything I would expect the SGA of 9i to be larger (oracle tends to grow fatter with newer releases).
I'd definately suggest the SGA needs to be increased to give more buffer!
Get the DBA's to compare the cache-hit-ratio from the old database against the new - almost guaranteed that it will be lower in the new instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2004 09:35 PM
08-30-2004 09:35 PM
Re: Oracle 9i and disk I/O
Absolutely they should look at setting the SGA back to 2.6GB!! An 800MB SGA is small even for a small database, never mind a 850GB one.
HTH
Duncan
I am an HPE Employee

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2004 12:31 AM
08-31-2004 12:31 AM
Re: Oracle 9i and disk I/O
With this kind of matter, evryone should stick to the facts. What does the DBA mean by it's slower? Which kind of test have they done ?
For instance, if you want to prove that the IO subsystem is just a good as it was, use dd to make some test.
If so, that will demonstrate that the Oracle configuration is the issue. Oracle 9 is pretty different from Oracle 8 is many ways, applying the old settings can result in bad performance.
Cheers
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2004 12:53 AM
08-31-2004 12:53 AM
Re: Oracle 9i and disk I/O
Obviously, you will have to put things back regarding number of users and transactions.
What is the explanation for reducing the SGA from 2.6Gb down to 2.6Gb ?
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2004 04:26 AM
08-31-2004 04:26 AM
Re: Oracle 9i and disk I/O
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2004 04:42 AM
08-31-2004 04:42 AM
Re: Oracle 9i and disk I/O
You didn't change that.
These issues probably go to the instance.ora files and settings there.
Oracle tries to buffer disks itself.
The fact that you have physical memory unused gives you the freedom to increased shared memory allocation (ex shmmmax) and tune the init.ora files.
Seems like some dba's didn't do enough QA testing prior to going live.
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-01-2004 05:20 AM
09-01-2004 05:20 AM
Re: Oracle 9i and disk I/O
SGA contains the database buffer cache. Cache holds buffers until dbwriter can do her thing. So if the cache is smaller, then you must write to the disk more often. When the cache is full, you must roll something out to disk before you can roll something in.
Basic question: What does the database adivsor in OEM tell you? It will make recommendation on databasebuffer cache.
SGA contains data dictionary cache. If an data dictionary def is not in the cache, you gotta go walk the disk to find it. Library cache and shared pool also reside in SGA.
As far as the problem being in disk I/O, one must ask one's self "What changed?"
The hardware didn't change. The O/S didn't change. The version of Oracle and the size of the SGA did. The performance advisor is your friend. Have a look at it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2004 08:36 AM
09-01-2004 08:36 AM
Re: Oracle 9i and disk I/O
We were able to test for three months prior to going into production.
Our application may be different but here is what we did:
1. Verified Kernel parameters with Oracle
( we had to adjust some size settings)
2. We also discovered that 64 bit Oracle was more processor intesive tha 32 bit 8.1.7
3. We use FS so that the Sys Admin can monitor the disk.
4. We actually increased our SGA by 25%.
( How were you able to use 2.6 before when 1.8 was a threshold ?)
5. It is also very common for the new database to become fragmented because it grew and indexes are different.
It took weeks to smooth everything over and we were the first to do this conversion wothout Oracle on site in 2002.
We have assisted many through forums since.
Here is a major obsevation from your question:
You are the only location that I am aware of that has REDUCED the SGA.
You do know that SGA reduction increases disk usage for any process that exceds the SGA.
The bottom line is that the SGA is causing the increased I/O
Tony
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-08-2004 08:38 PM
09-08-2004 08:38 PM