Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Is it just me
Logminer won't help me track the WHO, especially since in this case the who is obscured through connection pooling and only available to the database via an explicitly set application context.
AQ or custom-built messaging systems are certainly cool and fun technology, but perhaps overkill?
If I list partition by table_name, then how is the contention on my single table any different than having a separate table per table_name? (ignoring momentarily my desire to elegantly "slide" data off, which could be handled less elegantly to avoid contention issues instead).
I need to poke around and gather numbers related to the number of concurrent transactions I expect to support as well, since again, I am not auditing the whole database, mostly setup/parameter data.
Regards,
Lisa
Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
Before AQ was there, I built my own version using dbms_alert messaging
combined with a message table. The alert gets sent at commit-time.
Otherwise dbms_pipe can help.
The handler was just waiting for an alert, en when it was received, it
started to empty the queue at a moderate rate. When the queue was empty,
it started sleeping waiting again. I just don't like polling.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
> This FB/AQ one is quite interesting idea though and if you don't like AQ,
> you could implement it with autonomous triggers and custom message
> polling/handling solution.
>
> Tanel.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Aug 12 2004 - 10:24:33 CDT