Sunday, November 30, 2014

Where file# 203 come from in the alert log

2014-11-30 16:37:56.111000 +08:00
Resize operation completed for file# 203, old size 20480K, new size 21504K
Resize operation completed for file# 203, old size 21504K, new size 22528K
Resize operation completed for file# 203, old size 22528K, new size 23552K
Resize operation completed for file# 203, old size 23552K, new size 24576K
Resize operation completed for file# 203, old size 24576K, new size 25600K
Resize operation completed for file# 203, old size 25600K, new size 26624K
Resize operation completed for file# 203, old size 26624K, new size 27648K
Resize operation completed for file# 203, old size 27648K, new size 28672K
Resize operation completed for file# 203, old size 28672K, new size 29696K
Resize operation completed for file# 203, old size 29696K, new size 30720K
Resize operation completed for file# 203, old size 30720K, new size 31744K
Resize operation completed for file# 203, old size 31744K, new size 32768K
Resize operation completed for file# 203, old size 32768K, new size 33792K
Resize operation completed for file# 203, old size 33792K, new size 34816K
Resize operation completed for file# 203, old size 34816K, new size 35840K
Resize operation completed for file# 203, old size 35840K, new size 36864K
Resize operation completed for file# 203, old size 36864K, new size 37888K
Resize operation completed for file# 203, old size 37888K, new size 38912K
Resize operation completed for file# 203, old size 38912K, new size 39936K
Resize operation completed for file# 203, old size 39936K, new size 40960K
2014-11-30 16:37:57.111000 +08:00
Resize operation completed for file# 203, old size 40960K, new size 41984K
Resize operation completed for file# 203, old size 41984K, new size 43008K
Resize operation completed for file# 203, old size 43008K, new size 44032K
Resize operation completed for file# 203, old size 44032K, new size 45056K
Resize operation completed for file# 203, old size 45056K, new size 46080K
Resize operation completed for file# 203, old size 46080K, new size 47104K
Resize operation completed for file# 203, old size 47104K, new size 48128K
Resize operation completed for file# 203, old size 48128K, new size 49152K
2014-11-30 18:08:04.016000 +08:00
Resize operation completed for file# 3, old size 614400K, new size 624640K

SQL> select * from cdb_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ---------- -------
RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
    CON_ID
----------
/u01/app/oracle/oradata/cdborcl/pdb1/pdb1_temp012014-11-29_10-40-40-PM.dbf
         3 TEMP                             50331648       6144 ONLINE
           1 YES 3.4360E+10    4194302           80   49283072        6016
         3

/u01/app/oracle/oradata/cdborcl/temp01.dbf
         1 TEMP                             62914560       7680 ONLINE
           1 YES 3.4360E+10    4194302           80   61865984        7552
         1


SQL> select 50331648/1024 from dual;

50331648/1024
-------------
        49152