Re: Temp Tablespace Question

Thanks for the help/info. I got a better understanding now.

Sean

"Joel Garry" <joel-garry_at_home.com> wrote in message news:1109979269.808153.75490_at_o13g2000cwo.googlegroups.com...
>
> SG wrote:
>> Running 10g RAC (10.1.0.3) on Redhat ES 3.0.
>>
>> First of all, I'm new to the Oracle world so if I am way off track,
> please
>> correct me.
>> My understanding of a temp tablespace and its function is that a temp
> extent
>> is not "deallocated" once allocated for sorting ops and will remained
>
>> allocated for the life of the instance. However, once allocated, they
> can be
>> reused by new sessions. Is that correct? How can one tell what
> segments are
>> available for reuse? I have used "select * from v$sort_usage;" and it
>
>> returns o rows. If an application connects to the database, and is
> running a
>> dynamic sql loop statement, won't that continually expand the temp
>
> If you have support,
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1039341.6
> and the links at the bottom of it are pretty informative, even if they
> don't say much about 10. I would strongly recommend signing up for
> metalink if you haven't already.
>
> http://www.dbaoracle.net/readme-cdos.htm
>
> jg
> --
> @home.com is bogus.
> https://businessfilings.ss.ca.gov/frmDetail.asp?CorpID=01536063&qrystring=ORACLE&qrynumber=NULL
>
Received on Sun Mar 06 2005 - 07:14:34 CST