- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Disk caching with Oracle
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
тАО03-27-2002 01:21 PM
тАО03-27-2002 01:21 PM
Disk caching with Oracle
Currently and previously we have just used JBOD disk subsystems and mirrored with Mirror Disk UX.
My concern is the data corruption possiblities that could accure due to disk caching.
Does anyone have anthing good or bad to say about this configuration. HP tells me this is pretty solid, and they have many Oracle clients doing this.
Any input would be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 01:28 PM
тАО03-27-2002 01:28 PM
Re: Disk caching with Oracle
You want disk caching, because the IO is about a million times faster than waiting for an IO fetch or confirmation of a disk write.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 01:41 PM
тАО03-27-2002 01:41 PM
Re: Disk caching with Oracle
Unless you are using raw/io (or the OnlineJFS equivalent), you really have the same problem if your host crashes after you have written to buffer cache but before you have actually written to disk. This is especially true if you are running async_io.
If you still want a high-performance array that specfically, intentionally uses no cache, check out XioTech's Magnitude at
http://www.xiotech.com/products.asp. In this case, you would actually purchase two units are mirror them exactly as you would your JBODS - just a whole lot bigger.
Regards, Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 06:41 PM
тАО03-27-2002 06:41 PM
Re: Disk caching with Oracle
Data corruption is just as likely to occur in the hundreds of circuits inside the disk as it might in the cache. And today's disks have very low failure rates. Usually the disks are scrapped because they are just too small rather than wearing out or failing electronically.
Generally, the larger the cache, the better the performance. Big disk arrays have gigabytes of RAM because disks are still way slower than memory.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2002 03:22 AM
тАО03-29-2002 03:22 AM
Re: Disk caching with Oracle
The Oracle 8i HP-UX Administrator's Guide has this to say about Async IO and it should give you an idea about how Oracle goes about dealing with data writes:
---------------------
Asynchronous I/O uses a special HP device driver to batch writes and reads to
shared memory segments. A number of writes/reads can be made with one system
call. The device driver kicks off multiple I/O operations at a low level where disk
scheduling can be optimized for maximum parallelization, and minimum HP-UX
overhead.
This type of async is safe. Oracle is reliably notified if the data made it all the way to
disk or not. Transactions and database writes are not committed until Oracle knows
that the I/O has been completed.
The asynchronous I/O pseudo-driver on HP-UX allows the Oracle Server to
perform I/O to raw disk partitions using an asynchronous method, resulting in less
I/O overhead and higher throughput. You can use the asynchronous I/O
pseudo-driver on both HP 9000 Servers and Workstations.
-------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2002 02:44 PM
тАО04-01-2002 02:44 PM
Re: Disk caching with Oracle
The cache on the 7400 is battery backed and should be impervious to corruption due to power failure.
The cache will provide performance boost on write() operations and sequential read operations out of oracle.
This has nothing to do with the async capabilities of Oracle.
Bill Mac, most modern disks do have small caches on board (1-4MB), but default HP-UX behavior is not to do "immediate reporting" on the JBOD type disks. Turning on "immediate reporting" can give - array like write times ( sub millisecond).
If your organization can afford it, use some smaller 15,000 RPM drives for the following heavy activity Oracle areas:
redo, rollback, temp. Datafiles and indexes can live on larger and slower drives.