Re: analyzing queries performance

From: Marc Staudacher <marcst_at_gmx.ch>
Date: Fri, 8 Dec 2000 16:53:08 +0100
Message-ID: <90r08c$dmo$1@bw107zhb.bluewin.ch>

> Sorry, I couldn't resist. The tablespace which holds your objects being
> tested should be taken offline to force Oracle to flush its cache.

In addition to that I have to admit it wasn't serious at all. You have to verify in which tablespace your objects are located. As a good practice: never create any non-system objects in your system tablespace. The system tablespace holds some important objects which have to be always accessible (-> system rollback rollback segment, data dictonary) and thats why Oracle won't allow you to take this tablespace offline.

<letokai_at_my-deja.com> wrote in message news:90qem7$7jf$1_at_nnrp1.deja.com...
> "ORA-01541: system tablespace cannot be brought offline; shut down if
> necess "
> is all I get
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 08 2000 - 09:53:08 CST