Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> My database is too fast
Morning Billy,
two things to try out :
Cheers,
Norman.
--
(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