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. I can't connect to strace (attach: ptrace (PTRACE_ATTACH, .): Operation not permitted). Has anyone seen this before? Any ideas where to look? Just reboot and try for the best? Henry
-- //www.freelists.org/webpage/oracle-l