Search Results

Hi Rudic and MadeInGermany,

Thanks guys. It seems working.
I also learn new things about awk and nawk different.:)

Hi,
Recently i have write a simple script to capture CPU high usage based on prstat but i found out that it did capture correctly. I need to capture the rows that contains CPU usage more than 3%....

Hi,

Recently we faced awkward situation where we cannot connect to Oracle DB that hosted in Solaris server intermittently and it timeout eventually. The server seems fine. We can putty to server...

Hi Peasant,
Sorry, Solaris 10.
My previously DBA who handled Solaris DB server informed me that sawpped the server IP is just by edit the host IP in /etc/hosts then restart the both server same...

Hi All,
Recently we got swapped IP between two server. Server A IP is xxxx and while Server B IP is yyyy. After swap IP the situation should be like this Server A IP is yyyy while Server B IP is...

Hi achenlejlliagre,
We are using RMAN backup. The DB is LDOM which we hosted in CDOM host. Futher check find out that, even LDOM level no io queue but saw io queue at CDOM hostserver while backup...

Hi Jlliagre,achenle,
I have set the zfs_arc_max = 4GB but still when run the backup the DB seems hangs and got error "WARNING: aiowait timed out 1 times". The memstat during backup as below;


...

Hi achenle/jlliagre,
Thanks for feedbacks. I really appreciate it. The vendor also proposing on limiting the zfs_arc parameter value. Currently I am trying use perfstat script to capture log when...

Hi jlliagre,

Currently we use the affected filesystem to store database related files such tables,indexes.

Below is the our current ZFS setting. Mostly i heard...

Hi jlliagre,
I have read it and found need to change some zfs value parameter. Is that safe to change those parameters recommended? Is that will affect the data in that filesystem?

Hi Jllagre,Peasant,Don

Any idea on how to solve my issue regarding DB hang when backup(RMAN)? I already give sar -d output earlier. How to fine tune the zfs parameter especially the arc_max?
Is...

Hi Peasant,

We are using NetApps SAN external storage. Actually we are using multiple zpools for our our database.

The values for our kernel parameters are also below;




How to get...

Hi,
Recently we have new server T5 Oracle. We set up it for our database. For out database files we set one zfs filesystem. When i use iostat -xc the output as below. As you see the value for vdc4...

Hi Yoda,
Thanks for the reply.
I got error as below
ksh:uuidgen not found
ksh:base64 not found

Hi Guys,
I am trying to send email from solaris server using sendemail utility. I want to send multi content email. For example, i want to send email body with html file and a attachment of txt...

Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query

select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows...

Hi Jilliagre,
Thanks for the reply. I try use your above code but get Variable syntax error. Kindly need your help..

Hi Jlliagre,
Thanks for the reply. I send the output to email like below

prstat 5 1|nawk 'NR==1 {COLS=NF; for (i=1; i<=COLS; i++) printf "+--------"; printf "------------+\n" }
$9 >= 0.1 { for...

Hi Duke,
Thanks for the reply. I have go through the site before but not quite helpful?
Is that possible to get tape details from command?

Hi,
I am using HP Ultarium Tape drive to backup my oracle DB. Is that any command to identify the tape serial number or any other tape details that inserted into the tape drive?

Hi RudiC,
Thanks for your reply. I thinkthat is HTML email. So kindly explain how send output to email using HTML table format?

Hi Jiliagre,
Thanks for the reply.
When i send the output to the email, the border is not consistent as below....

Hi Don Cragun,
Sorry for my mistake. When I do prstat in my SUN server the output as below:
PID|Username|Size|RSS|State|PRI|NICE|TIME||CPU|Process/NLWP

So when I need to capture CPU(field...

Hi RUdic,
Thanks for the reply. Sorry for less details. but return output like above for below filter where I only want to capture the process which use more than 5% CPU usage.
prstat|awk '{ if...

Mean like this prstat output tranform into table looks having borders.