You know how those conversations go...you're introduced to someone new. If you're good with names, you've got
it and don't need to ask that
again. But you still need to know some basics:
- Where do you live?
- What do you do?
- What's your sign?
- Linux or Windows?
- Etc.
It's the same when you meet your new database server. There are some
things you just have to know. I met a couple of Solaris servers this
past week, and the conversations went something like:
- What's your name (or to be more specific and in order, OS name,
node name, OS release, processor type, and platform name) again?
> uname -snrpi
SunOS hostname 5.9 sparc SUNW,Sun-Fire-480R
- Pleased to meet you. How many
processors do you have?
> psrinfo
0 on-line since 10/23/2006 18:58:10
1 on-line since 10/23/2006 18:58:10
2 on-line since 10/23/2006 18:58:10
3 on-line since 10/23/2006 18:52:38
- Four processors. Nice. And how much memory do you have?
> prtconf | grep Memory
Memory size: 32768 Megabytes
- Wow! With 32GB of RAM, you must be 64 bit Solaris. Or are you
32 bit? (For 32 bit, only the 32 bit line below will be displayed.)
> isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
- 64 bit. I thought so. Are you running 32 or 64 bit
Oracle?
> cd $ORACLE_HOME/bin
> file oracl*
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked,
not stripped
oracleO: ELF 32-bit MSB executable SPARC Version 1, dynamically linked,
not stripped
- That's a shame. All that memory, and Oracle can only address
4GB of it. Can I ask about your kernel parameters?
> cat /etc/system | grep info
set shmsys:shminfo_shmmax=4294967296
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semmns=1024
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semmap=20
- They look fine, but can I see what parameters your kernel is
using right now?
> sysdef | tail -20
* IPC Semaphores
*
1024 semaphore identifiers (SEMMNI)
1024 semaphores in system (SEMMNS)
30 undo structures in system (SEMMNU)
256 max semaphores per id (SEMMSL)
100 max operations per semop call (SEMOPM)
10 max undo entries per process (SEMUME)
32767 semaphore maximum value (SEMVMX)
16384 adjust on exit max value (SEMAEM)
*
* IPC Shared Memory
*
4294967296 max shared memory segment size (SHMMAX)
1024 shared memory identifiers (SHMMNI)
*
* Time Sharing Scheduler Tunables
*
60 maximum time sharing user priority (TSMAXUPRI)
SYS system class name (SYS_NAME)
(Or for an individual parameter)
> sysdef | grep -i shmmax
4294967296 max shared memory segment size (SHMMAX)
- What shell am I using? My default is the Korn shell
> echo $SHELL
/bin/ksh
- And I am still using the Korn shell. It's my favorite.
> ps | grep `echo $$`
/bin/ksh
- Thanks for asking. It was a pleasure to meet you. One last
question...what's your sign?
> exit
Note: This tip was tested on Solaris.
Was this tip useful? Did you
find any errors? Do you have any suggestions? Do you care? Click
here for the tip feedback page. Thank you.
| 
