Re: Strange Segment called 6.2 in TEMP

From: Yong Huang <yong321_at_yahoo.com>
Date: 5 Jun 2001 21:25:33 -0700
Message-ID: <b3cb12d6.0106052025.763d9ec5@posting.google.com>

If file# 6 belongs to your temporary tablespace (dba_tablespace.contents = 'TEMPORARY'), don't worry about it.

BTW, one other type of segment named number.number is cache segment. The first and second number, as in the case of temporary segment, is file#, block#, respectively.

Yong Huang
yong321_at_yahoo.com Received on Tue Jun 05 2001 - 23:25:33 CDT

This message: [ Message body ]
Next message: peter.mckenzie_at_health.wa.gov.au: "Rollback segment too old"
Previous message: andrew_webby at hotmail: "Re: Strange Segment called 6.2 in TEMP"
In reply to: Bernie: "Strange Segment called 6.2 in TEMP"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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