Re: analyzing queries performance

In our last gripping episode letokai_at_my-deja.com wrote:
> "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.
>

Unfortunately the previous poster's sense of humour leaves much to be desired.

The only tablespace you need to take offline is the tablespace containing the tables and/or indexes involved in the query. As an example:

You have a query accessing the ORDERS table and the ORDER_DETAILS table, and there are indexes on both tables. The tables reside in the PROD_DATA tablespace and the indexs in PROD_INDXS tablespace. To clear the data cache take the PROD_DATA tablespace offline and then bring it back online. To also clear the index cache do the same to the PROD_INDXS tablespace. Then run your query again.

As you have rudely discovered one cannot take the SYSTEM tablespace offline. You should not have been told to do so, especially in jest.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.