Unix for Oracle DBAs Pocket Reference by Donald K. Burleson

By Donald K. Burleson

This pocket reference booklet is perfect for DBAs who must have the really expert Unix database instructions at their fingertips. with out losing area on common Unix instructions DBAs do not use, it concisely summarizes in basic terms what an Oracle DBA must comprehend. This publication comes in handy for DBAs at present operating with Unix, and for these making the transition from Oracle below home windows NT/2000 to Oracle less than Unix.

Show description

Read Online or Download Unix for Oracle DBAs Pocket Reference PDF

Best oracle books

Oracle performance survival guide: a systematic approach to database optimization

A scientific method of Database Optimization the short, entire, start-to-finish consultant to optimizing Oracle functionality Oracle functionality Survival consultant deals a based, systematic, start-to-finish technique for optimizing Oracle functionality as successfully as attainable. prime Oracle professional man Harrison exhibits tips to maximize your tuning funding by way of concentrating on factors instead of indicators, and through fast picking out the parts that bring the best “bang for the greenback.

OCP Oracle Database 10g: New Features for Administrators Exam Guide

Arrange for the Oracle qualified expert Oracle Database 10g New positive aspects for directors examination with aid from this unique Oracle Press consultant. Get whole assurance of all themes at the improve examination, together with set up, configuration, program tuning, database administration, backup and restoration, safety, and extra.

Father Brown Mysteries 09 The Oracle of the Dog

"I'll let you know what occurred then," acknowledged Fiennes with a grim emphasis. "When we obtained again into that backyard first thing we observed was once Traill the legal professional; i will see him now along with his black hat and black whiskers relieved opposed to the viewpoint of the blue plant life stretching right down to the summer-house, with the sundown and the unusual define of the Rock of Fortune within the distance.

Additional resources for Unix for Oracle DBAs Pocket Reference

Example text

PCI Bus isa0 ... ISA Bus sa0 ... Standard I/O Serial Port sa1 ... Standard I/O Serial Port scsi0 ... Wide SCSI I/O Controller hdisk0 ... 16 Bit SCSI Disk Drive hdisk1 ... 16 Bit SCSI Disk Drive ... 3 Display System Kernel Parameters in HP-UX You can use the kmtune command to display all of the kernel configuration parameter settings for HP-UX Version 11. Certain kernel parameters, such as semmni and maxusers, are critical to the successful operation of Oracle under Unix. Here's an example showing the type of output that you'll get from kmtune : >kmtune Parameter Value =================================================== NSTRBLKSCHED 2 NSTREVENT 50 NSTRPUSH 16 NSTRSCHED 0 STRCTLSZ 1024 STRMSGSZ 65535 acctresume 4 acctsuspend 2 aio_listio_max 256 ...

Note that when you kill Oracle background processes such as PMON and SMON, you must also issue the ipcs command to ensure that all memory segments used by those processes are removed. The ipcs command is discussed in detail later in this book. The basic format of the kill command is: kill -9 PID1 PID2 PID3... To kill all Oracle processes (for all instances), you can issue the following command: ps -ef|grep "ora_"|grep -v grep|awk '{print $2}'|xargs -i kill -9 {} There are times when even the kill -9 command fails to remove a process.

You should modify the storage parameters and tablespace name to suit your environment. ksh script, which uses vmstat to gather statistics and then stores them in the MON_VMSTATS table. The script is currently set to sample the statistics every five minutes. /bin/ksh # First, we must set the environment. ORACLE_SID=BURLESON export ORACLE_SID ORACLE_HOME=`cat /etc/oratab|\ grep \^$ORACLE_SID:|cut -f2 -d':'` export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH MON=`echo ~oracle/mon` export MON SERVER_NAME=`uname -a|awk '{print $2}'` typeset -u SERVER_NAME export SERVER_NAME # Sample every five minutes (300 seconds).

Download PDF sample

Rated 4.92 of 5 – based on 13 votes