RE: Replicating Sequences...

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Tue, 25 Mar 2003 22:38:35 -0800
Message-ID: <F001.00572CEF.20030325223835@fatcity.com>

1. - No support in replication for replication of sequences that I'm aware of. This is one of the shortcomings of replication (among other things).
2. How about running some test queries that you know baseline response times every four hours and monitoring the response time and alerting if they bust a set threshold.

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com!

-----Original Message-----
Sent: Tuesday, March 25, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L

Hi to everybody!

I would like to get a bit of help with:

1.- Can I replicate sequences on a Master to Master site? What are the implications on this?

2.- I'm going to have a Master to Master replication site and it's going to have 4 hours of INTENSIVE insertion of data DAILY and, of course, query of data, the question is:

How can I measure the response times on that 4 hours? I would like to be able to calculate an aproximate response times!

Any ideas?

Thanks in advance!
JL

---

Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jose Luis Delgado
  INET: joseluis_delgado_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Freeman Robert - IL
  INET: FREEMANR_at_tusc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 26 2003 - 00:38:35 CST