Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace Offline on Oracle 817i
On Wed, 30 Jun 2004 21:35:41 -0700, wy wrote:
> data,and move them back when I need the data again.Should all these work be
> done when database is online or offline?
I'd think about first moving data files around and then taking them offline. I don't know if you've noticed but the tables in offline tablespaces never cause performance problems. Consequently, the best way to resolve the performance problem with a big join is to take all the tablespaces, containing tables being joined , offline. That will drastically improve the performance.
-- Well-behaved women seldom make historyReceived on Thu Jul 01 2004 - 19:09:08 CDT
![]() |
![]() |