In SQL*Plus, run the command "show parameter db_files" which will show you that the initialization parameter DB_FILES is set to 200, so your first tempfile is numbered 201.
If you were to add another tempfile, it will be numbered 202. And so on...
henry wrote:
I thought the same thing at first, but I've only got one tempfile in this system. It doesn't get me anywhere close to 201.Henry Tim Gorman wrote:Tempfiles are numbered from (DB_FILES+1) upward... Quoting Henry Poras <henry@xxxxxxxxxxxxxxx>:I have a session on a development system that is waiting on 'db file sequential read'. It has been waiting for ~6000 seconds (state=WAITING).File# (p1) is 201, yet the database only has file#'s from 1-19 (select file#from v$datafile).That explains the long wait. It's trying to read from a non-existent file.Henry
-- //www.freelists.org/webpage/oracle-l
