Home » RDBMS Server » Performance Tuning » Can you explain to me?
Can you explain to me? [message #285838] Wed, 05 December 2007 20:30
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

I am newbie on Performance Tuning. Today, I execute ADDM feature to collect statistic and analyze them, however, something make me wondering. Would you like to explain to me?

Quote:


FINDING 5: 8.4% impact (687 seconds)
------------------------------------
Wait event "rdbms ipc reply" in wait class "Other" was consuming significant database time.



What does "8.4% impact (687 seconds) mean?
and why did wait event "rdbms ipc reply" consume significant database time?

Quote:


FINDING 7: 4.8% impact (391 seconds)
------------------------------------
The PGA was inadequately sized, causing additional I/O to temporary tablespaces to consume significant database time.

NO RECOMMENDATIONS AVAILABLE

ADDITIONAL INFORMATION:
The value of parameter "pga_aggregate_target" was "2144 M" during the analysis period.

SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Wait class "User I/O" was consuming significant database time.
(15% impact [1200 seconds])



My Database is 10.2.0, OS Solaris 10. Physical Memory is 8192MB, CPU are 4, SGA is 4336M, so is PGA with 2144M value correct?

Quote:


ADDITIONAL INFORMATION
CPU was not a bottleneck for the instance



I really do not understand this statement.

When I check the SMON process, I show..
Quote:


/usr/proc/bin/pmap 1019
1019: ora_smon_VNP
0000000100000000 98304K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/bi
n/oracle
0000000106000000 1824K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/bi
n/oracle
00000001062C6000 808K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/bi
n/oracle
0000000106390000 808K rwx-- [ heap ]
0000000380000000 3751952K rwxsR [ ism shmid=0x3 ] <== shmid
FFFFFFFF799F0000 128K rw--- [ anon ]
FFFFFFFF79A10000 64K rw--- [ anon ]
FFFFFFFF79A20000 64K rw--- [ anon ]
FFFFFFFF79A30000 64K rw--- [ anon ]
FFFFFFFF79A40000 64K rw--- [ anon ]
FFFFFFFF79A50000 64K rw--- [ anon ]
FFFFFFFF79A60000 64K rw--- [ anon ]
FFFFFFFF79A70000 64K rw--- [ anon ]
FFFFFFFF79A80000 64K rw--- [ anon ]
FFFFFFFF79A90000 64K rw--- [ anon ]
FFFFFFFF79AA0000 64K rw--- [ anon ]
FFFFFFFF79B70000 64K rw--- [ anon ]
FFFFFFFF79B80000 64K rw--- [ anon ]
FFFFFFFF79B90000 64K rw--- [ anon ]
FFFFFFFF79BA0000 64K rw--- [ anon ]
FFFFFFFF79BB0000 64K rw--- [ anon ]
FFFFFFFF79BC0000 64K rw--- [ anon ]
FFFFFFFF79BD0000 64K rw--- [ anon ]
FFFFFFFF79BE0000 64K rw--- [ anon ]
FFFFFFFF79C00000 8K rw-s- dev:118,16 ino:5859
FFFFFFFF79D00000 64K rw--- [ anon ]
FFFFFFFF79D10000 64K rw--- [ anon ]
FFFFFFFF79D20000 64K rw--- [ anon ]
FFFFFFFF79D30000 64K rw--- [ anon ]
FFFFFFFF79D40000 64K rw--- [ anon ]
FFFFFFFF79D50000 64K rw--- [ anon ]
FFFFFFFF79D60000 64K rw--- [ anon ]
FFFFFFFF79D70000 64K rw--- [ anon ]
FFFFFFFF79D9E000 8K rwxs- [ anon ]
FFFFFFFF79E00000 8K r-x-- /platform/sun4u-us3/lib/sparcv9/libc_psr.so.
1
FFFFFFFF79F00000 24K rwx-- [ anon ]
FFFFFFFF7A000000 8K rwx-- [ anon ]
FFFFFFFF7A100000 8K r-x-- /lib/sparcv9/libmd5.so.1
FFFFFFFF7A202000 8K rwx-- /lib/sparcv9/libmd5.so.1
FFFFFFFF7A300000 8K rwx-- [ anon ]
FFFFFFFF7A400000 640K r-x-- /lib/sparcv9/libm.so.2
FFFFFFFF7A59E000 40K rwx-- /lib/sparcv9/libm.so.2
FFFFFFFF7A600000 32K r-x-- /lib/sparcv9/librt.so.1
FFFFFFFF7A708000 8K rwx-- /lib/sparcv9/librt.so.1
FFFFFFFF7A800000 32K r-x-- /lib/sparcv9/libaio.so.1
FFFFFFFF7A908000 8K rwx-- /lib/sparcv9/libaio.so.1
FFFFFFFF7AA00000 920K r-x-- /lib/sparcv9/libc.so.1
FFFFFFFF7ABE6000 64K rwx-- /lib/sparcv9/libc.so.1
FFFFFFFF7ABF6000 8K rwx-- /lib/sparcv9/libc.so.1
FFFFFFFF7AD00000 8K rwx-- [ anon ]
FFFFFFFF7AE00000 8K r-x-- /usr/lib/sparcv9/libsched.so.1
FFFFFFFF7AF00000 32K r-x-- /lib/sparcv9/libgen.so.1
FFFFFFFF7B008000 8K rwx-- /lib/sparcv9/libgen.so.1
FFFFFFFF7B100000 56K r-x-- /lib/sparcv9/libsocket.so.1
FFFFFFFF7B20E000 16K rwx-- /lib/sparcv9/libsocket.so.1
FFFFFFFF7B300000 688K r-x-- /lib/sparcv9/libnsl.so.1
FFFFFFFF7B4AC000 64K rwx-- /lib/sparcv9/libnsl.so.1
FFFFFFFF7B4BC000 32K rwx-- /lib/sparcv9/libnsl.so.1
FFFFFFFF7B500000 8K r-x-- /lib/sparcv9/libkstat.so.1
FFFFFFFF7B602000 8K rwx-- /lib/sparcv9/libkstat.so.1
FFFFFFFF7B700000 2176K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libnnz10.so
FFFFFFFF7BA1E000 240K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libnnz10.so
FFFFFFFF7BA5A000 8K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libnnz10.so
FFFFFFFF7BB00000 64K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libdbcfg10.so
FFFFFFFF7BC0E000 16K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libdbcfg10.so
FFFFFFFF7BD00000 1056K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libclsra10.so
FFFFFFFF7BF06000 56K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libclsra10.so
FFFFFFFF7BF14000 8K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libclsra10.so
FFFFFFFF7C000000 8192K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libjox10.so
FFFFFFFF7C800000 1064K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libjox10.so
FFFFFFFF7CA08000 552K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libjox10.so
FFFFFFFF7CB00000 8K rwx-- [ anon ]
FFFFFFFF7CC00000 8K rwx-- [ anon ]
FFFFFFFF7CD00000 40K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocrutl10.so
FFFFFFFF7CE08000 16K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocrutl10.so
FFFFFFFF7CF00000 304K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocrb10.so
FFFFFFFF7D04A000 24K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocrb10.so
FFFFFFFF7D100000 1472K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocr10.so
FFFFFFFF7D36E000 72K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocr10.so
FFFFFFFF7D380000 8K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libocr10.so
FFFFFFFF7D400000 8K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libskgxn2.so
FFFFFFFF7D500000 8K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libskgxn2.so
FFFFFFFF7D600000 8K rwx-- [ anon ]
FFFFFFFF7D700000 1728K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libhasgen10.so
FFFFFFFF7D9AE000 80K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libhasgen10.so
FFFFFFFF7D9C2000 8K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libhasgen10.so
FFFFFFFF7DA00000 192K r-x-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libskgxp10.so
FFFFFFFF7DB2E000 16K rwx-- /u01/app/oracle/oracle/product/10.2.0/VNP/li
b/libskgxp10.so
FFFFFFFF7DC00000 8K r-x-- /lib/sparcv9/libdl.so.1
FFFFFFFF7DD00000 8K rwx-- [ anon ]
FFFFFFFF7DE00000 176K r-x-- /lib/sparcv9/ld.so.1
FFFFFFFF7DF2C000 16K rwx-- /lib/sparcv9/ld.so.1
FFFFFFFF7FFDC000 144K rw--- [ stack ]
total 3876032K



What does "anon" mean?

Thank you for your reply.

[Updated on: Wed, 05 December 2007 20:38]

Report message to a moderator

Previous Topic: error in stat pack
Next Topic: Outer Join is very very slow
Goto Forum:
  


Current Time: Fri Dec 09 04:06:13 CST 2016

Total time taken to generate the page: 0.08422 seconds