Resize operation completed for file# tempfile alert log
On checking one issue on Oracle Database Server, find alert log file which show me the file 1001 is resized.
But on my Server only 10 files are exists in ORADATA folder.
Resize operation completed for file# 1001, old size 1024K, new size 2048K
Resize operation completed for file# 1001, old size 2048K, new size 3072K
Resize operation completed for file# 1001, old size 3072K, new size 4096K
On checking on net found that alert log done resize operation for datafiles and tempfiles
SQL> select count(*) from v$datafile;
count(*)
———-
9
SQL> select file# from v$tempfile;
FILE#
———-
1
Then on researched found that alert log consider the tempfile number according to dba_files parameter on oracle database.
Show parameter db_files
NAME TYPE VALUE
-------- -------- --------
db_files integer 1000
So, the alert log, its using tempfile numbering with db_files parameeter value plus temp file id (file#)
Suppose db_files is 500 then tempfile of file# id 1 is consider by alert log is 501.
That’s why alert log show 1001 value in above example as resize operation:
Resize operation completed for file# 1001, old size 1024K, new size 2048K
Smart way of Technology 