Oracle Server Overloaded?? RAM added to 32G

top - 17:32:31 up 3 days, 16:45,  3 users,  load average: 10.04, 10.15, 10.48
Tasks: 153 total,  11 running, 142 sleeping,   0 stopped,   0 zombie
Cpu(s): 90.1% us,  4.4% sy,  0.0% ni,  1.0% id,  2.9% wa,  0.5% hi,  1.0% si
Mem:  32904160k total, 32845724k used,    58436k free,   527928k buffers
Swap:  2097144k total,   148640k used,  1948504k free, 31528636k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1158 oracle9   20   0 5029m 2.8g 2.8g R 96.5  9.1 325:23.94 oracle
 2968 oracle9   17   0 5028m 1.7g 1.7g R 94.5  5.3  30:07.38 oracle
 2795 oracle9   25   0 5028m 2.0g 2.0g R 93.8  6.5  53:39.48 oracle
 3046 oracle9   24   0 5028m 1.6g 1.6g R 92.9  5.0  22:26.82 oracle
 2539 oracle9   18   0 5029m 2.2g 2.2g R 91.5  7.1  79:07.46 oracle
 2966 oracle9   17   0 5028m 1.7g 1.7g R 90.2  5.4  29:24.80 oracle
 3072 oracle9   25   0 5028m 1.5g 1.5g R 85.9  4.8   9:15.69 oracle
 3070 oracle9   18   0 5028m 1.5g 1.5g R 50.3  4.8  10:02.54 oracle
 3074 oracle9   15   0 5028m 1.6g 1.6g D 33.6  5.0  10:10.16 oracle
 9960 oracle9   15   0 5033m 759m 751m S 26.6  2.4 505:34.59 oracle
 2988 oracle9   18   0 5028m 1.6g 1.6g R 10.6  5.3  26:40.31 oracle
 9968 oracle9   16   0 28908 5260 2872 S  0.7  0.0  16:13.83 tnslsnr
15463 root      16   0  4360 1128  840 S  0.3  0.0   7:21.80 top

Adsense punya

Adsense punya hasil utk 11/03/2011 from 2a.m-> 7.00 am

Understanding Load average Linux

What does Load Average give you when you doing TOP, w ...

See here. :)

http://blog.scoutapp.com/articles/2009/07/31/understanding-load-averages

PHP adodb oci8 ORACLE

Should You Use Persistent Connections

One question that is frequently asked is should you use persistent connections to Oracle. Persistent connections allow PHP to recycle existing connections, reusing them after the previous web pages have completed. Non-persistent connections close automatically after the web page has completed. Persistent connections are faster because the cost of reconnecting is expensive, but there is additional resource overhead. As an alternative, Oracle allows you to pool and reuse server processes; this is called Shared Server (also known as MTS).

The author's benchmarks suggest that using non-persistent connections and the Shared Server configuration offer the best performance. If Shared Server is not an option, only then consider using persistent connections.

source: http://phplens.com/lens/adodb/docs-oracle.htm

Oracle Server Overloaded??

Oracle Server TOP status

top - 11:55:45 up 189 days, 22:49,  7 users,  load average: 21.59, 20.06, 20.53

Tasks: 216 total,  14 running, 202 sleeping,   0 stopped,   0 zombie

Cpu(s): 95.2% us,  3.7% sy,  0.0% ni,  0.0% id,  0.0% wa,  0.2% hi,  0.7% si

Mem:   8156992k total,  8133480k used,    23512k free,    73756k buffers

Swap:  2097144k total,  1328752k used,   768392k free,  6994464k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND

15615 oracle9   19   0 5029m 2.6g 2.6g R 96.5 33.5  99:02.07 oracle

15426 oracle9   18   0 5029m 2.6g 2.5g R 85.1 32.8  69:58.65 oracle

18765 oracle9   17   0 5029m 1.7g 1.7g R 84.1 21.4   8:42.19 oracle

18797 oracle9   18   0 5029m 1.7g 1.7g R 80.2 21.4   6:54.84 oracle

15734 oracle9   18   0 5029m 2.4g 2.4g R 79.5 31.0  69:05.59 oracle

18763 oracle9   17   0 5029m 1.6g 1.6g R 77.8 21.0   8:02.84 oracle

16117 oracle9   20   0 5029m 2.2g 2.2g R 74.8 27.8  19:58.24 oracle

18809 oracle9   17   0 5029m 1.5g 1.5g R 71.8 19.5   3:59.30 oracle

18767 oracle9   18   0 5029m 1.7g 1.7g R 70.8 22.4   7:57.53 oracle

13959 oracle9   17   0 5029m 2.9g 2.9g R 39.2 37.6 275:38.99 oracle

 1816 oracle9   15   0 5034m 817m 808m S 34.6 10.3   2122:38 oracle

18803 oracle9   18   0 5029m 1.5g 1.5g R  2.3 19.8   4:10.62 oracle

 1821 oracle9   15   0 36852 6304 1592 S  1.0  0.1  55:57.40 tnslsnr

15329 spk         15   0 38580 1944 1256 S  0.3  0.0   0:44.84 sshd

18795 oracle9   21   0 5028m 1.5g 1.5g R  0.3 18.8   2:56.18 oracle

Oracle Server Top Status

top - 11:52:11 up 189 days, 22:45,  7 users,  load average: 16.05, 18.26, 20.21

Tasks: 216 total,  11 running, 205 sleeping,   0 stopped,   0 zombie

Cpu(s): 96.9% us,  1.5% sy,  0.0% ni,  0.0% id,  0.1% wa,  0.5% hi,  1.0% si

Mem:   8156992k total,  8131756k used,    25236k free,    75116k buffers

Swap:  2097144k total,  1341488k used,   755656k free,  6987084k cached

Seems like the oracle server is out of memory. It start to use swap space now.

And the CPU load seem overload also.

What todo ??

statcounter from8to5.blogspot.com

as per today chart ... Ganbatte!!

Tor browser control port

The tor proxy can be change automatically by issuing command in the tor control port #default 9051.

Have it enable in torrc file

http://thesprawl.org/memdump/?entry=8

Change vidalia identity programatically

# check for ControlPort 9051 is the the torrc file

telnet 127.0.0.1 9051
Escape character is '^]'.
AUTHENTICATE <Hexed_Cookie_Contents_Here>
250 OK
signal NEWNYM
250 OK
quit

Linux :: Determine which kernel version is in use

To determine which kernel version is in use, type the following in a terminal window:

rpm -qf /boot/vmlinuz

Server status

Current Time: Friday, 04-Mar-2011 23:30:22 MYT

Restart Time: Friday, 04-Mar-2011 07:02:10 MYT

Parent Server Generation: 0

Server uptime: 16 hours 28 minutes 11 seconds

Total accesses: 570849 - Total Traffic: 5.0 GB

CPU Usage: u458.55 s96.34 cu0 cs0 - .936% CPU load

9.63 requests/sec - 88.7 kB/second - 9.2 kB/request

111 requests currently being processed, 49 idle workers