We can find top cpu cosumption process by prstat command in Solaris , sometimes it will be necessary for us to find which process is taking more IO or IO Waits. I had searched on the internet. i had find the script to find to top IO Waits. 1. http://www.sun.com/bigadmin/scripts/submittedScripts/psio.pl.txt 2. http://yong321.freeshell.org/freeware/pio.html#mostuseful
The goal of this article is to impart a basic understanding of how to make changes to Sendmail on a machine running the Solaris 9 Operating System. This article is written for engineers with a reasonably good working knowledge of the standard principles of the UNIX operating system. To utilize this article, you need to…
#!/bin/sh ### Sample Script and Method for FTP files from one ### Machine/Host to another Machine. ### ### If you want to ftp few file from ### Host-A (location /b002/org_files/) ### to Host-B (location /u001/b_loc), ### here is the script and methods. ### ### 1) Login into Host-B ### 2) cd /u001/b_loc ### 3) Then…
Today I tried to login as sysdba i was given this error “ORA-01031 Insufficeint Privilege”. So I thought to write troubleshooting tips for ORA-01031 Facts About Operating System Authentication 1. The following syntax is used while OS Authentication sqlplus / as sysdba 2. A SQLNET.AUTHENTICATION_SERVICES controls the operation system authentication. On unix platforms setting the…
Today, I had cleared my IZ046 Managing Oracle on Linux for DBA’s, the exam was sechdule for 9 a.m. I was on time for the exam. The most of the questions where regarding ASM, Installation and Administrating Linux. I was little tense before the exam, how would be the paper, but it was not so…
Simulating Asm by faking hardware 1. Faking Hardware 2. Instaling ASM Lib 3. Configuring the disks 4. Install DB & ASM instance Faking Hardware: Step 1) Here we create 4 zero-filed files using the DD comand As Root run the following commands, this will create 4 files of 2Gb each mkdir /asmdisk dd if=/dev/zero of=/asmdisk/disk1…
Steps for Renaming Redo Log Members Shut down the database. 1. SHUTDOWN 2. Copy the redo log files to the new location.Operating system files, such as redo log members, must be copied using the appropriate operating system commands. See your operating system specific documentation for more information about copying files. The following example uses operating…
Database Statistics Statspack is different from BSTAT/ESTAT Statspack collects more data, including high-resource SQL It precalculates many ratios such as cache hit ratios, rates and transaction statistics It uses permanent tables owned by PERFSTAT user to store performance stats It separates data collection from report generation It makes data collection easy to automate using either…
# sar -d Linux 2.4.21-27.ELsmp (pw101) 12/04/2005 12:00:00 AM DEV tps rd_sec/s wr_sec/s …. Average: dev8-128 7.16 5.37 75.07 Average: dev8-129 7.16 5.37 75.07 Average: dev8-130 0.00 0.00 0.00 …. The above command finds the busiest device. To determine what that device is, do: # more /proc/devices Character devices: 1 mem 2 pty 3 ttyp…