Re: Finding owner of a temporary segment

There are no clear simple ways to do this on v7.

Probably the quickest and surest way is to do a a 'systemstate dump level 2' with oradbx on unix platforms.

There is also a cool sql query, see

http://www.geocities.com/oraperf/tempseg/index.html

but this query depends on platform specific stuff like byte swapping and word length. Be sure they are set correctly in the plsql code before running it. An example of running it is in the header of the sql script as well as on the web page.

Best
Kyle Hailey

PS The pro*C links on the above page are intentionally inaccessible.

On Wed, 7 Mar 2001 21:56:12 +0100, jantah <jantah_at_hot.mail.com> wrote:

>Hi all,
>
>I would like to know if there is a way to find out who is the owner of a
>segment that I can see in the temporary tablespace. The tablespace manager
>shows a segment that remains there all day. It is owned by sys, but afaik
>all temporary segments are. I cannot find any info on temporary segments in
>the system views.
>
>(running Oracle 7.3.3)
>
>Thanks
  Received on Thu Mar 08 2001 - 05:38:20 CST