RE: EM, capacity planning and monitoring
- From: David Robillard <david.robillard@xxxxxxxxx>
- To: Michael McMullen <ganstadba@xxxxxxxxxxx>
- Date: Wed, 15 Sep 2010 08:56:46 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » EM, capacity planning and monitoring- Stefano Cislaghi
- » RE: EM, capacity planning and monitoring- D'Hooge Freek
- » Re: EM, capacity planning and monitoring- Stefano Cislaghi
- » Re: EM, capacity planning and monitoring- Niall Litchfield
- » Re: EM, capacity planning and monitoring- Stefano Cislaghi
- » RE: EM, capacity planning and monitoring- Michael McMullen
- » RE: EM, capacity planning and monitoring- D'Hooge Freek
- » RE: EM, capacity planning and monitoring- D'Hooge Freek
- » Re: EM, capacity planning and monitoring- rjamya
- » RE: EM, capacity planning and monitoring - David Robillard
- » RE: EM, capacity planning and monitoring- Michael McMullen