Re: tasks of ORACLE DBA

From: GC <assistant_madman_at_hotmail.com>
Date: Wed, 10 Jan 2001 11:35:39 GMT
Message-ID: <3A5C499B.250A5506@hotmail.com>

Jonathan Lewis wrote:
>
> Close, but not close enough -
>
> ... full table scans are usually *bad*

In this context - really bad. Updating a row (ok, 2.5 million rows) on one table by selecting against another (unindexed) temporary table just loaded via sqlldr. By the time they got around to asking me to look at it, it had run for about 16 hours, and had only updated about 30000 rows. Fortunately, it was only in a test db, but *sheesh*.

Is there an alt.dba.recovery, similar to alt.sysadmin.recovery? :)

Cheers,
GC Received on Wed Jan 10 2001 - 05:35:39 CST