Re: Objects in the temp tablespaces in 9i

From: <dba_222_at_yahoo.com>
Date: 16 Jun 2006 15:04:16 -0700
Message-ID: <1150495456.925340.302310@p79g2000cwp.googlegroups.com>

Hmm. This is a interesting concept.

Daniel Morgan would suggest that Oracle objects are found in a different places, depending on what business issue I want to do.

So if it's OLTP, the temp objects would be found with one method, but differently, if it was a DWH. Please stand up and say that at the next Oracle user group meeting.

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!

> <WITH APOLOGIES>
> I can't tell you why but I am suffering from an irresistible urge
> to ask if you have any real work to do so I will.
>
> What is the business issue you are addressing?
> </WITH APOLOGIES>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Fri Jun 16 2006 - 17:04:16 CDT