on 09-05-2008 9:13 AM
Dear All,
In Semaphore statistics very high .please guide .how to solved it.
we are using windows 2003 and Ecc5
Semaphore statistics Date 05.09.2008 Time 13.27.22 Monitoring Options:
-
-
Wait time entering the critical path
Residence period in the critical path
-
Key No. <100us <1ms <10ms <100ms <1s <10s >10s Time/ms Protected area
-
2 329 327 2 0 0 0 0 0 0 Message Queue (Writing Dialog Requests)
2 329 329 0 0 0 0 0 0 0
3 2,040 2,040 0 0 0 0 0 0 0 Message Queue (Read)
3 2,040 2,040 0 0 0 0 0 0 0
4 11 11 0 0 0 0 0 0 0 Terminal communication
4 11 11 0 0 0 0 0 0 0
5 15 15 0 0 0 0 0 0 0 Work process communication
5 15 15 0 0 0 0 0 0 0
6 750 750 0 0 0 0 0 0 0 Roll administration
6 750 750 0 0 0 0 0 0 0
7 1,660 1,659 1 0 0 0 0 0 0 Paging administration
7 1,660 1,189 471 0 0 0 0 0 0
12 180 180 0 0 0 0 0 0 0 Character code conversion
12 180 179 1 0 0 0 0 0 0
13 200 200 0 0 0 0 0 0 0 Update synchronization
13 200 200 0 0 0 0 0 0 0
14 2,161 2,125 1 11 18 6 0 0 1098 Presentation buffer
14 2,161 1,290 829 9 29 4 0 0 2061
16 1,028 1,026 2 0 0 0 0 0 0 Table buffer key
16 1,028 983 34 11 0 0 0 0 0
17 1 1 0 0 0 0 0 0 0 Buffer synchronization
17 1 0 0 1 0 0 0 0 0
23 1,578 1,578 0 0 0 0 0 0 0 Message queue (Writing All Other Requests)
23 1,578 1,576 2 0 0 0 0 0 0
24 11 11 0 0 0 0 0 0 0 LRU table buffer
24 11 11 0 0 0 0 0 0 0
26 1,042 1,042 0 0 0 0 0 0 0 Enqueue table
26 1,042 1,034 6 2 0 0 0 0 0
31 255 255 0 0 0 0 0 0 0 Spool administration
31 255 254 1 0 0 0 0 0 0
33 16 16 0 0 0 0 0 0 0 Extended segments management
33 16 16 0 0 0 0 0 0 0
34 2 2 0 0 0 0 0 0 0 Message buffer
34 2 2 0 0 0 0 0 0 0
38 1,809 1,809 0 0 0 0 0 0 0 CCMS Monitoring
38 1,809 1,724 85 0 0 0 0 0 0
39 1,736 1,736 0 0 0 0 0 0 0 Extended Global Memory
39 1,736 1,736 0 0 0 0 0 0 0
42 430 430 0 0 0 0 0 0 0 Statistics Buffer
42 430 430 0 0 0 0 0 0 0
43 141 141 0 0 0 0 0 0 0 Spool Cache
43 141 138 2 1 0 0 0 0 0
46 1 1 0 0 0 0 0 0 0 Profiles
46 1 1 0 0 0 0 0 0 0
48 417 417 0 0 0 0 0 0 0 EnqID
48 417 417 0 0 0 0 0 0 0
57 1,102 1,102 0 0 0 0 0 0 0 Runtime Monitor
57 1,102 1,101 1 0 0 0 0 0 0
Thanks,
Kumar
Edited by: Kumar on Sep 5, 2008 11:17 AM
Hi
Kumar
In which transaction or file u are saying semaphores are high
is the disk utilization high, how much free space available in the tablespaces.
Hope for further check here
ST02 (tune summary)
--> Detail analysis
[additional functions]
--> Semaphores
If this is the first time going there, then be sure to read the legend carefully:
first line = "Wait time entering the critical path"
second = "Residence period in the critical path"
I never came across such high semaphores
Regards
Bhaskar
Edited by: bhaskar1818 on Sep 5, 2008 5:50 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Bhaskar
The above log is of Semaphore in St02 deatils.
we are using windwos 2003 ,Ecc5 and oracle 9i.
I am geting Sem in Sm50. and by obervation i am getting number 14, 38 and 7 manny times . form note 33873
7: PAGING-Semaphore (paging administration)
14: PRES_BUF-Semaphore (presentation buffer)
38: SEM_CCMS_AS_MONI_KEY (CCMS monitoring for appl.s)
But i need sugging how to solve the problem .
the other log are os ST06 and St02.
I gont have much free space.
The problem is system is working very slow and getting hang.
In st06 the Lan high.
Lan
(sum)
Packets in/s 4,444 Errors in/s 0
Packets out/s 4,170 Errors out/s 3
Collisions 0
Memory Physical mem free Kb 1,788,888 in the system so i cant increase
IN ST02 Export/import swap is high than 10,000.
Export/import 89.72 40,000 7,528 25.77 30,000 18,855 62.85 95,972 Exp./Imp. SHM 97.89 4,096 3,238 95.94 2,000 1,999 99.95 0 0
Thanks,
kumar
Hi,
Any modification has been done in last couple of days in hardware.
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.