| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Would you allow this?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFD612.775D8D40
Content-Type: text/plain;
charset="iso-8859-1"
Even if it is only read only tool and it creates long queries it may cause ora-0155 errors for batch jobs with DML activity. Also it can cause performance degradation.
Alex Hillman
-----Original Message-----
From: Wasserman, Sara [mailto:sjwasserman_at_pscnet.com]
Sent: Tuesday, June 13, 2000 4:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Would you allow this?
It's just a read-only reporting tool? Is it something like Cognos Impromptu/Powerplay, Oracle Discoverer, Hummingbird BiQuery (or whatever it's called these days)?
These read-only tools are OK to demo against production, although if you have a test/development database to support your production database, that might be a better one for the first try (till you're comfortable with it). What do you mean, it's their database? Is it a database for a third-party vendor, and the same third-party vendor wants to demo their new reporting tool?
If a query goes haywire and eats too many resources, just kill it. If it is read-only, it shouldn't hurt anything or cause corruption. They'll probably need a username/password to connect. Create a read-only user and have them use that. (That's what I've done for our reporting tool). If they're not satisfied with that, and/or want soemthing like system, then you should definitely keep fighting.
HTH,
Sara Wasserman
Eugene, OR
> -----Original Message-----
> From: Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
> Sent: Tuesday, June 13, 2000 9:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Would you allow this?
>
> How many of you would allow a vendor to come in and do a demo on a
> PRODUCTION
> DATABASE?
>
> I am being overridden. I am being told to allow it, it's their database
> and if
> they hose it (who knows what this thing is going to do?) it's their
> problem.
> What? It's just a reporting tool, but STILL! I am concerned about it
> starting
> runaway queries and eating up resources reserved for CUSTOMERS.
>
> Can you feel my headache all the way from Minneapolis.... I should just
> take
> the afternoon off.
> Lisa
>
>
-- Author: Wasserman, Sara INET: sjwasserman_at_pscnet.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01BFD612.775D8D40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Would you allow this?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Even if it is only read only tool and it creates long = queries it may cause ora-0155 errors for batch jobs with DML = activity. Also it can cause performance degradation.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman </FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Wasserman, Sara [<A = HREF=3D"mailto:sjwasserman_at_pscnet.com">mailto:sjwasserman_at_pscnet.com</A>= ]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, June 13, 2000 4:21 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Would you allow this?</FONT> </P> <BR> <P><FONT SIZE=3D2>It's just a read-only reporting tool? Is it = something like Cognos</FONT> <BR><FONT SIZE=3D2>Impromptu/Powerplay, Oracle Discoverer, Hummingbird = BiQuery (or whatever</FONT> <BR><FONT SIZE=3D2>it's called these days)?</FONT> </P> <P><FONT SIZE=3D2>These read-only tools are OK to demo against = production, although if you</FONT> <BR><FONT SIZE=3D2>have a test/development database to support your = production database, that</FONT> <BR><FONT SIZE=3D2>might be a better one for the first try (till you're = comfortable with it).</FONT> <BR><FONT SIZE=3D2>What do you mean, it's their database? Is it a = database for a third-party</FONT> <BR><FONT SIZE=3D2>vendor, and the same third-party vendor wants to = demo their new reporting</FONT> <BR><FONT SIZE=3D2>tool?</FONT> </P> <P><FONT SIZE=3D2>If a query goes haywire and eats too many resources, = just kill it. If it is</FONT> <BR><FONT SIZE=3D2>read-only, it shouldn't hurt anything or cause = corruption. They'll probably</FONT> <BR><FONT SIZE=3D2>need a username/password to connect. Create a = read-only user and have them</FONT> <BR><FONT SIZE=3D2>use that. (That's what I've done for our reporting = tool). If they're not</FONT> <BR><FONT SIZE=3D2>satisfied with that, and/or want soemthing like = system, then you should</FONT> <BR><FONT SIZE=3D2>definitely keep fighting.</FONT> </P> <P><FONT SIZE=3D2>HTH,</FONT> <BR><FONT SIZE=3D2>Sara Wasserman</FONT> <BR><FONT SIZE=3D2>Eugene, OR</FONT> <BR><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Lisa_Koivu_at_gelco.com = [SMTP:Lisa_Koivu_at_gelco.com]</FONT> <BR><FONT SIZE=3D2>> Sent: Tuesday, June 13, 2000 9:55 AM</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list = ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: Would = you allow this?</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> How many of you would allow a vendor to come in = and do a demo on a</FONT> <BR><FONT SIZE=3D2>> PRODUCTION</FONT> <BR><FONT SIZE=3D2>> DATABASE?</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> I am being overridden. I am being told to = allow it, it's their database</FONT> <BR><FONT SIZE=3D2>> and if</FONT> <BR><FONT SIZE=3D2>> they hose it (who knows what this thing is = going to do?) it's their</FONT> <BR><FONT SIZE=3D2>> problem.</FONT> <BR><FONT SIZE=3D2>> What? It's just a reporting tool, but = STILL! I am concerned about it</FONT> <BR><FONT SIZE=3D2>> starting</FONT> <BR><FONT SIZE=3D2>> runaway queries and eating up resources = reserved for CUSTOMERS.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Can you feel my headache all the way from = Minneapolis.... I should just</FONT> <BR><FONT SIZE=3D2>> take</FONT> <BR><FONT SIZE=3D2>> the afternoon off.</FONT> <BR><FONT SIZE=3D2>> Lisa</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Wasserman, Sara</FONT> <BR><FONT SIZE=3D2> INET: sjwasserman_at_pscnet.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Wed Jun 14 2000 - 10:08:58 CDT
 |
 |