Queueing System for Oracle Database

[Guest]

Hi everybody,
what we want to do is queue the input of measuring data that runs into
an oracle database during several tests, as it is too many to store
them in real time.
has anybody done something like this before?
does anybody know if there exist any tools/software with database
interfaces?
I have heard that oracle offers some queueing possibilities? does
anyone know more about that?
some links/literature would be helpful as well,

thanks a lot.
dagmar

[Guest]

Look for the Advanced Queuing facility, at

http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96587/qintro.htm#ADQUE001

--
Sybrand Bakker
Senior Oracle DBA

[DA Morgan]

dagmar.koehn@gmail.com wrote: Hi everybody, what we want to do is queue the input of measuring data that runs into an oracle database during several tests, as it is too many to store them in real time. has anybody done something like this before? does anybody know if there exist any tools/software with database interfaces? I have heard that oracle offers some queueing possibilities? does anyone know more about that? some links/literature would be helpful as well, thanks a lot. dagmar

Demos under Advanced Queuing in Morgan's Library at www.psoug.org

HTH
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Peter Sylvester]

Oracle's "AQ" product is bundled with the database, but it ultimately
writes messages to a DB table, so it might not be fast enough.

How much data are we talking and how fast?
If you've got the memory you could just load it all up into RAM, and
transfer it to the DB after. If you don't have the memory you will need
to put it to disk.

You might want to look in the the "Times Ten" DB that Oracle recently
bought, which does some form of in-core DB. I have not actually used
it, but its downloadable from OTN.

--Peter

dagmar.koehn@gmail.com wrote: Hi everybody, what we want to do is queue the input of measuring data that runs into an oracle database during several tests, as it is too many to store them in real time. has anybody done something like this before? does anybody know if there exist any tools/software with database interfaces? I have heard that oracle offers some queueing possibilities? does anyone know more about that? some links/literature would be helpful as well, thanks a lot. dagmar

[Hans Forbrich]

On Thu, 15 Sep 2005 19:27:06 -0400, Peter Sylvester interested us by
writing:
Oracle's "AQ" product is bundled with the database, but it ultimately writes messages to a DB table, so it might not be fast enough.

I agree that AQ might not be fast enough in some circumstances, then
again under some conditions any message queue system might be 'too slow'.
Oracle has improved the performance a lot over the various versions - from
awful in the beginning (8.0 and earlier) to acceptable for many apps, to
'fast'. However, 'fast' is relative and must be tested.

To OP - AQ is considered part of the ORacle database 'integration'
technology. There are white papers and tutorials about it at
http://otn.oracle.com - go to database, then integration.



Just had a moderately relevant thought earlier today, and want to check
whether anyone has done it yet ... with the USB memory keys/sticks so
inexpensive (Cdn$70 for a GB) has anyone tried putting a tablespace on the
key (and tested performance). Yes there are risks, but ...


--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

[Dagmar]

Thanks a lot for your comments- I didn't bring the paper today, but I
can tell you tomorrow/tonight about how much data it really is. I am
just not sure now. How you drop by tomorrow again, thanks again :)
Dagmar