Re: Quest....
We run Spotlight here, although I go right to the various v$ tables. I did notice some quirkiness in how Spotlight's 'Top 10 SQL' lists rows. It's like it returns # of rows for a static query (e.g. select 'Y' from some_table where some_predicate = :b1) as '1' although it's executed with separate predicates a large number of times, which of course also skews its overall statistics. A bit confusing. Adam "Jonathan Lewis" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/08/2004 08:44 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject Re: Quest The number of sites I go to that use spotlight to keep a check on the top 10 SQL statements - it's weird, but it always seems to be this query against v$sqlarea. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 4:29 PM > I'm TOADing and Spotlighting right now... :) > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
Now I get the question. Sorry about that. -Original Message- but it needs windows os to run ... Right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
but it needs windows os to run ... Right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 08, 2004 12:00 PM To: Multiple recipients of list ORACLE-L As far as I know (which isn't real far), spotlight just uses the Oracle client. -Original Message- Has anyone tried to run spotlight on linux with windows crossover software? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
As far as I know (which isn't real far), spotlight just uses the Oracle client. -Original Message- Has anyone tried to run spotlight on linux with windows crossover software? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
I agree. Spotlight and SQL Navigator interfaces are very straightforward. While you still have to do the analysis and understand the database architecture it makes it much easier to gather all the necessary information so that you can concentrate on resolving the issue and not on gathering the information. Also, for the more junior DBA's it provides some useful starting point and help to point that person in the right direction. The solutions suggested may not be appropriate all the time. However, I have found Spotlight straightforward to use for both the Oracle and SQL Server environments. It allows me basically to pinpoint locking issues and performance issues and then quickly get to the exact SQL statement involved. From there I need to resolve the issue - suggest rewrite of SQL which I still need to understand the CBO for. However, the research is much much quicker. SQL Navigator offers team coding library functions, standard formats for stored procedures and a straightforward interface for both PL/SQL and SQL - from writing stored procedures to verifying and creating database structures. Now, I have just started looking into OEM v 9i and have noted that the interface is better in this last release and that it has some advantages Spotlight doesn't. Hate to say it but I use SQL Nav. for creating PL/SQL and some basic SQL testing. I use Spotlight for real-time performance issues - as a starting point I use OEM for storage, security, schema management I use the various Oracle traces for more in-depth tuning. Each of the above has its advantages and do something better than the others. I want to be able to have one tool - however, I have found that these tools do something better than others. In the SQL Server land I use QE for creating SQL and stored procedures I use profiler that comes with EM for tracing specific SQL and getting explain plans I use Spotlight for general overall real-time performance analysis of what is happening right now on my system. Of course, I still have my own little bag of scripts..Yikes! -Original Message- Jesse, Rich Sent: Thursday, January 08, 2004 11:30 AM To: Multiple recipients of list ORACLE-L I'm TOADing and Spotlighting right now... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L I like Spotlight. It's about the only GUI type thing I use. It provides a lot of info in a handy format. You still have to use your brain to interpret the info, but you at least have a convenient way of collecting the info. -Original Message- Hey Any thoughts on that quest material? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Quest....
The number of sites I go to that use spotlight to keep a check on the top 10 SQL statements - it's weird, but it always seems to be this query against v$sqlarea. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 4:29 PM > I'm TOADing and Spotlighting right now... :) > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
Has anyone tried to run spotlight on linux with windows crossover software? Just curious ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 08, 2004 11:30 AM To: Multiple recipients of list ORACLE-L I'm TOADing and Spotlighting right now... :) Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
I'm TOADing and Spotlighting right now... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L I like Spotlight. It's about the only GUI type thing I use. It provides a lot of info in a handy format. You still have to use your brain to interpret the info, but you at least have a convenient way of collecting the info. -Original Message- Hey Any thoughts on that quest material? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
I like Spotlight. It's about the only GUI type thing I use. It provides a lot of info in a handy format. You still have to use your brain to interpret the info, but you at least have a convenient way of collecting the info. -Original Message- Hey Any thoughts on that quest material? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest....
Um yes, my thought is you sent this to the wrong email list? :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Sent: Thursday, 8 January 2004 5:25 PM To: Multiple recipients of list ORACLE-L Hey.... Any thoughts on that quest material? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 630.819.9077 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Pete Sharman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Quest....
Hey Any thoughts on that quest material? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 630.819.9077 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Quest People
=) Thanks. If you happen to read about me in FORTUNE or FORBES in the future, you'll know you helped make it possible! =) Jacques Kilchoer wrote: > I forwarded this to someone in our company. I hope that soon untold > riches will be yours! > > > -Original Message- > > From: Maria Aurora de la Vega [mailto:[EMAIL PROTECTED] > > > > I'm looking for listers who happen to work for Quest. > > > > I would like to get information as to who/how to contact the marketing > > (?) dept. > > We are interested in reselling Quest products/becoming a > > Quest partner. > > We have sent email to the address indicated in your corporate website, > > but we still have not received any replies yet. > > > > I hope someone from Quest can read this and can forward this query to > > the right person. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jacques Kilchoer > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Maria Aurora de la Vega INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Quest People
I forwarded this to someone in our company. I hope that soon untold riches will be yours! > -Original Message- > From: Maria Aurora de la Vega [mailto:[EMAIL PROTECTED] > > I'm looking for listers who happen to work for Quest. > > I would like to get information as to who/how to contact the marketing > (?) dept. > We are interested in reselling Quest products/becoming a > Quest partner. > We have sent email to the address indicated in your corporate website, > but we still have not received any replies yet. > > I hope someone from Quest can read this and can forward this query to > the right person. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Quest People
Hello, I'm looking for listers who happen to work for Quest. I would like to get information as to who/how to contact the marketing (?) dept. We are interested in reselling Quest products/becoming a Quest partner. We have sent email to the address indicated in your corporate website, but we still have not received any replies yet. I hope someone from Quest can read this and can forward this query to the right person. Thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora de la Vega INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: quest SharePlex
Nick, Thanks for the notes. I've often wondered how Shareplex did its thing. Just for kicks - have you tried writing a collision handler for streams ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 22 January 2003 18:09 >Would the same thing work if you shut down the >Shareplex processes after the row had chained, >and restarted them before you updated the chained >piece ? >-- Yes > >And does Shareplex guarantee that it will >never report a 1555 error regardless of how long it >is shut down ? >-- No, if there are massive amounts of transactions, we can still blow >rollback segments, nothing will happen to the source DB instance, but it >will effect replication. Part of the implementation goes through checking >the RBS to make sure that we can handle the volume and the amount of >activity you are generating. We have had customers who have shut down >SharePlex for 2-3 hours, and when it comes up, replicates everything during >those 2-3 hours just fine... even if it has been moved into the archive >logs. > >yes, the supplemental logging is not the greatest thing Oracle ever did, but >it was probably one of the easiest ways to implement it. Just for kicks... >do a couple small batch jobs (maybe 2-3 million row changes) and see how >long it takes, and how much redo it generates. Then do the same thing with >Streams replicating that job... how long does it take, and how much redo is >generated. Streams uses the supplemental logging, and their capture >process reads from the redo logs, then puts the transaction right back into >the database (in Advanced Queues) which generates more logs, then they >dequeue the operation (generating more logs again) to post it to the target >machine. > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest SharePlex
Title: RE: quest SharePlex Would the same thing work if you shut down the Shareplex processes after the row had chained, and restarted them before you updated the chained piece ? -- Yes And does Shareplex guarantee that it will never report a 1555 error regardless of how long it is shut down ? -- No, if there are massive amounts of transactions, we can still blow rollback segments, nothing will happen to the source DB instance, but it will effect replication. Part of the implementation goes through checking the RBS to make sure that we can handle the volume and the amount of activity you are generating. We have had customers who have shut down SharePlex for 2-3 hours, and when it comes up, replicates everything during those 2-3 hours just fine... even if it has been moved into the archive logs. yes, the supplemental logging is not the greatest thing Oracle ever did, but it was probably one of the easiest ways to implement it. Just for kicks... do a couple small batch jobs (maybe 2-3 million row changes) and see how long it takes, and how much redo it generates. Then do the same thing with Streams replicating that job... how long does it take, and how much redo is generated. Streams uses the supplemental logging, and their capture process reads from the redo logs, then puts the transaction right back into the database (in Advanced Queues) which generates more logs, then they dequeue the operation (generating more logs again) to post it to the target machine. -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 12:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: quest SharePlex Very cute - this tends to suggest that Shareplex is spotting the appearance of chains in the log and storing the list of rowids. Would the same thing work if you shut down the Shareplex processes after the row had chained, and restarted them before you updated the chained piece ? And does Shareplex guarantee that it will never report a 1555 error regardless of how long it is shut down ? Your comment about supplemental logging is interesting - to me, one of the issues with using the official method for logical standby is that you have to have supplemental logging switched on at the database level. This means, as you have obviously spotted, that tables without primary keys get whole rows copied into the log. Worse still, because supplemental logging is effected through the UNDO, global temporary tables have an extra impact on the stream too. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 21 January 2003 19:01 >This is actually part of the 'magic' of SharePlex. The way we obtain the PK >information from the database if the PK was not modified is very tricky. > >1) shutdown SharePlex (stop all processes on the source machine, so >SharePlex is not even up and running) >2) insert a row. >3) update that row to cause chaining. >4) update the row again in the chained piece and don't modify the PK. >5) delete the row >6) start SharePlex back up. > >Did everything replicate successfully? Yep. :) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: quest SharePlex
Very cute - this tends to suggest that Shareplex is spotting the appearance of chains in the log and storing the list of rowids. Would the same thing work if you shut down the Shareplex processes after the row had chained, and restarted them before you updated the chained piece ? And does Shareplex guarantee that it will never report a 1555 error regardless of how long it is shut down ? Your comment about supplemental logging is interesting - to me, one of the issues with using the official method for logical standby is that you have to have supplemental logging switched on at the database level. This means, as you have obviously spotted, that tables without primary keys get whole rows copied into the log. Worse still, because supplemental logging is effected through the UNDO, global temporary tables have an extra impact on the stream too. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 21 January 2003 19:01 >This is actually part of the 'magic' of SharePlex. The way we obtain the PK >information from the database if the PK was not modified is very tricky. > >1) shutdown SharePlex (stop all processes on the source machine, so >SharePlex is not even up and running) >2) insert a row. >3) update that row to cause chaining. >4) update the row again in the chained piece and don't modify the PK. >5) delete the row >6) start SharePlex back up. > >Did everything replicate successfully? Yep. :) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest SharePlex
Title: RE: quest SharePlex This is actually part of the 'magic' of SharePlex. The way we obtain the PK information from the database if the PK was not modified is very tricky. I can tell you some of the 'magic' but not all of it. (NDA type stuff) In all updates the redo logs contain the rowid for the row being modified (or piece of row in chained row cases) and we use that rowid to go back into the database and grab the PK information. All that is pretty simple, the real magic comes in when you do something like this... (QA does this type of operation all the time) 1) shutdown SharePlex (stop all processes on the source machine, so SharePlex is not even up and running) 2) insert a row. 3) update that row to cause chaining. 4) update the row again in the chained piece and don't modify the PK. 5) delete the row 6) start SharePlex back up. Did everything replicate successfully? Yep. :) We've looked at turning on the supplemental logging and it causes more overhead then our quick search. And is not really on option for large environments like Oracle Apps or other ERP's that have 1000's of tables, many of them that don't have a PK at all. -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 19, 2003 2:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: quest SharePlex Thanks for the reply. That covers the object/data_object id problem, and gives the ability to identify which columns in the dump are the primary key columns. But when you update a row, the redo will only contain the primary key if the primary key has been modified, so you should hardly ever find it in the redo. Does this mean you trap the primary key on every insert and keep a cross reference between primary keys and rowids somewhere, or do you do a lookup back into the database in real time to translate rowids into primary keys ? Oracle, of course, gets around this problem in version 9 with the 'supplemental logging' feature - which Shareplex could probably use to even better effect, but how do you do it before 9 ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 18 January 2003 01:15 >You provide a 'configuration file' which is just a flat file of table names >on the source machine and table names on the target machine. Then we go >through an activation process that takes the table name on the source and >grabs the object id from Oracle and the primary key columns (if no primary >key, we use all the columns except for LOB's and LONGs). Then the capture >process scans through the redo logs only capturing changes to object ids in >our list. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest shareplex
Title: RE: quest shareplex Has anyone used Oracle Streams for simple "A" to "B" replication? Likes/dislikes? Can it be used in 8.1.7? Thanx, Alan Martin Defense Logistics Information Service [EMAIL PROTECTED] -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: quest shareplex I'm sure you know Oracle has a new product "Oracle Streams" that does the same: http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server .920/a96571/strmover.htm#43906 Waleed -Original Message- Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list ORACLE-L I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re[2]: quest shareplex
Hi, I have used Shareplex for a number of years now, albeit with a relatively simple configuration (bi-directional master-to-master replication across a WAN). We had a few teething problems with earlier versions of the software, but since our last upgrade about 18months ago, we have had no problems. I have found it easy to use, and best of all it hardly affects our WAN traffic at all. Hope this is of some help. Ceri -- CeriDatabase Administrator mailto:[EMAIL PROTECTED] ICQ:153010767 "I love deadlines. I like the whooshing sound they make as they fly by." Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: quest SharePlex
Thanks for the reply. That covers the object/data_object id problem, and gives the ability to identify which columns in the dump are the primary key columns. But when you update a row, the redo will only contain the primary key if the primary key has been modified, so you should hardly ever find it in the redo. Does this mean you trap the primary key on every insert and keep a cross reference between primary keys and rowids somewhere, or do you do a lookup back into the database in real time to translate rowids into primary keys ? Oracle, of course, gets around this problem in version 9 with the 'supplemental logging' feature - which Shareplex could probably use to even better effect, but how do you do it before 9 ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 18 January 2003 01:15 >You provide a 'configuration file' which is just a flat file of table names >on the source machine and table names on the target machine. Then we go >through an activation process that takes the table name on the source and >grabs the object id from Oracle and the primary key columns (if no primary >key, we use all the columns except for LOB's and LONGs). Then the capture >process scans through the redo logs only capturing changes to object ids in >our list. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest SharePlex
Title: RE: quest SharePlex You provide a 'configuration file' which is just a flat file of table names on the source machine and table names on the target machine. Then we go through an activation process that takes the table name on the source and grabs the object id from Oracle and the primary key columns (if no primary key, we use all the columns except for LOB's and LONGs). Then the capture process scans through the redo logs only capturing changes to object ids in our list. configuration file is pretty simple... source_owner.source_table target_owner.target_table [EMAIL PROTECTED] so to replicate scott.emp to scott2.emp2 on system XYZ, with instance ORCL it would be... scott.emp scott2.emp2 [EMAIL PROTECTED] However, it can get complicated if you want to replicate only certain columns, or only certain rows. -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: quest shareplex Since the redo log contains only details about object id, row location, and changed values , how do you derive a table-name and key value for the SQL to be applied ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 17 January 2003 19:25 >I was going to keep quite... but here goes. :) >- > >Yes, of course I'll be glad to help. > >Basically... > >Log Based replication for Oracle. A capture process continually reads the >online redo logs and parses out information based on a list of tables you >provide. The raw redo log data is then converted into standard Oracle SQL, >and using OCI calls is posted to target database(s). The target(s) are >fully open and available, so you can do peer-to-peer, reporting, failover, >DR, upgrades, migrations... > >No SQL*Net, no Streams, no AQs, no triggers, no OAR. > >It's a pretty broad product, so if you need more info, just let me know. > >Nick > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest shareplex
I'm sure you know Oracle has a new product "Oracle Streams" that does the same: http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server .920/a96571/strmover.htm#43906 Waleed -Original Message- Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list ORACLE-L I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: quest shareplex
Since the redo log contains only details about object id, row location, and changed values , how do you derive a table-name and key value for the SQL to be applied ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 17 January 2003 19:25 >I was going to keep quite... but here goes. :) >- > >Yes, of course I'll be glad to help. > >Basically... > >Log Based replication for Oracle. A capture process continually reads the >online redo logs and parses out information based on a list of tables you >provide. The raw redo log data is then converted into standard Oracle SQL, >and using OCI calls is posted to target database(s). The target(s) are >fully open and available, so you can do peer-to-peer, reporting, failover, >DR, upgrades, migrations... > >No SQL*Net, no Streams, no AQs, no triggers, no OAR. > >It's a pretty broad product, so if you need more info, just let me know. > >Nick > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest shareplex
Title: RE: quest shareplex I was going to keep quite... but here goes. :) - Yes, of course I'll be glad to help. Basically... Log Based replication for Oracle. A capture process continually reads the online redo logs and parses out information based on a list of tables you provide. The raw redo log data is then converted into standard Oracle SQL, and using OCI calls is posted to target database(s). The target(s) are fully open and available, so you can do peer-to-peer, reporting, failover, DR, upgrades, migrations... No SQL*Net, no Streams, no AQs, no triggers, no OAR. It's a pretty broad product, so if you need more info, just let me know. Nick -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: quest shareplex Quest Shareplex is a replication software. Nick Wagner from Quest is on this list and he is been very helpful and I am sure he will be glad to provide you info on it. Right Nick? :) -Original Message- Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list ORACLE-L I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Richard Ji INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest shareplex
Title: RE: quest shareplex It allows for master to master replication. My understanding is that Oracle's Data Guard now does the same thing. Shareplex was faster then replication with less latency because it would read from the online redo files from Oracle. I understand that Data Guard now does the same thing. It is a quest product and you can find more info at www.quest.com plus quest has a number of saved online webcasts and some involve shareplex. Good luck. Having experience with it it is somewhat of a bear to configure and work in any specific environment/database - at least in recent past versions. -Original Message- From: Joseph S Testa [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Subject: quest shareplex I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: quest shareplex
Quest Shareplex is a replication software. Nick Wagner from Quest is on this list and he is been very helpful and I am sure he will be glad to provide you info on it. Right Nick? :) -Original Message- Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list ORACLE-L I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Richard Ji INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
quest shareplex
I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Experience with Quest Shareplex
Thanks Raj, had a laugh over that one. My instant reaction is that the sales rep sensed that there wasn't going to be a pot of gold at the end of that rainbow and decided to donate his problem to his competitor. Seriously, I've found that replication is one of those things that looks better the further you are from it. On closer inspection, it doesn't look so great. Organizations often run into problems and think that by flipping the magic replication switch, all their problems will disappear. The vendor hopes that the ink dries on the check before reality sets in. Your organization needs to take a careful look at what problems they are experiencing and their alternatives for dealing with those problems. In terms of WAN response, there are a lot of alternatives that should be considered before resorting to replication. Once those alternatives have been exhausted, then a careful study of the replication requirements should be undertaken. Then you are in a position to discuss your needs knowledgeably with vendors, and to be taken seriously by them. Replication can solve problems, but it can also create even greater problems, so it needs careful study. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] <mailto:dwilliams@;lifetouch.com> -Original Message- Sent: Monday, October 28, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Unfortunately this was from vendor's sales rep. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, October 28, 2002 1:19 PM To: Multiple recipients of list ORACLE-L >From indirect experience it is another layer of administration and requires some manually steps depending on the configuration of your database/system. Again, for that reason might want to consider Oracle's similar product that way you won't get stuck in the vendor vs. vendor he-said/she-said thing. -Original Message- Sent: Monday, October 28, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Last I heard about shareplex that it still had some problems with IOTs and user defined types ... they seems to be working on those though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, October 28, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought. -Original Message- <mailto:SCHAUPE@;mail.northgrum.com> ] Sent: Monday, October 28, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com <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: [EMAIL PROTECTED] (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Experience with Quest Shareplex
Title: RE: Experience with Quest Shareplex Unfortunately this was from vendor's sales rep. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 1:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Experience with Quest Shareplex From indirect experience it is another layer of administration and requires some manually steps depending on the configuration of your database/system. Again, for that reason might want to consider Oracle's similar product that way you won't get stuck in the vendor vs. vendor he-said/she-said thing. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Experience with Quest Shareplex Last I heard about shareplex that it still had some problems with IOTs and user defined types ... they seems to be working on those though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Experience with Quest Shareplex Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Subject: Experience with Quest Shareplex Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Experience with Quest Shareplex
Title: RE: Experience with Quest Shareplex From indirect experience it is another layer of administration and requires some manually steps depending on the configuration of your database/system. Again, for that reason might want to consider Oracle's similar product that way you won't get stuck in the vendor vs. vendor he-said/she-said thing. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Experience with Quest Shareplex Last I heard about shareplex that it still had some problems with IOTs and user defined types ... they seems to be working on those though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Experience with Quest Shareplex Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Subject: Experience with Quest Shareplex Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Experience with Quest Shareplex
I did some investigation into SharePlex a few years ago. I tried for months to get someone to respond to email and voicemail messages to the vendor that "I want to buy SharePlex and I have the money". Eventually I got the software for evaluation. I found once again that replication isn't easy, no matter which approach or vendor you use. My own playing around with SharePlex, talks with noted Oracle book authors and email exchanges with SharePlex users who responded to my query on this listserver privately honed in on one problem: getting synchronized and ready to start replicating. SharePlex would synch up table after table, find one it couldn't synch up and fail. Like anything with Oracle, see if Oracle's solution fits your needs first. It's nice only having to go to one vendor for support. SharePlex costs a lot of money. Make sure you've got your requirements firm. After all of my investigating, the company I did the work for decided they could live with reporting databases created by breaking a third mirror, exporting the filesystems from the production box, importing them into the reporting box. If you really need the capability of SharePlex, well, it does have a lot of happy customers. Be prepared, as they were, to spend lots of time getting it right. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 10:13 AM > Does anyone have experience with a product called Shareplex > by Quest Software. We have some remote access performance > issues and my management is looking at this product > as a possible solution for a distributed database. > > thanks, > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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.com -- Author: Tom Pall INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Experience with Quest Shareplex
Title: RE: Experience with Quest Shareplex Last I heard about shareplex that it still had some problems with IOTs and user defined types ... they seems to be working on those though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Experience with Quest Shareplex Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Subject: Experience with Quest Shareplex Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Experience with Quest Shareplex
Title: RE: Experience with Quest Shareplex Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Subject: Experience with Quest Shareplex Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Experience with Quest Shareplex
Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a distributed database. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Unix Script Quest : Urgent
Don't forget the "lsof" command (list open files). Just as invaluable as "truss". Get it at http://www.sunfreeware.com/ chris.w.johnson@b t.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: RE: Unix Script Quest : Urgent 08/09/02 09:08 AM Please respond to ORACLE-L Hannah, I'm no Unix guru either but in this situation I use 'truss', e.g. truss procname HTH Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 August 2002 16:08 To: Multiple recipients of list ORACLE-L Subject: Unix Script Quest : Urgent Is there a way to capture all files hit by a process/user in unix (Sun Solaris 9, ksh)? I am seeing an OCI file not found on my production box. I can't resovle it. So, I want to run the same process on my development box (where it works) and get a list of files that it is hitting (I can grep by username) for comparison in production. Only I am definitely NOT the Unix guru and as this is for a prod issue, so my time is very limited. Thanks in advance, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Unix Script Quest : Urgent
Never say "never". The output from "truss" shows all "system calls"; which includes file opens. Here is an interesting exercise for those on *nix boxes. >From one window/session do the following ... $ sqlplus >From a different window where you are logged onto the system as root find the pid (process ID) of the SQLPLUS process from 1st window. $ truss -p pid | tee /tmp/capture After the truss command has been initiated go back to the 1st window and enter a valid Oracle username/password to connect to the DB. In the window running the truss you'll see all the various "login" files which SQL*Plus attempts to open before returning control to the user & presenting the SQL> prompt. HTH & YMMV HAND! "Seefelt, Beth" wrote: > > I think that will give you files that it successfully accessed, but not > the ones that were referenced but not found. > > You can do what you're asking on VMS and NT, so it seems like there > should be a way in Unix, although I asked my Unix SA's that same > question a few years back and they said that there isn't. They were > pretty sharp guys so I tend to believe them. > > -Original Message- > Sent: Friday, August 09, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Is there a way to capture all files hit by a process/user in unix (Sun > > Solaris 9, ksh)? I am seeing an OCI file not found on my production > box. > > I can't resovle it. > > So, I want to run the same process on my development box (where it > works) > > and get a list of files that it is hitting (I can grep by username) > for > > comparison in production. Only I am definitely NOT the Unix guru and > as > > this is for a prod issue, so my time is very limited. > > Thanks in advance, > > touch BEFORE; > ... > find $wherever -newer ./BEFORE; > > will give you a list of files that have changed since the > BEFORE file. If you are sure that the files are being > created (vs. modified or accessed) by one specific userid > then: > > find / -newer BEFORE -user > > will work also. > > If you are going to run the thing regularly then take a > look at "find2p", which will spit out a perl script to > match your find command. The perly code will give you > finer control and better sanity checks (e.g., comparing > to a list in memory of what has already been found to > avoid dup's) than find can. > > enjoi. > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Lembark > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Seefelt, Beth > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lack of planning on your part doesn't constitute an emergency on my part! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Unix Script Quest : Urgent
Hannah, I'm no Unix guru either but in this situation I use 'truss', e.g. truss procname HTH Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 09 August 2002 16:08To: Multiple recipients of list ORACLE-LSubject: Unix Script Quest : Urgent Is there a way to capture all files hit by a process/user in unix (Sun Solaris 9, ksh)? I am seeing an OCI file not found on my production box. I can't resovle it. So, I want to run the same process on my development box (where it works) and get a list of files that it is hitting (I can grep by username) for comparison in production. Only I am definitely NOT the Unix guru and as this is for a prod issue, so my time is very limited. Thanks in advance, Hannah
RE: Unix Script Quest : Urgent
Thanks, But I don't know the file or pid. Here's what we are doing: From an NT box, we are trying to run Sagent software to an Oracle db on unix sun solaris (both 64bit). When we try to refresh, we get a sagent error - OCI file not found. Of course it does not specifiy the file name. Using the same client, I can connect and run on my development box. Now, I know the username that Sagent connect to unix as, so I was hoping that I could run a trace on the Unix box based on the user name. But I am not finding a clear way to do this. I want to run the trace on the develpment box (the one that works), so that I can retrieve a list of filenames that the sagent process is hitting. Then I would want to compare the filenames to the directories on the prod bix to see what file is missing. Anyway, I am not seeing a clear way of doing this. I thinkg I'm going to wind up dumping the directories to file and doing a manual compare (ugh!) . Thanks, Hannah > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Peter Barnett ><[EMAIL PROTECTED]> > Sent: Friday, August 09, 2002 11:48 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Unix Script Quest : Urgent > > ldd should give you the dependencies. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Unix Script Quest : Urgent
I think that will give you files that it successfully accessed, but not the ones that were referenced but not found. You can do what you're asking on VMS and NT, so it seems like there should be a way in Unix, although I asked my Unix SA's that same question a few years back and they said that there isn't. They were pretty sharp guys so I tend to believe them. -Original Message- Sent: Friday, August 09, 2002 11:33 AM To: Multiple recipients of list ORACLE-L > Is there a way to capture all files hit by a process/user in unix (Sun > Solaris 9, ksh)? I am seeing an OCI file not found on my production box. > I can't resovle it. > So, I want to run the same process on my development box (where it works) > and get a list of files that it is hitting (I can grep by username) for > comparison in production. Only I am definitely NOT the Unix guru and as > this is for a prod issue, so my time is very limited. > Thanks in advance, touch BEFORE; ... find $wherever -newer ./BEFORE; will give you a list of files that have changed since the BEFORE file. If you are sure that the files are being created (vs. modified or accessed) by one specific userid then: find / -newer BEFORE -user will work also. If you are going to run the thing regularly then take a look at "find2p", which will spit out a perl script to match your find command. The perly code will give you finer control and better sanity checks (e.g., comparing to a list in memory of what has already been found to avoid dup's) than find can. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Unix Script Quest : Urgent
ldd should give you the dependencies. --- [EMAIL PROTECTED] wrote: > Is there a way to capture all files hit by a > process/user in unix (Sun Solaris 9, ksh)? I am > seeing an OCI file not found on my production box. > I can't resovle it. > > So, I want to run the same process on my development > box (where it works) and get a list of files that it > is hitting (I can grep by username) for comparison > in production. Only I am definitely NOT the Unix > guru and as this is for a prod issue, so my time is > very limited. > > Thanks in advance, > > Hannah > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Unix Script Quest : Urgent
> Is there a way to capture all files hit by a process/user in unix (Sun > Solaris 9, ksh)? I am seeing an OCI file not found on my production box. > I can't resovle it. > So, I want to run the same process on my development box (where it works) > and get a list of files that it is hitting (I can grep by username) for > comparison in production. Only I am definitely NOT the Unix guru and as > this is for a prod issue, so my time is very limited. > Thanks in advance, touch BEFORE; ... find $wherever -newer ./BEFORE; will give you a list of files that have changed since the BEFORE file. If you are sure that the files are being created (vs. modified or accessed) by one specific userid then: find / -newer BEFORE -user will work also. If you are going to run the thing regularly then take a look at "find2p", which will spit out a perl script to match your find command. The perly code will give you finer control and better sanity checks (e.g., comparing to a list in memory of what has already been found to avoid dup's) than find can. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Unix Script Quest : Urgent
Is there a way to capture all files hit by a process/user in unix (Sun Solaris 9, ksh)? I am seeing an OCI file not found on my production box. I can't resovle it. So, I want to run the same process on my development box (where it works) and get a list of files that it is hitting (I can grep by username) for comparison in production. Only I am definitely NOT the Unix guru and as this is for a prod issue, so my time is very limited. Thanks in advance, Hannah
RE: CA sues Quest Software for code theft
Well they're doing at least one thing right. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, July 11, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:RE: CA sues Quest Software for code theft Ahhh...yeah...that's a reason to keep CA around...the free posters. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
Great minds think alike... -Original Message- Sent: Thursday, July 11, 2002 12:29 PM To: Multiple recipients of list ORACLE-L http://www.tusc.com :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 10:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: CA sues Quest Software for code theft > > > Hey! Where are we going to get free data dictionary posters > if CA dies? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
Ahhh...yeah...that's a reason to keep CA around...the free posters. -Original Message- Sent: Thursday, July 11, 2002 12:34 PM To: Multiple recipients of list ORACLE-L but it's not "free" from TUSC. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 12:09 PM > TUSC. > > So it would not be a tragedy. :P > > Chris > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > > > Hey! Where are we going to get free data dictionary posters if CA dies? > > That would be a tragedy. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: CA sues Quest Software for code theft > > True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very > disappointed in what Quest did with their perf tuning tools. > > At least TOAD is still standalone. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 10, 2002 3:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:CA sues Quest Software for code theft > > > > > > Busted or being hogged on? Probably something old Platinum > > had cooking on the > > back burner & that CA was going to trash. Of course they > > can't have anyone make > > money on their trash now can they? Send CA to chapter 13 as > > fast as one can. > > We'll all be better off. > > > > Dick Goulet > > > > ____Reply Separator > > Author: "James Howerton" <[EMAIL PROTECTED]> > > Date: 7/10/2002 12:10 PM > > > > Busted... > > > > Software vendor Computer Associates International is suing competitor > > Quest > > Software, alleging that Quest stole code and trade secrets from a CA > > product. > > > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Re: CA sues Quest Software for code theft
TUSC doesn't advertise a Data Dictionary poster on it's web site, only V$ Views for Oracle9i. And, they are not free. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 11:28 AM > http://www.tusc.com :) > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, July 11, 2002 10:54 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: CA sues Quest Software for code theft > > > > > > Hey! Where are we going to get free data dictionary posters > > if CA dies? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re:RE: CA sues Quest Software for code theft
Only for those sad few who have become CA zombies. Dick Goulet Reply Separator Author: "Boivin; Patrice J" <[EMAIL PROTECTED]> Date: 7/11/2002 7:53 AM Hey! Where are we going to get free data dictionary posters if CA dies? That would be a tragedy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, July 11, 2002 11:54 AM To: Multiple recipients of list ORACLE-L True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very disappointed in what Quest did with their perf tuning tools. At least TOAD is still standalone. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:CA sues Quest Software for code theft > > > Busted or being hogged on? Probably something old Platinum > had cooking on the > back burner & that CA was going to trash. Of course they > can't have anyone make > money on their trash now can they? Send CA to chapter 13 as > fast as one can. > We'll all be better off. > > Dick Goulet > > Reply Separator > Author: "James Howerton" <[EMAIL PROTECTED]> > Date: 7/10/2002 12:10 PM > > Busted... > > Software vendor Computer Associates International is suing competitor > Quest > Software, alleging that Quest stole code and trade secrets from a CA > product. > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
So I guess Ken is voting to keep CA around...:) -Original Message- Sent: Thursday, July 11, 2002 12:34 PM To: Multiple recipients of list ORACLE-L I just checked their web site and the only poster they have is - V$ Views for Oracle9i. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 11:09 AM > TUSC. > > So it would not be a tragedy. :P > > Chris > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > > > Hey! Where are we going to get free data dictionary posters if CA dies? > > That would be a tragedy. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: CA sues Quest Software for code theft > > True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very > disappointed in what Quest did with their perf tuning tools. > > At least TOAD is still standalone. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 10, 2002 3:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:CA sues Quest Software for code theft > > > > > > Busted or being hogged on? Probably something old Platinum > > had cooking on the > > back burner & that CA was going to trash. Of course they > > can't have anyone make > > money on their trash now can they? Send CA to chapter 13 as > > fast as one can. > > We'll all be better off. > > > > Dick Goulet > > > > ____Reply Separator____ > > Author: "James Howerton" <[EMAIL PROTECTED]> > > Date: 7/10/2002 12:10 PM > > > > Busted... > > > > Software vendor Computer Associates International is suing competitor > > Quest > > Software, alleging that Quest stole code and trade secrets from a CA > > product. > > > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
Re: CA sues Quest Software for code theft
but it's not "free" from TUSC. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 12:09 PM > TUSC. > > So it would not be a tragedy. :P > > Chris > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > > > Hey! Where are we going to get free data dictionary posters if CA dies? > > That would be a tragedy. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: CA sues Quest Software for code theft > > True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very > disappointed in what Quest did with their perf tuning tools. > > At least TOAD is still standalone. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 10, 2002 3:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:CA sues Quest Software for code theft > > > > > > Busted or being hogged on? Probably something old Platinum > > had cooking on the > > back burner & that CA was going to trash. Of course they > > can't have anyone make > > money on their trash now can they? Send CA to chapter 13 as > > fast as one can. > > We'll all be better off. > > > > Dick Goulet > > > > ____Reply Separator > > Author: "James Howerton" <[EMAIL PROTECTED]> > > Date: 7/10/2002 12:10 PM > > > > Busted... > > > > Software vendor Computer Associates International is suing competitor > > Quest > > Software, alleging that Quest stole code and trade secrets from a CA > > product. > > > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: CA sues Quest Software for code theft
I just checked their web site and the only poster they have is - V$ Views for Oracle9i. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 11:09 AM > TUSC. > > So it would not be a tragedy. :P > > Chris > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > > > Hey! Where are we going to get free data dictionary posters if CA dies? > > That would be a tragedy. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Thursday, July 11, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: CA sues Quest Software for code theft > > True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very > disappointed in what Quest did with their perf tuning tools. > > At least TOAD is still standalone. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 10, 2002 3:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:CA sues Quest Software for code theft > > > > > > Busted or being hogged on? Probably something old Platinum > > had cooking on the > > back burner & that CA was going to trash. Of course they > > can't have anyone make > > money on their trash now can they? Send CA to chapter 13 as > > fast as one can. > > We'll all be better off. > > > > Dick Goulet > > > > ____Reply Separator____ > > Author: "James Howerton" <[EMAIL PROTECTED]> > > Date: 7/10/2002 12:10 PM > > > > Busted... > > > > Software vendor Computer Associates International is suing competitor > > Quest > > Software, alleging that Quest stole code and trade secrets from a CA > > product. > > > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
http://www.tusc.com :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 10:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: CA sues Quest Software for code theft > > > Hey! Where are we going to get free data dictionary posters > if CA dies? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
TUSC. So it would not be a tragedy. :P Chris -Original Message- Sent: Thursday, July 11, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Hey! Where are we going to get free data dictionary posters if CA dies? That would be a tragedy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, July 11, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Subject:RE: CA sues Quest Software for code theft True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very disappointed in what Quest did with their perf tuning tools. At least TOAD is still standalone. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:CA sues Quest Software for code theft > > > Busted or being hogged on? Probably something old Platinum > had cooking on the > back burner & that CA was going to trash. Of course they > can't have anyone make > money on their trash now can they? Send CA to chapter 13 as > fast as one can. > We'll all be better off. > > Dick Goulet > > Reply Separator > Author: "James Howerton" <[EMAIL PROTECTED]> > Date: 7/10/2002 12:10 PM > > Busted... > > Software vendor Computer Associates International is suing competitor > Quest > Software, alleging that Quest stole code and trade secrets from a CA > product. > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
Hey! Where are we going to get free data dictionary posters if CA dies? That would be a tragedy. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, July 11, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Subject:RE: CA sues Quest Software for code theft True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very disappointed in what Quest did with their perf tuning tools. At least TOAD is still standalone. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:CA sues Quest Software for code theft > > > Busted or being hogged on? Probably something old Platinum > had cooking on the > back burner & that CA was going to trash. Of course they > can't have anyone make > money on their trash now can they? Send CA to chapter 13 as > fast as one can. > We'll all be better off. > > Dick Goulet > > Reply Separator > Author: "James Howerton" <[EMAIL PROTECTED]> > Date: 7/10/2002 12:10 PM > > Busted... > > Software vendor Computer Associates International is suing competitor > Quest > Software, alleging that Quest stole code and trade secrets from a CA > product. > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: CA sues Quest Software for code theft
True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very disappointed in what Quest did with their perf tuning tools. At least TOAD is still standalone. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:CA sues Quest Software for code theft > > > Busted or being hogged on? Probably something old Platinum > had cooking on the > back burner & that CA was going to trash. Of course they > can't have anyone make > money on their trash now can they? Send CA to chapter 13 as > fast as one can. > We'll all be better off. > > Dick Goulet > > Reply Separator > Author: "James Howerton" <[EMAIL PROTECTED]> > Date: 7/10/2002 12:10 PM > > Busted... > > Software vendor Computer Associates International is suing competitor > Quest > Software, alleging that Quest stole code and trade secrets from a CA > product. > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Re:CA sues Quest Software for code theft
Chapter 7 would be better - bye bye. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 3:33 PM > Busted or being hogged on? Probably something old Platinum had cooking on the > back burner & that CA was going to trash. Of course they can't have anyone make > money on their trash now can they? Send CA to chapter 13 as fast as one can. > We'll all be better off. > > Dick Goulet > > Reply Separator > Author: "James Howerton" <[EMAIL PROTECTED]> > Date: 7/10/2002 12:10 PM > > Busted... > > Software vendor Computer Associates International is suing competitor > Quest > Software, alleging that Quest stole code and trade secrets from a CA > product. > > http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James Howerton > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re[2]:CA sues Quest Software for code theft
Not here, their name is considered obscene terminology. Actually I kind of like it. One can swear without offending the opposite sex. Dick Goulet Reply Separator Author: "James Howerton" <[EMAIL PROTECTED]> Date: 7/10/2002 2:34 PM Does anybody really buy CA's invasive junk? ...JIM... >>> <[EMAIL PROTECTED]> 7/10/02 2:28:52 PM >>> Busted or being hogged on? Probably something old Platinum had cooking on the back burner & that CA was going to trash. Of course they can't have anyone make money on their trash now can they? Send CA to chapter 13 as fast as one can. We'll all be better off. Dick Goulet Reply Separator Author: "James Howerton" <[EMAIL PROTECTED]> Date: 7/10/2002 12:10 PM Busted... Software vendor Computer Associates International is suing competitor Quest Software, alleging that Quest stole code and trade secrets from a CA product. http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re:CA sues Quest Software for code theft
Busted or being hogged on? Probably something old Platinum had cooking on the back burner & that CA was going to trash. Of course they can't have anyone make money on their trash now can they? Send CA to chapter 13 as fast as one can. We'll all be better off. Dick Goulet Reply Separator Author: "James Howerton" <[EMAIL PROTECTED]> Date: 7/10/2002 12:10 PM Busted... Software vendor Computer Associates International is suing competitor Quest Software, alleging that Quest stole code and trade secrets from a CA product. http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
CA sues Quest Software for code theft
Busted... Software vendor Computer Associates International is suing competitor Quest Software, alleging that Quest stole code and trade secrets from a CA product. http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: REPLICATION: Quest Shareplex
Hi, I changed the Subject to SHAREPLEX, lets close out the contention thread. Could be why there are no responses. A couple people on the list definitely use it and I know I certaintly will have a lot to say about it but have to do it later as I am working on Prod issues right now. Thanks, Hannah > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Rachel Carmichael ><[EMAIL PROTECTED]> > Sent: Wednesday, June 12, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: I/O contention with external process reading the oracle logs >(online redo logs) > > Shareplex reads the log files so if you can't get the log files > over the existing line, Shareplex can't read them. > > have you considered using an NFS mounted disk for your archive log > directory? > > or a process that copies the archived logs to the nfs mounted disk on > the primary and a another process that copies them off the nfs mounted > disk on the secondary? > > I had to do something like that when I worked with Sybase, back in the > 4.7 days, so that I could "backup" the log files realtime. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
REPLICATION: Quest Shareplex
Title: REPLICATION: Quest Shareplex Hi, I changed the Subject to SHAREPLEX, lets close out the contention thread. Could be why there are no responses. A couple people on the list definitely use it and I know I certaintly will have a lot to say about it but have to do it later as I am working on Prod issues right now. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Rachel Carmichael <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: Re: I/O contention with external process reading the oracle logs (online redo logs) Shareplex reads the log files so if you can't get the log files over the existing line, Shareplex can't read them. have you considered using an NFS mounted disk for your archive log directory? or a process that copies the archived logs to the nfs mounted disk on the primary and a another process that copies them off the nfs mounted disk on the secondary? I had to do something like that when I worked with Sybase, back in the 4.7 days, so that I could "backup" the log files realtime. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Meghraj Thakkar - Quest - Oracle 9i on Windows NT/2000 / Re:
Don't forget to turn #%^%#@#$% cookies on in your browser. The site won't work without them and is too stupid to tell when they're off. Where's the Cookie Monster when you need him? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- > From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 3:04 PM > To: Multiple recipients of list ORACLE-L > Subject: Meghraj Thakkar - Quest - Oracle 9i on Windows NT/2000 / Re: > ORACLE-L Digest -- Volume 2002, Number 120 > > > Meghraj Thakkar - Quest Oracle 9i on Windows NT/2000 > > > http://www.oracle.com/pls/oow/oow_user.show_public?p_event=6&p > _type=session&p_id=11958 ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Meghraj Thakkar - Quest - Oracle 9i on Windows NT/2000 / Re: ORACLE-L Digest -- Volume 2002, Number 120
Meghraj Thakkar - Quest Oracle 9i on Windows NT/2000 http://www.oracle.com/pls/oow/oow_user.show_public?p_event=6&p_type=session&p_id=11958 - Whitepaper: http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6&p_file=W11958.zip (expands to "105.doc") | Some parts of this paper have been extracted from the books | "Teach Yourself Oracle8i on Windows NT in 24 Hours" by Megh Thakkar | (ISBN: 0672315785) and | "e-Business for the Oracle DBA" by Megh Thakkar (ISBN: 0672321475) - Presentation; http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6&p_file=P11958.zip (expands to "105.pps") ORACLE-L Digest -- Volume 2002, Number 120 > -- > > From: [EMAIL PROTECTED] > Date: Mon, 29 Apr 2002 11:29:55 -0700 > Subject: RE: CPU Pegged at 100% > > Thomas, > > If you could locate that paper, we would all be grateful. > > I have been unable to find it. > > Thanks, > > Jared > > > > > > Thomas Day <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/29/2002 06:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> cc: Subject:RE: CPU Pegged at 100% > > > > I don't think that increasing the db_writer_processes will help. NT is, > as noted elsewhere, multi-threaded. Increasing the db_writer_processes > will not start a new process. > > My experience with Oracle on NT is that when the CPU is pegged at 100% it > is because the OS is constantly writing and fetching the contents of RAM > to the swapfile. > > Meghraj Thakkar from Quest has a good paper on running Oracle 9i on > Windows > NT/2000. A search on Yahoo will probably find it for you. I don't have > the URL. > > The following points are taken from that paper. > > Decrease the size of SGA so that all of the SGA and the OS will fit in > physical RAM. This will decrease the use of the swapfile. > > Choose "Maximum throughput for network applications" in the control panel. > Oracle does it's own memory management. Trying to let Windows memory > manage on top of that adds to swapfile use. > > > -- > > From the Services panel, disable all unneeded services. This includes > > You should not touch alerter, browser, eventlog, messenger, Oracle > Service, Oracle TNSListener, Server, spooler and workstation. > > If you have 9i, set PRE_PAGE_SGA = TRUE. This tells Windows to keep the > SGA in physical memory (RAM) as much as possible. It will get paged out > --- that's the nature of Windows --- but not as often. > > Windows does IO buffering. However, Oracle does its own IO buffering > apart from the OS. Performance can be increased and more of the RAM made > available to the SGA by using REGEDIT and editing the registry. Go to > \HKEY_LOCAL_MACHINE\Control\SessionManager\MemoryManagement and setting > LargeSystemCache to 0. Be sure to back up the Registry before editing. > > HTH > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thomas Day > INET: [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Quest bought EZSQL
!! Please do not post Off Topic to this List !!
Don't laugh, that is what a lot of Windows programming firms aimed for:
Start a small software firm.
Give your employees stock options.
Make a very useful utility.
Become popular.
Your stock value climbs.
Microsoft buys out your company at your stock value's peak.
Retire.
Then the .com frenzy started, but that wasn't as successful.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Acting Head
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
From: Greg Moore [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:15 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Quest bought EZSQL
!! Please do not post Off Topic to this List !!
> apparently EZSQL was bought to suppress
> competition for TOAD and SQL Navigator.
There may be a cottage industry here. Code up a front end, enhance
it in
your spare time over a year or two so it has most of the useful
features.
Then start giving it away. Pretty soon Quest will buy you out.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
Re: Quest bought EZSQL
!! Please do not post Off Topic to this List !! > apparently EZSQL was bought to suppress > competition for TOAD and SQL Navigator. There may be a cottage industry here. Code up a front end, enhance it in your spare time over a year or two so it has most of the useful features. Then start giving it away. Pretty soon Quest will buy you out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Quest bought EZSQL
!! Please do not post Off Topic to this List !! Quest also recently became associated with RevealNet. Looked to me like they bought RevealNet, but could possibly be just a close partership. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Quest bought EZSQL
!! Please do not post Off Topic to this List !! I had an email discussion with John Dorn (sp.?), the author, about this. I'll send you the text if you wish? I was really upset about it -Original Message- Sent: Thursday, September 13, 2001 5:05 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Guys, go to www.ezsql.net and read about it. Quest will not sell new licences - apparently EZSQL was bought to suppress competition for TOAD and SQL Navigator. It reminds me Marks explanation about capitalizm - that capitalizm suppress innovations when they are thretening profits. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Quest bought EZSQL
!! Please do not post Off Topic to this List !! Guys, go to www.ezsql.net and read about it. Quest will not sell new licences - apparently EZSQL was bought to suppress competition for TOAD and SQL Navigator. It reminds me Marks explanation about capitalizm - that capitalizm suppress innovations when they are thretening profits. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Quest s/w
I am not a big fan of Toad, it is expensive and has a bunch of pretty things, but not much pratical. PL/SQL Developer is a great product, much more pratical and a lot cheaper. As low as $50/user compared to $750. The company is great, I have dealt with their support very closely over the last 3 years and they have proved to be one of the best I have seen. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Well, we use Toad - great - and SQLab Vision - not so great - the version we got on CD didn't cover 8.1.7 so we had to download the latest version; it still doesn't really understand 'new' features like function-based indexes; it has a tendency to fall over on really serious SQL; and the 'advice' is often irrelevant (and its GUI, but thats probably my unix/dba predudices coming out). Regards David Lord -Original Message- Sent: 19 July 2001 23:53 To: Multiple recipients of list ORACLE-L Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard from anyone except folks asking me to share what I hear. If nobody uses this software, that sounds like a ringing anti-endorsement! Comments? And no I'm not flame-baiting. I wanna hear what people have to say about this product. Thanx, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Lord, David - C&S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Quest s/w
and I've worked with StorageXpert and it's great... easy to use, understand and install. And damagement really likes the "equalizers" -- immediately visual image of what is happening >From: "Lord, David - C&S" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Quest s/w >Date: Fri, 20 Jul 2001 04:15:45 -0800 > >Well, we use Toad - great - and SQLab Vision - not so great - the version >we >got on CD didn't cover 8.1.7 so we had to download the latest version; it >still doesn't really understand 'new' features like function-based indexes; >it has a tendency to fall over on really serious SQL; and the 'advice' is >often irrelevant (and its GUI, but thats probably my unix/dba predudices >coming out). > >Regards >David Lord > >-Original Message- >Sent: 19 July 2001 23:53 >To: Multiple recipients of list ORACLE-L > > >Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard >from anyone except folks asking me to share what I hear. If nobody uses >this software, that sounds like a ringing anti-endorsement! > >Comments? And no I'm not flame-baiting. I wanna hear what people have to >say about this product. > >Thanx, >Mike > >--- >=== >Michael P. Vergara | I've got a PBS mind in an MTV world >Oracle DBA | >Guidant Corporation | > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Vergara, Michael (TEM) > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (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.com >-- >Author: Lord, David - C&S > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Quest s/w
Well, we use Toad - great - and SQLab Vision - not so great - the version we got on CD didn't cover 8.1.7 so we had to download the latest version; it still doesn't really understand 'new' features like function-based indexes; it has a tendency to fall over on really serious SQL; and the 'advice' is often irrelevant (and its GUI, but thats probably my unix/dba predudices coming out). Regards David Lord -Original Message- Sent: 19 July 2001 23:53 To: Multiple recipients of list ORACLE-L Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard from anyone except folks asking me to share what I hear. If nobody uses this software, that sounds like a ringing anti-endorsement! Comments? And no I'm not flame-baiting. I wanna hear what people have to say about this product. Thanx, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Lord, David - C&S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Quest s/w
"Vergara, Michael (TEM)" wrote: > > Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard > from anyone except folks asking me to share what I hear. If nobody uses > this software, that sounds like a ringing anti-endorsement! > > Comments? And no I'm not flame-baiting. I wanna hear what people have to > say about this product. > > Thanx, > Mike well, i use other Quest software and i'm very happy with it and with the support. but i don't use live reorg. damagement doesn't want to pay for it. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Quest s/w
Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard from anyone except folks asking me to share what I hear. If nobody uses this software, that sounds like a ringing anti-endorsement! Comments? And no I'm not flame-baiting. I wanna hear what people have to say about this product. Thanx, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Quest Software Product Query
This traffic is perfectly on topic of the list and I am sure a lot of us would love to hear other people's stories. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, July 18, 2001 5:10 PM To: Multiple recipients of list ORACLE-L Hi All. We just had some folks here from Quest software showing us their 'Live Reorg' product. Does anybody out there use...or not...this product? If you have experience or recommendations or horror stories I'd like to hear them. Please e-mail me privately ; this traffic doesn't need to clog up the list. My address is [EMAIL PROTECTED] Thanks, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
OT: Quest Software Product Query
Hi All. We just had some folks here from Quest software showing us their 'Live Reorg' product. Does anybody out there use...or not...this product? If you have experience or recommendations or horror stories I'd like to hear them. Please e-mail me privately ; this traffic doesn't need to clog up the list. My address is [EMAIL PROTECTED] Thanks, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re[2]:Your views on Quest - Shareplex
Bear in mind, Oralce is not always 100% accurate, specially when something competes with their product. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, May 29, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Jim, Thanks, just assures me that it is NOT a product that I want around. Dick Goulet Reply Separator Author: "Jim Hawkins" <[EMAIL PROTECTED]> Date: 5/29/2001 11:01 AM All, We are currently as customer of Quest Software using LiveReorg and Spotlight. For those who don't know, LiveReorg is a combination of two existing Quest products, Space Manager and SharePlex. I asked the exact same question regarding the mining of redo logs of our Quest sales rep. I thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Doc ID: Note:97080.1 Subject: Extracting Data from Redo Logs Is Not A Supported Interface Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-JAN-2000 Last Revision Date: 17-FEB-2000 Language: USAENG PURPOSE --- To explain why any extraction of data from redo logs is not supported. SCOPE & APPLICATION --- Customers who are considering using Quest SharePlex for disaster recovery. Extracting Data from Redo Logs Is Not A Supported Interface -- Quest SharePlex for Oracle replicates data to one or more other Oracle instances. It attempts to use the information in the redo log to replicate transactions remotely. 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. Eyal: That is correct. A part of the SharePlex product goes back to the source database and completes the missing information. This is done only for certain types of Update statements but is not nessasery for Inserts and Deletes. 2) Reading the redo log is not a supported interface. From the very beginning, Oracle has changed redo log formats to support functional enhancements. We must therefore reserve the right to continue to make needed log format changes. For this reason, certification of any third party product using this interface is not possible. Since this is an unsupported interface, the accuracy or completeness of the data in the destination database can not be assured. Eyal: The power of the product is the direct result from reading the raw log data. It is our core competency in Quest to understand and support the changing nature of the Oracle log. The reality is that between version 7.0 until 8.1.6 there where only minor changes to the log. Since we are a close partner with Oracle we get early releases of the software and we have the chance to update the product as needed. So far this has never been an issue since most large production sites are running Oracle versions that are atleast 6 months to a year old. Regarding assurance to the completeness of the data, we do not expect Oracle to provide any assurance. Quest is the one that assures the content of the destination. Quest support has some of the best support experts in the business. Any problem with the database content should be directed to our support organization and not Oracle World Wide Support. Likelihood of Occurrence ~ Unknown. However, even a low likelihood is a concern for disaster recovery (DR). In disaster failovers, the remote server's database may be the only viable copy. Eyal: Since Oracle uses the data in the log to perform database recovery, all the information necessary to create a point in time image of the database exists in the log. However, we believe that SharePlex has a better chance to survive a disaster than even a database recovery. This is because SharePlex only needs the data to recover a transaction while Oracle needs all changes present in the log, including index and rollback changes, to successfully recover a database. An index block corruption may render the recovered database useless. History indicates that SharePlex can withstand most log corruptions and data block corruptions, while maintaining a viable live standby site. If the client is not a 100% sure, SharePlex provides a variety of mechanisms to periodically resync the standby database, including the ability to use a
Re: Your views on Quest - Shareplex
Marc, You didn't mention the Oracle version, but I wouldn't be surprised if it was O7 as the serial push using the two-phase commit process doesn't scale well at all. The completely new architecture (AQ, parallel propagation, min communication, etc...) in O8 makes replication quite scalable even at very high transaction rates. -- Anita --- Marc Perkowitz <[EMAIL PROTECTED]> wrote: > Rao, > I worked at MCI Teleconferencing for a few years and > they were using > SharePlex for a reporting database. Oracle > replication was not fast enough > to support their transaction rate and they also > could not afford the > overhead on the source database that occurs with > Oracle replication. After > a few startup issues, it worked well for them, and > AFAIK, they are still > using it. > > During their research, they also found that > Amazon.com was using it for, I > think, data warehousing -- not their transactional > system. > > Interesting enough, I understand that Oracle has > built an equivalent feature > that was planned to be part of 9i. I haven't read > enough on 9i to see if it > made it in there or not. Perhaps someone else knows > about this. > > Marc Perkowitz > Senior Consultant > TWJ Consulting, LLP > > 847-256-8866 x15 > www.twjconsulting.com > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Tuesday, May 29, 2001 12:16 PM > > > > List, > > > > My company is considering Quest - Shareplex. > > > > We are considering to use this in our dataware > house. Basically, this > will > > pull all the transactions from OLTP database and > populate staging area in > > the dataware house. > > > > Could you please give your experiences and the > pros and cons of this > > Shareplex product. > > > > Thanks, > > > > Rao > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Rao, Maheswara > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (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.com > -- > Author: Marc Perkowitz > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex >-Original Message- >From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > >The person giving the presentation on Shareplex >stated that there could be no chained rows when the sharepex file, > apparently analogous to the log miner dictionary file is created. Someone has already addressed this issue but I'll throw in my two cents again. There was a misunderstanding somewhere. When you "activate" shareplex (set up the software for replication, specifying objects to replicate, initial sync point, etc...) it's perfectly OK for tables to have chained rows, but the "activation" may take longer in that case. >Truncate is not DML it is DDL. I didn't say there was a problem extracting >DML statements. Oracle's log miner utility will do that. >I said that Shareplex, as per the person who gave the presentation, >will replicate truncates and marvelled at this capability. I regret that the developer did not fully comprehend what you meant. I'm sure she would appreciate your compliment. She did want to make sure that it was understood that it would be possible to "replicate" DDL, but that feature isn't in high enough demand (yet) apparently. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re:RE: Your views on Quest - Shareplex - Thank you all
Well, that might be interesting, except I'm going to be way out of touch on June 6th. At any rate, I down loaded your ppt file. I may be very opinionated, but I try to keep up. Never know when one will have to defend or change one's opinions. Dick Goulet Reply Separator Author: Nick Wagner <[EMAIL PROTECTED]> Date: 5/30/2001 2:29 PM If anyone wants to learn more about SharePlex for Oracle by Quest Software, I will be hosting an interactive conference call next Wednesday. This technical presentation describes SharePlex and how it offers live, up-to-the-minute replicas of production databases. Join us to discover how SharePlex can: Improve performance on your OLTP server up to 80% Minimize planned and unplanned downtime Enhance your clustering topology Improve your mirrored environment This technical presentation also includes customer examples from many different industries. No need to pre-register! Just download the presentation and dial in. Please note that you will be anonymous to the other participants to the call, although the operator will initially take your name and phone number for our records. NEXT CONFERENCE CALL: June 6th at 11:00am PST TO PARTICIPATE CALL: 800.967.7150 (Domestic); 719.457.2712 (International) CALL LEADER: Nick Wagner POWERPOINT SLIDES REQUIRED: http://www.quest.com/shareplex/docs/shareplexconfcall.ppt For additional information visit our web page at: www.quest.com/shareplex I look forward to having you on the call! Thanks, Nick Wagner SharePlex Technical Product Manager -Original Message- Sent: Wednesday, May 30, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Thank you all for giving your time to express your opinions. I would be consolidating all the opinions I received in the list and send a mail within the next two days. I hope, this consolidation would help for any future queries on this subject. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). RE: Your views on Quest - Shareplex - Thank you all If anyone wants to learn more about SharePlex for Oracle by Quest Software, I will be hosting an interactive conference call next Wednesday. This technical presentation describes SharePlex and how it offers live, up-to-the-minute replicas of production databases. Join us to discover how SharePlex can: Improve performance on your OLTP server up to 80% Minimize planned and unplanned downtime Enhance your clustering topology Improve your mirrored environment This technical presentation also includes customer examples from many different industries. No need to pre-register! Just download the presentation and dial in. Please note that you will be anonymous to the other participants to the call, although the operator will initially take your name and phone number for our records. NEXT CONFERENCE CALL: June 6th at 11:00am PST TO PARTICIPATE CALL: 800.967.7150 (Domestic); 719.457.2712 (International) CALL LEADER: Nick Wagner POWERPOINT SLIDES REQUIRED: http://www.quest.com/shareplex/docs/shareplexconfcall.ppt"; TARGET="_blank">http://www.quest.com/shareplex/docs/shareplexconfcall.ppt For additional information visit our web page at: www.quest.com/shareplex I look forward to having you on the call! Thanks, Nick Wagner SharePlex Technical Product Manager -Original Message- From: Rao, Maheswara [mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED] ] Sent: Wednesday, May 30, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Your views on Quest - Shareplex - Thank you all Thank you all for giving your time to express your opinions. I would be consolidating all the opinions I received in the list and send a mail within the next two days. I hope, this consolidation would help for any future queries on this subject. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com"; TARGET="_blank">http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from
Re:RE: Your views on Quest - Shareplex
Jacques, Your last statement is one place where I will agree on the "superiority" of SharePlex to Oracle's replication. In my experiences under replication a transaction will take longer than it should since you have to complete that transaction on the remote system as well as the local. SharePlex, since it gets it's queue from the redo logs, would allow the local transaction to complete in a timely manner while batching the transactions to the remote as a separate entity. Dick Goulet Reply Separator Author: Jacques Kilchoer <[EMAIL PROTECTED]> Date: 5/30/2001 10:06 AM > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > > We are looking into the product as well, but have yet to even > toy with the product. There is a "no chained rows" > restriction. I'm not sure what that statement means. Shareplex will replicate a table that has chained rows. > Shareplex does not replicate transactions on > sys objects. A table dropped on one side will not be > dropped on the other. It apparently will replicate truncates > however. It's one thing to read the logs and to find the > time when a truncate caused writes to the data dictionary, > but quite another to reconstruct the statement. Statement from a developer of Shareplex: <> Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses "unsupported" means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles created on the HP-UX server. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com RE: Your views on Quest - Shareplex > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]] > > We are looking into the product as well, but have yet to even > toy with the product. There is a "no chained rows" > restriction. I'm not sure what that statement means. Shareplex will replicate a table that has chained rows. > Shareplex does not replicate transactions on > sys objects. A table dropped on one side will not be > dropped on the other. It apparently will replicate truncates > however. It's one thing to read the logs and to find the > time when a truncate caused writes to the data dictionary, > but quite another to reconstruct the statement. Statement from a developer of Shareplex: <<Interesting statement as this is how we replicate DML. Providing functionality for DDL is not at all impossible for us. It is just one of the things on the list of enhancements that we plan for SharePlex, the priority of which is dependent on the market.>> Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses "unsupported" means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles created on the HP-UX server. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://ww
RE: Your views on Quest - Shareplex - Thank you all
Title: RE: Your views on Quest - Shareplex - Thank you all If anyone wants to learn more about SharePlex for Oracle by Quest Software, I will be hosting an interactive conference call next Wednesday. This technical presentation describes SharePlex and how it offers live, up-to-the-minute replicas of production databases. Join us to discover how SharePlex can: Improve performance on your OLTP server up to 80% Minimize planned and unplanned downtime Enhance your clustering topology Improve your mirrored environment This technical presentation also includes customer examples from many different industries. No need to pre-register! Just download the presentation and dial in. Please note that you will be anonymous to the other participants to the call, although the operator will initially take your name and phone number for our records. NEXT CONFERENCE CALL: June 6th at 11:00am PST TO PARTICIPATE CALL: 800.967.7150 (Domestic); 719.457.2712 (International) CALL LEADER: Nick Wagner POWERPOINT SLIDES REQUIRED: http://www.quest.com/shareplex/docs/shareplexconfcall.ppt For additional information visit our web page at: www.quest.com/shareplex I look forward to having you on the call! Thanks, Nick Wagner SharePlex Technical Product Manager -Original Message- From: Rao, Maheswara [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Your views on Quest - Shareplex - Thank you all Thank you all for giving your time to express your opinions. I would be consolidating all the opinions I received in the list and send a mail within the next two days. I hope, this consolidation would help for any future queries on this subject. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Your views on Quest - Shareplex - Thank you all
Thank you all for giving your time to express your opinions. I would be consolidating all the opinions I received in the list and send a mail within the next two days. I hope, this consolidation would help for any future queries on this subject. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Your views on Quest - Shareplex
I verified this today actually. I had a conference call with Quest regarding SharePlex, and asked specifically about the chained rows. They said there is a "reorganization" step on the target database, so chained rows are not a problem. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) > > -Original Message- > > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > > > > We are looking into the product as well, but have yet to even > > toy with the product. There is a "no chained rows" > > restriction. > > I'm not sure what that statement means. Shareplex will replicate a table > that has chained rows. > > > Shareplex does not replicate transactions on > > sys objects. A table dropped on one side will not be > > dropped on the other. It apparently will replicate truncates > > however. It's one thing to read the logs and to find the > > time when a truncate caused writes to the data dictionary, > > but quite another to reconstruct the statement. > > Statement from a developer of Shareplex: > < functionality for DDL is not at all impossible for us. It is just one of > the things on the list of enhancements that we plan for SharePlex, the > priority of which is dependent on the market.>> > > > Let me relate my personal experience working with Shareplex (BEFORE I was an > employee with Quest Software). At a previous company we were looking for a > replication tool at a company that did payroll taxes. There were large batch > loads (bank records) every night, but especially at the end of each quarter > and at the end of the year. We wanted to ensure that the replication tool we > chose would be fast enough to keep up with the large data loads. When we > tested Oracle Replication and Quest Shareplex, we found that Shareplex was > significantly faster. I personally argued against it initially for some of > the reasons posters here have mentioned (e.g. it uses "unsupported" means to > accomplish its goal) but eventually we implemented Shareplex and were > satisfied with the result. There can be some manual effort involved in > reconciliation of discrepancies but we found that effort to be minor. > Another factor that influenced our decision is that we were intending to use > Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles > created on the HP-UX server. > > -- > Jacques R. Kilchoer > (949) 754-8816 > Quest Software, Inc. > 8001 Irvine Center Drive > Irvine, California 92618 > U.S.A. > http://www.quest.com > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex The person giving the presentation on Shareplex stated that there could be no chained rows when the sharepex file, apparently analogous to the log miner dictionary file is created. -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Your views on Quest - Shareplex > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > > We are looking into the product as well, but have yet to even > toy with the product. There is a "no chained rows" > restriction. I'm not sure what that statement means. Shareplex will replicate a table that has chained rows. > Shareplex does not replicate transactions on > sys objects. A table dropped on one side will not be > dropped on the other. It apparently will replicate truncates > however. It's one thing to read the logs and to find the > time when a truncate caused writes to the data dictionary, > but quite another to reconstruct the statement. Statement from a developer of Shareplex: <> Truncate is not DML it is DDL. I didn't say there was a problem extracting DML statements. Oracle's log miner utility will do that. I said that Shareplex, as per the person who gave the presentation, will replicate truncates and marvelled at this capability. Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses "unsupported" means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in co junction with Shareplex FS to replicate datafiles created on the HP-UX server. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > > We are looking into the product as well, but have yet to even > toy with the product. There is a "no chained rows" > restriction. I'm not sure what that statement means. Shareplex will replicate a table that has chained rows. > Shareplex does not replicate transactions on > sys objects. A table dropped on one side will not be > dropped on the other. It apparently will replicate truncates > however. It's one thing to read the logs and to find the > time when a truncate caused writes to the data dictionary, > but quite another to reconstruct the statement. Statement from a developer of Shareplex: <> Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses "unsupported" means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles created on the HP-UX server. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re:Your views on Quest - Shareplex
Jim, My apologies -- I misunderstood what you wrote. yes, pretty good legwork. Eyal used to be in NY and part of our user group here. I, for one, miss him! Rachel >From: "Jim Hawkins" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re:Your views on Quest - Shareplex >Date: Tue, 29 May 2001 13:06:11 -0800 > >Rachel, > >Sorry for the confusion - I meant that my sales rep got Eyal to reply to >this, and then sent me the informative email. I did not, however, know >that I was getting it from the VP for Technology! I guess I should have >been really impressed with my sales reps leg-work! > >Jim > > > Jim, > > > > Um, if that is the Eyal I know, it's Eyal Aronoff and he's not exactly >a > > "sales rep" for Quest but instead is the Senior VP for Technology and >the > > person who developed Shareplex. > > > > Which means you got the best possible answer from the best possible >source. > > He's brilliant. > > > > Rachel > > > > > > >From: "Jim Hawkins" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Re:Your views on Quest - Shareplex > > >Date: Tue, 29 May 2001 11:01:21 -0800 > > > > > >All, > > > > > >We are currently as customer of Quest Software using LiveReorg and > > >Spotlight. For those who don't know, LiveReorg is a combination of two > > >existing Quest products, Space Manager and SharePlex. I asked the >exact > > >same question regarding the mining of redo logs of our Quest sales rep. >I > > >thought all would be interested in the reply. It is a in-line reply to >an > > >Oracle MetaLink document. > > > > > >Jim Hawkins > > >Lead SAPR/3 Oracle Database Administrator > > >MEMC Electronic Materials, Inc. > > >600 Pearl Drive > > >St. Louis, MO 633376 > > >9636) 474-7832 > > >[EMAIL PROTECTED] (work) > > >[EMAIL PROTECTED] (home) > > > > > > > > > > > > > Doc ID: > > > Note:97080.1 > > > Subject: > > > Extracting Data from Redo Logs Is Not A Supported Interface > > > Type: > > > BULLETIN > > > Status: > > > PUBLISHED > > > > > > Content Type: TEXT/PLAIN > > > Creation Date: 22-JAN-2000 > > > Last Revision Date: 17-FEB-2000 > > > Language: USAENG > > > > > > PURPOSE > > > --- > > > > > > To explain why any extraction of data from redo logs is not >supported. > > > > > > SCOPE & APPLICATION > > > --- > > > > > >Customers who are considering using Quest SharePlex for disaster > > >recovery. > > > > > > > > > Extracting Data from Redo Logs Is Not A Supported Interface > > > >-- > > > > > >Quest SharePlex for Oracle replicates data to one or more other >Oracle > > >instances. It attempts to use the information in the redo log to > > >replicate transactions remotely. > > > > > >1) There is not sufficient information in the logs to logically > > >replicate transactions, so the data applied to the destination >system > > >may be different from the primary, and therefore inaccurate. > > > > > >Eyal: That is correct. A part of the SharePlex product goes back to the > > >source database and completes the missing information. This is done >only > > >for certain types of Update statements but is not nessasery for Inserts >and > > >Deletes. > > > > > >2) Reading the redo log is not a supported interface. From the very > > >beginning, Oracle has changed redo log formats to support >functional > > >enhancements. We must therefore reserve the right to continue to >make > > >needed log format changes. For this reason, certification of any >third > > >party product using this interface is not possible. Since this is >an > > >unsupported interface, the accuracy or completeness of the data in >the > > >destination database can not be assured. > > > > > >Eyal:
RE: Your views on Quest - Shareplex
We are looking into the product as well, but have yet to even toy with the product. There is a "no chained rows" restriction. Shareplex does not replicate transactions on sys objects. A table dropped on one side will not be dropped on the other. It apparently will replicate truncates however. It's one thing to read the logs and to find the time when a truncate caused writes to the data dictionary, but quite another to reconstruct the statement. I didn't think Quest was pushing Shareplex for disaster recovery tool but for replication. Ian MacGregor Stanford Linear Accelertor Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 29, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Here's a theory: Eyal is referring to chained and migrated rows. With media recovery, the recovering instance infers where the migrated or chained data is located, becuase it is an exact physical copy. Since the SharePlex replicated instance is not an exact physical copy of the primary, it must go back to the source database to figure out which blocks' changes represent changes for a block that SharePlex already knows about. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 29 May 2001, Jared Still wrote: > > So how does a standby database work if the logs don't contain > complete transactions? > > On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: > > From note on MetaLink: > > >1) There is not sufficient information in the logs to logically > >replicate transactions, so the data applied to the destination system > >may be different from the primary, and therefore inaccurate. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex Our production runs on a multi-threaded app. And, it is the Single threaded nature of Shareplex with the LONG columns in the db that did not make it suitable for us. Shareplex just could not catch up with the DML activity in our Production. -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 29, 2001 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Your views on Quest - Shareplex >-Original Message- >From: Brian MacLean [mailto:[EMAIL PROTECTED]] >As of a year ago it was single threaded >and didn't handle long columns. I talked to one of the SharePlex developers. a) Shareplex has handled long columns for as long as she remembers (a little more than three years). b) Shareplex has recently supported LOB columns in a production release. c) The next version will include multi-threaded posting. Mr. Goulet, just out of curiosity (for feedback to the product managers), what was it in Eyal Aronoff's response that made you think you would not like to use Shareplex? -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re: Your views on Quest - Shareplex
Just something. First of all, I have never seen Shareplex in operation so this is my gut feeling, chiefly based on how I would have coded it. Most of the arguments against Shareplex has been about their using undocumented features - which I admit may be a concern but wouldn't keep me awake at night. The main difference I see between log-based replication and traditional, trigger-based replication is that with trigger-based replication the log is part of the transaction - in other words, you only see committed changes. With the logs, the picture is different, because you may have uncommitted as well as committed changes in them - you are a bit closer to what people do. Either they wait for transactions to have committed before forwarding them - which I think unlikely because at the first massive update they can go BANG, if what happens to rollback segments from time to time is anything to go by, or, and that's how I would have done it, they forward changes as they come, forwarding commits and rollbacks as well. And in my view, the problem is not on the source, but on the target side. I presume that one, or in the best of case, a limited number of sessions are replaying the original changes; if you have many concurrent sessions on the source, you have a kind of funnelling. Because of Oracle read consistency, the original transactions, if they are working on the same data, may not see exactly the same thing at the same moment. Oracle locks take care of that, but if you multiplex everything I do not see how to keep a consistent picture at the other end, even when strictly respecting chronology. A secondary, and relatively minor compared to the first one, concern would be what happens if a replication process crashes (I know, it's not supposed to happen) and if this is not spotted immediately? I presume that ARCHIVELOG is mandatory, but anyway you must probably have tight operations. It must be perfect for some operations, but I would feel uncomfortable using it on the case-study OLTP database. My 2 cents. Stéphane Faroult "Rao, Maheswara" wrote: > > List, > > My company is considering Quest - Shareplex. > > We are considering to use this in our dataware house. Basically, this will > pull all the transactions from OLTP database and populate staging area in > the dataware house. > > Could you please give your experiences and the pros and cons of this > Shareplex product. > > Thanks, > > Rao > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oriole account INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex >-Original Message- >From: Brian MacLean [mailto:[EMAIL PROTECTED]] >As of a year ago it was single threaded >and didn't handle long columns. I talked to one of the SharePlex developers. a) Shareplex has handled long columns for as long as she remembers (a little more than three years). b) Shareplex has recently supported LOB columns in a production release. c) The next version will include multi-threaded posting. Mr. Goulet, just out of curiosity (for feedback to the product managers), what was it in Eyal Aronoff's response that made you think you would not like to use Shareplex? -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: Re[2]:Your views on Quest - Shareplex
Just being honest and throwing all the information out there ;) Jim -Original Message- [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 4:06 PM To: Multiple recipients of list ORACLE-L Jim, Thanks, just assures me that it is NOT a product that I want around. Dick Goulet Reply Separator Author: "Jim Hawkins" <[EMAIL PROTECTED]> Date: 5/29/2001 11:01 AM All, We are currently as customer of Quest Software using LiveReorg and Spotlight. For those who don't know, LiveReorg is a combination of two existing Quest products, Space Manager and SharePlex. I asked the exact same question regarding the mining of redo logs of our Quest sales rep. I thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Doc ID: Note:97080.1 Subject: Extracting Data from Redo Logs Is Not A Supported Interface Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-JAN-2000 Last Revision Date: 17-FEB-2000 Language: USAENG PURPOSE --- To explain why any extraction of data from redo logs is not supported. SCOPE & APPLICATION --- Customers who are considering using Quest SharePlex for disaster recovery. Extracting Data from Redo Logs Is Not A Supported Interface ------ Quest SharePlex for Oracle replicates data to one or more other Oracle instances. It attempts to use the information in the redo log to replicate transactions remotely. 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. Eyal: That is correct. A part of the SharePlex product goes back to the source database and completes the missing information. This is done only for certain types of Update statements but is not nessasery for Inserts and Deletes. 2) Reading the redo log is not a supported interface. From the very beginning, Oracle has changed redo log formats to support functional enhancements. We must therefore reserve the right to continue to make needed log format changes. For this reason, certification of any third party product using this interface is not possible. Since this is an unsupported interface, the accuracy or completeness of the data in the destination database can not be assured. Eyal: The power of the product is the direct result from reading the raw log data. It is our core competency in Quest to understand and support the changing nature of the Oracle log. The reality is that between version 7.0 until 8.1.6 there where only minor changes to the log. Since we are a close partner with Oracle we get early releases of the software and we have the chance to update the product as needed. So far this has never been an issue since most large production sites are running Oracle versions that are atleast 6 months to a year old. Regarding assurance to the completeness of the data, we do not expect Oracle to provide any assurance. Quest is the one that assures the content of the destination. Quest support has some of the best support experts in the business. Any problem with the database content should be directed to our support organization and not Oracle World Wide Support. Likelihood of Occurrence ~ Unknown. However, even a low likelihood is a concern for disaster recovery (DR). In disaster failovers, the remote server's database may be the only viable copy. Eyal: Since Oracle uses the data in the log to perform database recovery, all the information necessary to create a point in time image of the database exists in the log. However, we believe that SharePlex has a better chance to survive a disaster than even a database recovery. This is because SharePlex only needs the data to recover a transaction while Oracle needs all changes present in the log, including index and rollback changes, to successfully recover a database. An index block corruption may render the recovered database useless. History indicates that SharePlex can withstand most log corruptions and data block corruptions, while maintaining a viable live standby site. If the client is not a 100% sure, SharePlex provides a variety of mechanisms to periodically resync the standby database, including the ability to use a hot backup and 3rd party disk mirroring technologies - all of this without interruption to the main production site and without the need to reactivate the replication. Possible Symptoms
Re: Re[2]:Your views on Quest - Shareplex
I would guess that Oracle is just covering their collective arses, by putting that stuff out. So some junior wannabe coder (like me) doesn't start writing his own log-based replication software - then suing Oracle when they change something. I believe that Oracle actually works with Quest as a partner (thought I read that somewhere, maybe www.quest.com). Anyway, we use Shareplex quite a bit. For simple, one-way, DR replicaction (no users in the target) it's very robust. For a reporting scenario (off-loading reporting processes to a seperate schema, one-way replication) it's still pretty good as long as you can *keep users from changing the data on the target instance*. As you get into more complicated implementations (bi-directional, etc.) you need to think things out more carefully, and have more DBA resources available for monitoring, conflict resolution procedures, etc. Quest's support is very good, in my opinion. They've written patches for us a few times with very short turnaround... Just my 2 cents... Have a good one! - Jerry - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 29, 2001 5:06 PM > Jim, > > Thanks, just assures me that it is NOT a product that I want around. > > Dick Goulet > > Reply Separator > Author: "Jim Hawkins" <[EMAIL PROTECTED]> > Date: 5/29/2001 11:01 AM > > All, > > We are currently as customer of Quest Software using LiveReorg and > Spotlight. For those who don't know, LiveReorg is a combination of two > existing Quest products, Space Manager and SharePlex. I asked the exact > same question regarding the mining of redo logs of our Quest sales rep. I > thought all would be interested in the reply. It is a in-line reply to an > Oracle MetaLink document. > > Jim Hawkins > Lead SAPR/3 Oracle Database Administrator > MEMC Electronic Materials, Inc. > 600 Pearl Drive > St. Louis, MO 633376 > 9636) 474-7832 > [EMAIL PROTECTED] (work) > [EMAIL PROTECTED] (home) > > > > Doc ID: > Note:97080.1 > Subject: > Extracting Data from Redo Logs Is Not A Supported Interface > Type: > BULLETIN > Status: > PUBLISHED > > Content Type: TEXT/PLAIN > Creation Date: 22-JAN-2000 > Last Revision Date: 17-FEB-2000 > Language: USAENG > > PURPOSE > --- > > To explain why any extraction of data from redo logs is not supported. > > SCOPE & APPLICATION > --- > > Customers who are considering using Quest SharePlex for disaster > recovery. > > > Extracting Data from Redo Logs Is Not A Supported Interface > -- > >Quest SharePlex for Oracle replicates data to one or more other Oracle >instances. It attempts to use the information in the redo log to >replicate transactions remotely. > >1) There is not sufficient information in the logs to logically >replicate transactions, so the data applied to the destination system >may be different from the primary, and therefore inaccurate. > > Eyal: That is correct. A part of the SharePlex product goes back to the > source database and completes the missing information. This is done only > for certain types of Update statements but is not nessasery for Inserts and > Deletes. > >2) Reading the redo log is not a supported interface. From the very >beginning, Oracle has changed redo log formats to support functional >enhancements. We must therefore reserve the right to continue to make >needed log format changes. For this reason, certification of any third >party product using this interface is not possible. Since this is an >unsupported interface, the accuracy or completeness of the data in the >destination database can not be assured. > > Eyal: The power of the product is the direct result from reading the raw > log data. It is our core competency in Quest to understand and support the > changing nature of the Oracle log. The reality is that between version 7.0 > until 8.1.6 there where only minor changes to the log. Since we are a close > partner with Oracle we get early releases of the software and we have the > chance to update the product as needed. So far this has never been an issue > since most large production sites are running Oracle versions that are > atleast 6 months to a year old. > > Regarding assurance to the completeness of the data, we do not expect > Oracle to provide any assurance. Quest is the one that assures the content
Re: Your views on Quest - Shareplex
I guess it is in the LOGICALLY. Standby databases are maintained as asynchronous physical copies - which is why they can at best be opened read-only. Typical technical doc obfuscation :-). Jim Hawkins wrote: > > Jared, > > That's a really good question! I don't know the answer... > > Sorry, > Jim > > > On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: > > > > From note on MetaLink: > > > > > > > >1) There is not sufficient information in the logs to logically > > >replicate transactions, so the data applied to the destination system > > >may be different from the primary, and therefore inaccurate. > > > > So how does a standby database work if the logs don't contain > > complete transactions? > > > > Jared > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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). > > > > > > -- > Jim Hawkins > Lead SAPR/3 Oracle Database Administrator > MEMC Electronic Materials, Inc. > 600 Pearl Drive > St. Louis, MO 633376 > 9636) 474-7832 > [EMAIL PROTECTED] (work) > [EMAIL PROTECTED] (home) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jim Hawkins > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re[2]:Your views on Quest - Shareplex
Jim, Thanks, just assures me that it is NOT a product that I want around. Dick Goulet Reply Separator Author: "Jim Hawkins" <[EMAIL PROTECTED]> Date: 5/29/2001 11:01 AM All, We are currently as customer of Quest Software using LiveReorg and Spotlight. For those who don't know, LiveReorg is a combination of two existing Quest products, Space Manager and SharePlex. I asked the exact same question regarding the mining of redo logs of our Quest sales rep. I thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Doc ID: Note:97080.1 Subject: Extracting Data from Redo Logs Is Not A Supported Interface Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-JAN-2000 Last Revision Date: 17-FEB-2000 Language: USAENG PURPOSE --- To explain why any extraction of data from redo logs is not supported. SCOPE & APPLICATION --- Customers who are considering using Quest SharePlex for disaster recovery. Extracting Data from Redo Logs Is Not A Supported Interface ------ Quest SharePlex for Oracle replicates data to one or more other Oracle instances. It attempts to use the information in the redo log to replicate transactions remotely. 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. Eyal: That is correct. A part of the SharePlex product goes back to the source database and completes the missing information. This is done only for certain types of Update statements but is not nessasery for Inserts and Deletes. 2) Reading the redo log is not a supported interface. From the very beginning, Oracle has changed redo log formats to support functional enhancements. We must therefore reserve the right to continue to make needed log format changes. For this reason, certification of any third party product using this interface is not possible. Since this is an unsupported interface, the accuracy or completeness of the data in the destination database can not be assured. Eyal: The power of the product is the direct result from reading the raw log data. It is our core competency in Quest to understand and support the changing nature of the Oracle log. The reality is that between version 7.0 until 8.1.6 there where only minor changes to the log. Since we are a close partner with Oracle we get early releases of the software and we have the chance to update the product as needed. So far this has never been an issue since most large production sites are running Oracle versions that are atleast 6 months to a year old. Regarding assurance to the completeness of the data, we do not expect Oracle to provide any assurance. Quest is the one that assures the content of the destination. Quest support has some of the best support experts in the business. Any problem with the database content should be directed to our support organization and not Oracle World Wide Support. Likelihood of Occurrence ~ Unknown. However, even a low likelihood is a concern for disaster recovery (DR). In disaster failovers, the remote server's database may be the only viable copy. Eyal: Since Oracle uses the data in the log to perform database recovery, all the information necessary to create a point in time image of the database exists in the log. However, we believe that SharePlex has a better chance to survive a disaster than even a database recovery. This is because SharePlex only needs the data to recover a transaction while Oracle needs all changes present in the log, including index and rollback changes, to successfully recover a database. An index block corruption may render the recovered database useless. History indicates that SharePlex can withstand most log corruptions and data block corruptions, while maintaining a viable live standby site. If the client is not a 100% sure, SharePlex provides a variety of mechanisms to periodically resync the standby database, including the ability to use a hot backup and 3rd party disk mirroring technologies - all of this without interruption to the main production site and without the need to reactivate the replication. Possible Symptoms ~ The logs are applied logically, with most correctness checking performed within the SQL generated by SharePlex, So SharePlex itself must alert
Re:Your views on Quest - Shareplex
Rachel, Sorry for the confusion - I meant that my sales rep got Eyal to reply to this, and then sent me the informative email. I did not, however, know that I was getting it from the VP for Technology! I guess I should have been really impressed with my sales reps leg-work! Jim > Jim, > > Um, if that is the Eyal I know, it's Eyal Aronoff and he's not exactly a > "sales rep" for Quest but instead is the Senior VP for Technology and the > person who developed Shareplex. > > Which means you got the best possible answer from the best possible source. > He's brilliant. > > Rachel > > > >From: "Jim Hawkins" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re:Your views on Quest - Shareplex > >Date: Tue, 29 May 2001 11:01:21 -0800 > > > >All, > > > >We are currently as customer of Quest Software using LiveReorg and > >Spotlight. For those who don't know, LiveReorg is a combination of two > >existing Quest products, Space Manager and SharePlex. I asked the exact > >same question regarding the mining of redo logs of our Quest sales rep. I > >thought all would be interested in the reply. It is a in-line reply to an > >Oracle MetaLink document. > > > >Jim Hawkins > >Lead SAPR/3 Oracle Database Administrator > >MEMC Electronic Materials, Inc. > >600 Pearl Drive > >St. Louis, MO 633376 > >9636) 474-7832 > >[EMAIL PROTECTED] (work) > >[EMAIL PROTECTED] (home) > > > > > > > > Doc ID: > > Note:97080.1 > > Subject: > > Extracting Data from Redo Logs Is Not A Supported Interface > > Type: > > BULLETIN > > Status: > > PUBLISHED > > > > Content Type: TEXT/PLAIN > > Creation Date: 22-JAN-2000 > > Last Revision Date: 17-FEB-2000 > > Language: USAENG > > > > PURPOSE > > --- > > > > To explain why any extraction of data from redo logs is not supported. > > > > SCOPE & APPLICATION > > --- > > > >Customers who are considering using Quest SharePlex for disaster > >recovery. > > > > > > Extracting Data from Redo Logs Is Not A Supported Interface > > -- > > > >Quest SharePlex for Oracle replicates data to one or more other Oracle > >instances. It attempts to use the information in the redo log to > >replicate transactions remotely. > > > >1) There is not sufficient information in the logs to logically > >replicate transactions, so the data applied to the destination system > >may be different from the primary, and therefore inaccurate. > > > >Eyal: That is correct. A part of the SharePlex product goes back to the > >source database and completes the missing information. This is done only > >for certain types of Update statements but is not nessasery for Inserts and > >Deletes. > > > >2) Reading the redo log is not a supported interface. From the very > >beginning, Oracle has changed redo log formats to support functional > >enhancements. We must therefore reserve the right to continue to make > >needed log format changes. For this reason, certification of any third > >party product using this interface is not possible. Since this is an > >unsupported interface, the accuracy or completeness of the data in the > >destination database can not be assured. > > > >Eyal: The power of the product is the direct result from reading the raw > >log data. It is our core competency in Quest to understand and support the > >changing nature of the Oracle log. The reality is that between version 7.0 > >until 8.1.6 there where only minor changes to the log. Since we are a close > >partner with Oracle we get early releases of the software and we have the > >chance to update the product as needed. So far this has never been an issue > >since most large production sites are running Oracle versions that are > >atleast 6 months to a year old. > > > >Regarding assurance to the completeness of the data, we do not expect > >Oracle to provide any assurance. Quest is the one that assures the content > >of the destination. Quest support has some of the best support experts in > >the business. Any problem with the database content should be directed to > >our sup
RE: Your views on Quest - Shareplex
Standby database? How do you recover a DB using archived redo logs? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, May 29, 2001 14:41 To: Multiple recipients of list ORACLE-L On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: >From note on MetaLink: > >1) There is not sufficient information in the logs to logically >replicate transactions, so the data applied to the destination system >may be different from the primary, and therefore inaccurate. So how does a standby database work if the logs don't contain complete transactions? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re:Your views on Quest - Shareplex
Jared, That's a really good question! I don't know the answer... Sorry, Jim > On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: > > From note on MetaLink: > > > > >1) There is not sufficient information in the logs to logically > >replicate transactions, so the data applied to the destination system > >may be different from the primary, and therefore inaccurate. > > So how does a standby database work if the logs don't contain > complete transactions? > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re:Your views on Quest - Shareplex
Jared, That's a really good question! I don't know the answer... Sorry, Jim > On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: > > From note on MetaLink: > > > > >1) There is not sufficient information in the logs to logically > >replicate transactions, so the data applied to the destination system > >may be different from the primary, and therefore inaccurate. > > So how does a standby database work if the logs don't contain > complete transactions? > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re:Your views on Quest - Shareplex
Here's a theory: Eyal is referring to chained and migrated rows. With media recovery, the recovering instance infers where the migrated or chained data is located, becuase it is an exact physical copy. Since the SharePlex replicated instance is not an exact physical copy of the primary, it must go back to the source database to figure out which blocks' changes represent changes for a block that SharePlex already knows about. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 29 May 2001, Jared Still wrote: > > So how does a standby database work if the logs don't contain > complete transactions? > > On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: > > From note on MetaLink: > > >1) There is not sufficient information in the logs to logically > >replicate transactions, so the data applied to the destination system > >may be different from the primary, and therefore inaccurate. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Your views on Quest - Shareplex
Rao, I worked at MCI Teleconferencing for a few years and they were using SharePlex for a reporting database. Oracle replication was not fast enough to support their transaction rate and they also could not afford the overhead on the source database that occurs with Oracle replication. After a few startup issues, it worked well for them, and AFAIK, they are still using it. During their research, they also found that Amazon.com was using it for, I think, data warehousing -- not their transactional system. Interesting enough, I understand that Oracle has built an equivalent feature that was planned to be part of 9i. I haven't read enough on 9i to see if it made it in there or not. Perhaps someone else knows about this. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 29, 2001 12:16 PM > List, > > My company is considering Quest - Shareplex. > > We are considering to use this in our dataware house. Basically, this will > pull all the transactions from OLTP database and populate staging area in > the dataware house. > > Could you please give your experiences and the pros and cons of this > Shareplex product. > > Thanks, > > Rao > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rao, Maheswara > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
