RE: EM, capacity planning and monitoring

Users are given the keys but not all learn how to drive safely.

-----Original Message-----
From: David Robillard [mailto:david.robillard@xxxxxxxxx] 
Sent: Wednesday, September 15, 2010 8:57 AM
To: Michael McMullen
Cc: oracle-l users
Subject: RE: EM, capacity planning and monitoring

Hello Michael,

> I just got a db that had filled up the filesystem. The server is down
right
> now so I can't check the version #. Anyways, one user using one
tablespace,
> everyday their code, does drop table and then recreates the table.

Wouldn't it be easier to truncate that table instead of using drop
table and recreate everything?

Just curious, that's all.

David

> The datafiles were autoextend, the table was just a couple of meg and
almost
> 100GB of recycle bin.
> I moved the table to a new tablespace with 10Mb allocated.

--
http://ca.linkedin.com/in/davidrobillard

--
http://www.freelists.org/webpage/oracle-l

Other related posts: