Pat
The thing this article doesn't mention is that Microsoft is creating
development centers in foreign countries. China hopes Microsoft establishes
a large development center in China. Therefore, China won't publicly say
much against Microsoft.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch,
RE: Purely for your amusementSorry for that HTML reply. OE usually asks me
if I want to send HTML or plain text whent he recipient is marked as "text
only" in the address book. Apparently the fact that oracle-l was in the
reply-to and not the from header confused it and it never asked. It just
sent
Title: RE: Purely for your amusement
Do not fear. Australia is catching up quickly. I've
gotten two "MS security patches" emailed to me in the last two days from a ISP
in AU. I wonder if anyone actually falls for this stuff.
- Original Message -
From:
Nick
Title: RE: Purely for your amusement
I
think the reason that Microsoft does this is to keep the control of OS
market in China. MS has a huge market share in China, almost exclusively.
I read a report a while ago saying some local goverment (Beijing
Minucipal?) is concerned about OS security
Title: RE: Purely for your amusement
hmmm...
ok, let's give one of the largest known hacking/cracking/virii producing countries in the world, the source code to the most common desktop in the world for 'security' purposes?
Bill has got be to smokin' something...
Excerpt from
http://www.siliconvalley.com/mld/siliconvalley/business/columnists/gmsv/5286
438.htm
Microsoft committed to providing Chinese government with information
necessary to buy Microsoft products: The Chinese government will soon be
able to view the source code for the Windows operating sys
it statistic tuning, eh?
> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 3:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Purely for your amusement
>
>
> Let me guess: this is a 64-bit im
Cary Millsap [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 3:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Purely for your amusement
>
>
> Let me guess: this is a 64-bit implementation of Oracle on
> HP? There are apparently lots of Endian bu
Beware of the Beast, aka "Axis", aka "MS Access". Yesterday a user called
to have his Axis query killed because it had been running 10 minutes when it
should only take about a second. After snooping the SQL, Axis was sending
separate SQL statements for each table (in two different sessions), and
Precisely.
In our environment, great care is taken with
adding/modifying data. But when it comes to
reporting, there's no standardization of products or
concern about what's being reported. The DBA's find
out about a bad query when it hits the "this sql
really sucks" list (or when the whining sta
tds-3 has a feature whereby if someone scans your machine, you can (via a
script or manuallY) send the person a message back.
"I know who you are" is a default I think.
Something like that would be useful.
Ad hoc querying and 3rd party tools can be a problem, esp when users don't
know anything a
> Heh. 6 tables, 2 where statements, one of which is an outer. Gotta love
it.
>I'm thinking of building a tool that intercepts dumb SQL and emails back a
raspberry. Whaddya think, is > there a market for such a utility?
Oh yeah ... I'll buy two copies, so long as I can customise the second one
to
t;
> Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> yahoo.com>cc:
>
>
> Sent by: Subject:
> Purely for your amusement
Title: RE: Purely for your amusement
More
wonderful is that the users are complaining about poor performance and not of
wrong data it is returning.
Are
the users comfortable with catesian products returned to them with meaningless
data?
Regards
Naveen
-Original Message-From
The numbers look normal based on three Cartesian joins.
Multiply the card for those Cartesians and you will get big numbers.
Is the sql missing the join predicates(I'm tired to look further)?
Regards,
Waleed
-Original Message-
Sent: Thursday, February 27, 2003 1:24 PM
To: Multiple
Title: RE: Purely for your amusement
Heh. 6 tables, 2 where statements, one of which is an outer. Gotta love it.
I'm thinking of building a tool that intercepts dumb SQL and emails back a raspberry. Whaddya think, is there a market for such a utility?
> -Original Message
lt;[EMAIL PROTECTED]>
cc:
Subject: Re: Purely for your amusement
I found it in our "offending sql statements" report we
get from the database each morning. Went looking when
someone complained about poor performance. (Ya, do
you THINK) Probably not Discoverer.
>
>
> Barbara Baker
>
>
> Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> yahoo.com>
>
>
> Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> yahoo.com> cc:
>
MAIL PROTECTED]>
cc:
Subject: Purely for your amusement
And you thought your job was bad . . .
(Yes, this IS a production job)
--
0 SELECT STATEMENT Optimizer=CHOOSE
(Cost=623898383366
RF,
This looks like a good one for your list:
"11. Developers of SQL should consider using a WHERE clause."
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 25-27 London
-Original Message-
Barbara
Baker
yahoo.com>
cc:
Sent
by:
Subject: Purely for your
amusement
>cc:
Sent by: Subject: Purely for your amusement
Let me guess: this is a 64-bit implementation of Oracle on HP? There are
apparently lots of Endian bugs in how the Oracle kernel emits statistics
on this platform. It's common, for example, for 10046 trace files to
contain row counts in the millions of trillions (or something like
that). It's not *
Title: RE: Purely for your amusement
Barbara,
I just gotta know: How long does it take to run?
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Barbara Baker [SMTP:[EMAIL PROTECTED]
And you thought your job
Have you tried including a WHERE clause ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___March 19th
USA_(FL)_May 2nd
Title: RE: Purely for your amusement
Misery loves company. Thank you!
By the way... how long does this take to finish?
-Original Message-
From: Barbara Baker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 27, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L
Disable all triggers, primary keys and foreign keys... they are obviously
causing all your problems.
Consider purchasing the same hardware as the one used for the MS SQL Server
benchmark.
(not)
Regards,
Pat.
-Original Message-
Sent: Thursday, February 27, 2003 2:53 PM
To: Multiple recipi
I have a hard time believing these figures... unbelievable!
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes
Thanks! I especially liked:
TABLE...FULL OF 'WOE'
That seems to be how the day is going for several of
us.
Scott
>>> [EMAIL PROTECTED] 2/27/03 1:23:55 PM
>>>And you thought your job was bad . . .(Yes, this IS a
production
job)--
Barbara,
I noticed that there was on INDEX being used in the plan.
Please modify the code.
Use of indexes are not permitted unless explicit permission has been given.
thank you.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, February 27, 2003 1:24
And you thought your job was bad . . .
(Yes, this IS a production job)
--
0 SELECT STATEMENT Optimizer=CHOOSE
(Cost=6238983833668070
Card=81143391896031200
10 MERGE JOIN (Cost=6238983833668070
Card=
32 matches
Mail list logo
