Resize operation completed for file# tempfile alert log

 

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s