Re: temp tablespace growing out of control

Check the Oracle Reference Guide:
a. on your On-line documentation CD-ROM shipped with every software distribution
b. tahiti.oracle.com
In my opinion the doc set in HTML or Acrobat format (whatever you prefere) should be on you harddisk and just one mouseclick away. For acrobat you only have to click index.pdf and you can browse the entire set.

In Chapter 3 (V8.1.7 doc set) the V$-views are described. Read about V$SORT_USAGE and V$SORT_SEGMENT.

clueless <ro_cright_at_hotmail.com> schreef in berichtnieuws 49Eo9.14805$V21.378763_at_news...
| rdbms: ora 8.1.7.4
| o/s: w2k server
| box: Dell Power Edge quad 700 Mhz
|
| My temporary tablespace will grow dramatically (30 to 40 gig) for a short
| period (5 minutes) and then shrink back down to its normal size (5 gig).
I
| can only determine that the segments that are responsible for the growth
are
| named "SYS.4.844802" and similar.
|
| I would like to determine what user is causing the temp segment growth.
Is
| there a way of tracing the name of the temp segment back to a process
| id/user?
|
| Cheers,
| Clueless.
|
|
Received on Tue Oct 08 2002 - 12:56:57 CDT