On 28 October 2010 16:39, Little, Douglas <DOUGLAS.LITTLE@orbitz.com> wrote: > > Hi, > > We’re having to vacuum full the system tables everyday due to the number of temp table drop/creates. > > We’re finding that if anyone tries to execute a job during the maintenance period, it often hangs the db. > > > > Is there a way that we can force the db to quiesce? Or lock out users. > > Luckly, most users are coming in thru a network VIP, so all client IP’s are the same. > > > > Thanks in advance. > > > > Doug Little > > > > Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide > > 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741 > > Douglas.Little@orbitz.com > > orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com > >