ORACLE 10g的功劳薄和忏悔书

Doc id       Document title
-------------------------------------------------------------------------
302663.1  10.1.0.4 Patch Set - Availability and Known Issues.mht
356201.1  10.1.0.5 Patch Set - Availability and Known Issues.mht
401435.1  10.2.0.3 Patch Set - Availability and Known Issues.mht
555579.1  10.2.0.4 Patch Set - Availability and Known Issues.mht
         
   
295763.1  10.1.0.4 Patch Set - List of Bug Fixes by Problem Type.mht
335869.1  10.1.0.5 Patch Set - List of Bug Fixes by Problem Type.mht
391116.1  10.2.0.3 Patch Set - List of Bug Fixes by Problem Type.mht
401436.1  10.2.0.4 Patch Set - List of Bug Fixes by Problem Type.mht
         
                  
263719.1  Oracle 10g Release 1 (10.1) Support Status and Alerts.mht
316900.1  Oracle 10g Release 2 (10.2) Support Status and Alerts.mht

其他重要参考

Doc id       Document title
-------------------------------------------------------------------------
282036.1  Minimum Software Versions and Patches Required to Support Oracle Products on IBM pSeries
169706.1  Oracle Database on AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
263719.1  Oracle 10g Release 1 (10.1) Support Status and Alerts.mht
316900.1  Oracle 10g Release 2 (10.2) Support Status and Alerts.mht

         
         
ORACLE PSR List:
--------------------------------------------------------------------------        
9.2.0.4  = 3095277         
9.2.0.5  = 3501955
9.2.0.6  = 3948480
9.2.0.7  = 4163445
9.2.0.8  = 4547809
                 
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
                 
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189

SQL*Plus: Release 10.1.0.4.0 - Production on Wed Apr 16 10:40:17 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options
 
SQL> create table xx (x number) storage(initial 64k next 64k) initrans 2
Table created.
SQL>  truncate table xx;
Table truncated.
SQL> select dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx;
no rows selected
SQL> INSERT INTO XX SELECT 11 FROM DUAL;
1 row created.
SQL>                                   
SQL>  set linesize 200
SQL>  column SEGMENT_NAME format a16
 select SEGMENT_NAME,EXTENT_ID,BLOCKS,BYTES from user_extents  where segment_name ='XX';SQL>

SEGMENT_NAME      EXTENT_ID     BLOCKS      BYTES
---------------- ---------- ---------- ----------
XX                        0        128    1048576

SQL> select x ,dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx;

         X      FILE#     BLOCK#
---------- ---------- ----------
        11         51       4590

SQL> INSERT INTO XX SELECT 12 FROM DUAL;

1 row created.

SQL> select x ,dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx;

         X      FILE#     BLOCK#
---------- ---------- ----------
        12         51       4534
        11         51       4590

SQL>
SQL> INSERT INTO XX SELECT 13 from dual;

1 row created.

SQL> select x ,dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx;

         X      FILE#     BLOCK#
---------- ---------- ----------
        12         51       4534
        11         51       4590
        13         51       4658

SQL> INSERT INTO XX SELECT 14 from dual;

1 row created.

SQL> select x ,dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx;

         X      FILE#     BLOCK#
---------- ---------- ----------
        12         51       4534
        11         51       4590
        13         51       4658
        14         51       4658

SQL> select x ,dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx;

         X      FILE#     BLOCK#
---------- ---------- ----------
        12         51       4534
        11         51       4590
        13         51       4658
        14         51       4658

SQL> commit;

Commit complete.

SQL>  INSERT INTO XX SELECT 15 from dual;

1 row created.

SQL> insert into xx select 16 from dual;

1 row created.

SQL> commit;

Commit complete.

SQL> select x ,dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block# from xx order by x;

         X      FILE#     BLOCK#
---------- ---------- ----------
        11         51       4590
        12         51       4534
        13         51       4658
        14         51       4658
        15         51       4658
        16         51       4658
       
        21         51       4537
        22         51       4537
        23         51       4537
        24         51       4537
        25         51       4537
        26         51       4537
       
       
        31         51       4680
        32         51       4614
        33         51       4614
        34         51       4614
        35         51       4614
        36         51       4614

18 rows selected.