File Number Exists In DBA_HIST_ACTIVE_SESS_HISTORY But Not In DBA_DATA_FILES (Doc ID 1235533.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

DBA_HIST_ACTIVE_SESS_HISTORY dictionary view has records for files whose current_file# does not exist in DBA_DATA_FILES.


Also current_file# value is more than DB_FILES parameter value as seen below:

SQL> select snap_id, user_id, current_file#
2 from dba_hist_active_sess_history
3 where current_file#>(select value from v$parameter where name = 'db_files');

SNAP_ID USER_ID CURRENT_FILE#
---------- ---------- -------------
368 0 201

SQL> select file_name from dba_data_files where file_id = 201;

no rows selected

SQL> select max(file_id) from dba_data_files;

MAX(FILE_ID)
------------
6

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms