| Max os file size for SUN Solaris | 2Gb: < Solaris 2.6 (UFS)
1Tb: >= Solaris 2.6 (UFS) 8000Tb: VxFS 1Pb: QFS |
|---|---|
| Max file system size | 1Tb: Solaris UFS
8000Tb: VxFS 1Pb: QFS |
| Max Oracle file size | >4Gb (file system): >=8.0.5.1 + Solaris 2.6
+ patch 760092
>2Gb (file system): 8.0.4.x + Solaris 2.6 + patch 594800 2G (file system): 8.0.4.0.0 (patch 675792) >= 2Gb (raw device): >= 7.3.4 + Solaris 2.5.1 or greater |
| Max SGA size | 3.75Gb: <= Solaris 2.6 (watchout bugs 695468, 792536) |
| async io on file system? | Yes (patch 441394 , 411881 for 7.3.2.x/7.3.3 necessary) |
| Max io size
(>= db_file_multiblock_read_count*db_block_size) |
128K |
| Shared libraries support in PRO*C? | Yes |
| List of dynamic libraries in executable file | /usr/bin/ldd |
| OS version | /usr/bin/uname -a |
| swap status and usage | /usr/sbin/swap -l (swap areas)
/usr/sbin/swap -s (includes RAM) |
| swap in RAM? | Yes |
| Amount of RAM, hardware config | /usr/sbin/prtconf for general information
+ memory
/usr/sbin/psrinfo -v for CPU info /usr/platform/<hardware class>/sbin/prtdiag -v for hardware components /usr/bin/uname -m for <hardware class> |
| OS kernel parameters file | /etc/system |
| OS kernel parameters values | /usr/sbin/sysdef |
| Max number of semaphores sets/identifiers | semsys:seminfo_semmni |
| Max number of semaphores in system | semsys:seminfo_semmns |
| Number of shared segments identifiers to be pre-allocated | shmsys:shminfo_shmmni |
| Max shared segment size | shmsys:shminfo_shmmax
max value: 2147483647 (2Gb): <=solaris 2.5 4294967295 (4Gb): >=solaris 2.5.1 |
| Max number of procs per user/system wide | maxuprc/max_nprocs |
| Max number of open files per user/system wide | ?/ufs_inode |
| Buffer cache size | bufhwm |
| How to get TCP keepalive parameters | ndd /dev/tcp tcp_keepalive_interval |
| How to set TCP keepalive parameters | ndd -set /dev/tcp tcp_keepalive_interval 7200000 (Ex: 2 hours) |
| process limits | /usr/bin/ulimit -a
/usr/bin/ulimit -aH |
| Administration tool | admintool (users, groups, printers...)
format (disks partitions without SSA - Sparc Storage Array) vxva (external disks with SSA) |
| System log file | /var/adm/messages |
| Display system/error messages | dmesg |
| Default tape | /dev/rmt/0 |
| Installed patchs list | /usr/bin/showrev -p |
| Installed packages list | /usr/bin/pkginfo |
| To which package belongs file fname? | grep fname /var/sadm/install/contents |
| Debug and Miscellaneous | /usr/bin/truss (for system call tracing) |
| Core analysis | /opt/SUNWspro/bin/dbx (needs SUNWspro package) |
| init.ora specifics | async_write
async_read post_wait_device use_post_wait_extension use_ism |