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
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
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
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
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
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
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 !
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
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
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
=) 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
!! 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 !!
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
!! 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
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'
[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
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
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:
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
33 matches
Mail list logo