Hi,
what are all best performance practices we can set in solaris box for oracle database 10.2.0.2

Thanks.

1, Setup max shared memory and no semaphores as per the Oracle documentation.

2, Place ALL database files on 1 volume spanning as many disks as you have. Place online redo logs on a Raid 1/10 vol. Place archive redo logs on another Raid1/10 vol.

3, Mount the database files volume with forcedirectio and set the Oracle parameter FILESYSTEMIO_OPTIONS = setall

4, Follow OFA (Oracle Optimal Architecture Guidelines) - use google.

5, Use LMT's locally managed tablespaces everywhere .

6, Use automatic UNDO, and ASSM (Automatic Shared Memory Management) - via 1 oracle parameter SGA_TARGET. Also set PGA_TARGET an mimimum values for the Shared Pool and Buffer Cache.

7, Use an SPFILE

8, Use the standard Oracel dbconsole, its excellent for ad-hoc monitoring.

9, Always use Archive Logging if the database is important.

10, Use RMAN, its fast and easy to use.

Can you show me how to encrypt oracle password table ?
The link provided in the other post is confusing.
Thanks experts!

There's a plain text root password in my rman script. Is it possible to run it without root password ?