Re: Temp tbs with no temp file
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: all_about_oracle@xxxxxxxxxx
- Date: Tue, 5 Jul 2005 16:02:02 +0100
I don't do that, but I would write a script to check the alert log
periodically - and I don't like the 10g style WARNING notices because they
tend not to get picked up by existing scripts.
Do you guys write script to check the existing of the tempfile? I think I
need to add "ADD TEMPFILE" in my startup script.
Regards,
Sinardy
----- Original Message -----
From: "Kirtikumar Deshpande" <kedeshpande@xxxxxxxxx>
To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>; <all_about_oracle@xxxxxxxxxx>
Sent: Tuesday, July 05, 2005 3:52 AM
Subject: Re: Temp tbs with no temp file
> Hi,
> Sorry I did not catch all the messages in this thread...
>
> So, is this temporary tablespace the default at database level?
>
> Look in DATABASE_PROPERTIES to check which tablespace is the default
temporary
> tablespace.
>
> select *
> from database_properties
> where property_name = 'DEFAULT_TEMP_TABLESPACE';
>
> If the default temp tablespace is the same that does not have any
tempfiles associated
> with it, then your sorting, so far, did not need to write to sort segments
and was
> completing in memory (same for the hash joins). If those segments needed
to be written to
> temp tablepace without tempfiles you would have seen following error:
>
> ORA-25153: Temporary Tablespace is Empty
>
>
> HTH,
>
> Cheers!
>
> - Kirti
>
>
> --- Sinardy <all_about_oracle@xxxxxxxxxx> wrote:
>
> > My DB without temp file (tablespace) for like two months during this
time
> > where are the sorting being carried out? I know add temp file will work
but
> > just curious how come I can work without temp file.
> >
> > regards,
> > Sinardy
> >
> >
> >
>
>
>
> __________________________________
> Yahoo! Mail
> Stay connected, organized, and protected. Take the tour:
> http://tour.mail.yahoo.com/mailtour.html
>
>
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
