Re: temp tablespace in 10g

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 11 Sep 2006 20:41:32 +0200
Message-ID: <ee4aap$42a$2@news6.zwoll1.ov.home.nl>

News schreef:
> News a écrit :
>

>> I have problem with tablespace temp that increases and never decreases.

>
> I found out this in metalink
>
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1039341.6
>
> This problem raised since we upgraded to 10g and because, as far as I
> understood from upgrade information tool, temporary tablaspace in 10g
> must be created with TEMPORARY clause otherwise one gets warning about
> "not enough space in temp tablespace" during upgrade. In previous
> releases we used PERMANENT tablespace to hold temp objects which are

Temporary files for temporary tablespaces have been around ever since 8.0 - I fail to see why you are not using them.

Permanent tablespaces have overhead - your performance will increase!

And on MV's - don't recreate them - refresh then with the changes only - it's called a fast refresh.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Mon Sep 11 2006 - 13:41:32 CDT