RelNotesNotes.txt
-------------------

Notes from my reading of 
9.2.0.1 Release Notes For Solaris (32 bit) Part No. A97348-02
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/A97348_01/toc.htm

If running runInstaller script from cdrom,
make sure the mother shell is outside the cdrom mount point.
This will allow me to eject the cdrom when 
runInstaller wants me to insert another cdrom.

If I'm upgrading from 8.0.6 and I have interMedia in the 8.0.6 DB,
I need to upgrade 'manually'.  I assume this means I need to export
and then import.

The default port for OID (Oracle LDAP product) is 389.

The maximum size of control files is 20000 database blocks.
The minimum data block size is 2048 bytes.
So, if I don't know the size of my data blocks it would be safest to
assume they are 2048 bytes.
And, 2048 bytes X 20000 = about 39mb
Then, if I see my control files approaching a size of 39mb I should
think about storing less information in them.
Be aware that RMAN likes to store information in the control files.

I may create a view named all_segs which helps me check which database
segments are using compression.

create or replace view all_segs
     (owner, segment_name,
       partition_name, spare1
as
select u.name, o.name, o.subname, s.spare1
from sys.user$ u, sys.obj$ o, sys.ts$ ts, sys.sys_objects so,
     sys.seg$ s, sys.file$ f
where s.file# = so.header_file
   and s.block# = so.header_block
   and s.ts# = so.ts_number
   and s.ts# = ts.ts#
   and s.ts# = so.object_id
   and o.owner# = u.user#
   and s.type# = so.object_type_id
   and s.ts# = f.ts#
   and s.file# = f.relfile#
union all
select u.name, un.name, NULLL, NULL
from sys.user$ u, sys.ts$ ts, sys.undo $ un, sys.seg$ s,
     sys.file$ f
where s.file# = un.file#
   and s.block# = un.block
   and s.ts# = un.ts#
   and s.ts# = ts.ts#
   and s.user# = u.user#
   and s.type# in (1, 10)
   and un.status$ != 1
   and un.ts# = f.ts#
   and un.file# = f.relfile#
union all
select u.name, to_char(f.file#)|| '.' || to_char(s.block#), NULL, NULL
from sys.user$ u, sys.ts$ ts, sys.seg$ s, sys.file$ f
where s.ts# = ts.ts#
   and s.user# = u.user#
   and s.type# not in (1, 5, 6, 8, 10)
   and s.ts# = f.ts#
   and s.file# = f.relfile#
/


Some queries they list:

select * from all_segs where bitand(spare1,2048) > 0;
select * from all_segs where bitand(spare1,4096) > 0;

A tablespace may have 'compression settings'; to see what they are,
I may create a view:

create or replace view compression_ts (tablespace_name, flags) 
as select ts.name, ts.flags 
from
sys.ts$ ts 
where ts.online$ !=3
/

Then, I may query the view:

select * from compression_ts where bitand(flags, 64) > 0;

Any rows returned do correspond to tablespaces set to DEFAULT COMPRESS.

Another query:

select * from compression_ts where bitand(flags, 64) == 0;

Any rows returned do correspond to tablespaces set to DEFAULT NOCOMPRESS.

What is compression?

A discussion about compression may be read here:
http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96533/build_db.htm#15912


From the above document I see this:

Data segment compression reduces disk use and memory use
(specifically, the buffer cache), often leading to a better scaleup
for read-only operations. Data segment compression can also speed up
query execution.