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: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 27 Jun 2003 08:37:35 +0000
Message-ID: <bdh2ud$s9f$1@ctb-nnrp2.saix.net>


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 - 03:37:35 CDT

Original text of this message

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