| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
I
could not get this URL to work, are you sure it is "<FONT face="Times New Roman"
color=#000000>platypus.com".<SPAN
class=428473419-10062001>
I tried www.platypus.com and
it came up with some other non-related site. I would be greatly interested
in reading about this device.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS"
size=2>Fuelspot
<FONT face=Tahoma
size=2>-----Original Message-----From: Nick Wagner
[mailto:Nick.Wagner_at_quest.com]Sent: Friday, June 08, 2001 6:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Veritas Quick I/0 and Oracle/ Asycnchronous I/O
It works just fine, but I think you will actually get more
performance out of a solid state device. Take a look at platypus.com,
they have a SSD device that plugs into the PCI board in your computer...
They claim over 60 MB per second of data transfer. And the drives can go
up to 500 GB... I think they can even daisy chain them if you need
more.
You will only need enough space for the redo logs, control
files, and a locally managed tablespace that holds the data.
It only took us about 20 minutes to install one on a Sparc
Ultra 5 for some testing. And it works great.
Nick
-----Original Message----- From:
MacGregor, Ian A. [<A
href="mailto:ian_at_SLAC.Stanford.EDU">mailto:ian_at_SLAC.Stanford.EDU]
Sent: Friday, June 08, 2001 12:31 PM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>Subject: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Will Oracle use the Quick I/O capability of Veritas on
database writes; that is, will it bypass any file system buffer cache and
write directly to disk? Is the implementation of
asynchronous I/O imnproved in Solaris 8; does one have to use raw
disks or does it now work properly with UFS or Veritas?
I need to configure a machine to provide for the maximum
number of transactions per second. Our Accelerator Controls folks are at
it again, testing how much data they can push into Oracle. They have
backed off the plan of having 6000 Beam Position Monitors sampling at
120 Hz write into the database; although., 720,000 transactions per seconds
might be fun to try. But they do want to see what they can do.
Obviously, the programs which collect the data from BPM's and other sensors
needs to do some buffering. But when they dump to the database I need
the writes to happen as quickly as possible.
The current method of handloing this via ring buffers and
doubly-linked lists. They want to look at replacing the lists with an
Oracle database. Our initial tests will be done using a 4
processor ES-450.
Ian MacGregor Stanford Linear
Accelerator Center ian_at_slac.stanford.edu
 |
 |