Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> My database is too fast

My database is too fast

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 27 Jun 2003 10:51:46 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703D6F845@lnewton.leeds.lfs.co.uk>


Morning Billy,

two things to try out :

  1. Have another cup of coffee
  2. Remove said table from your obviously overlarge KEEP POOL :o)

Cheers,
Norman.

--



Norman Dunbar (at home on Linux)
Oracle_at_mssqlBountifulSolutions.co.uk

(Delete a Microsoft database name to reply - clue, mssql !)


-----Original Message-----

From: Billy Verreynne [mailto:vslabs_at_onwe.co.za] Posted At: Friday, June 27, 2003 9:38 AM Posted To: server
Conversation: My database is too fast
Subject: My database is too fast

Dear Comp.Databases.Oracle.Server,

I have loaded 77 million rows into a single partition in a partition table.
The other partitions are empty.

A "select count(*) from table" took 3.07 seconds. Neither table nor partition indexes are analyzed!! This is horrifying!

I'm nervous to load the rest... will the database not be too fast?

Will this not damage the Oracle perception of SQL-Server users?

Will it not upset Bill Gates?

And what about the developers? Pretty soon they could be thinking they don't
need a DBA anymore to ask for performance tuning assistance when the database is this fast.

Management otoh may expect this type of performance from my databases all
the time!

What to do!?

Yours Sincerely,
A DBA in quandary

--

Billy Received on Fri Jun 27 2003 - 04:51:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US