Re: temp tablespace in 10g

From: News <Contact_404_at_hotmail.com>
Date: 11 Sep 2006 10:44:07 -0700
Message-ID: <1157996647.502109.313970@d34g2000cwd.googlegroups.com>

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 released by smon after completion of the process using them. This is why we never encountered this problem in 7, 8 or 9i.

Is creating temp tablespace as permanent in 10g may be a solution to this problem ?? Received on Mon Sep 11 2006 - 12:44:07 CDT