Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Objects in the temp tablespaces in 9i

Re: Objects in the temp tablespaces in 9i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 17 Jun 2006 11:29:54 +0200
Message-ID: <fni792d02jama2blcjijeg0evdmtlg9234@4ax.com>


On 16 Jun 2006 15:04:16 -0700, dba_222_at_yahoo.com wrote:

>Back to original question.
>
>How do we find the objects, and their size in the TEMP tablespace in
>9i?
>Or, is it no longer possible?
>
>If anyone knows, please tell us the secret.
>
>Thanks a lot!

Apparently Daniel is right.
You insist on being rude (by topposting) and even when you have no other work to do than to ask irrelevant questions, you well know that the secret is called : RTFM, in this case the description of the relevant v$ views.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Jun 17 2006 - 04:29:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US