Mount drive automatically during startup in Solaris

/etc/vfstab (Solaris)
/etc/fstab (Linux)

Step by Step installing Oracle 11g R2 on Oracle Solaris 10

http://kamranagayev.wordpress.com/2011/03/27/step-by-step-installing-oracle-11gr2-on-oracle-solaris-10/

Kill busy device for umount

# umount /dev/dsk/c0t2d0s7

The following command will display all processes and their associated users that are using files/directories on a specified disk on a Sun Solaris system:

# fuser -u /dev/dsk/c0t2d0s7

You can use the -k option to kill all processes using the specified file or filesystem

# fuser -k /dev/dsk/c0t2d0s7

Step by Step installing Oracle 11g R2 on Oracle Solaris 10

http://kamranagayev.wordpress.com/2011/03/27/step-by-step-installing-oracle-11gr2-on-oracle-solaris-10/

Oracle ASM 10g R2

Tool of ASM in Windows NT Platform.

asmtoolg.exe

http://www.databasejournal.com/features/oracle/article.php/3571371/Oracle-10g-Automatic-Storage-Management-ASM-Part-2-Sample-Implementation.htm

copy Oracle Users

http://www.dba-oracle.com/t_copying_oracle_users.htm

how to enable advanced compression option in Oracle 11g

1. Your database version is 11.1.0.6 or higher.

2. Your client software supports 11.1.0.6 or higher.

If the above two conditions are met you don't need SecureFiles, you don't need any init parameters, you just need the following:


CREATE TABLE regtab
AS
SELECT * FROM all_objects
WHERE SUBSTR(object_name,1,1) BETWEEN 'A' AND 'WZZZZZ'

CREATE TABLE comptab
COMPRESS AS
SELECT * FROM all_objects
WHERE SUBSTR(object_name,1,1) BETWEEN 'A' AND 'WZZZZZ';

SELECT table_name, tablespace_name, compression
FROM user_tables
WHERE table_name IN ('REGTAB', 'COMPTAB');


exec dbms_stats.gather_table_stats(USER, 'REGTAB');
exec dbms_stats.gather_table_stats(USER, 'COMPTAB');


SELECT table_name, blocks
FROM user_tables
WHERE table_name IN ('REGTAB', 'COMPTAB');