ODSEE - What is the dsconf Configuration Attribute "db-env-path" and the Related cn=config Attribute "nsslapd-db-home-directory" (Doc ID 1426053.1)

Last updated on NOVEMBER 18, 2022

Applies to:

Goal

Seeing high disk write activity, what is a option to try and mitigate this ?

extended device statistics
r/s w/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
38.0 10.0 4.7 0.1 0.0 0.8 0.0 16.2 0 14 ssd45
37.0 9.0 4.6 0.0 0.0 0.9 0.0 19.1 0 16 ssd46
39.0 9.0 4.8 0.0 0.0 0.9 0.0 18.0 0 14 ssd47
33.0 11.0 4.0 0.1 0.0 1.0 0.0 23.0 0 17 ssd48
29.0 11.0 3.6 0.1 0.0 0.5 0.0 13.7 0 10 ssd49
34.0 10.0 4.2 0.1 0.0 0.6 0.0 13.9 0 10 ssd50
30.5 10.0 3.8 0.1 0.0 0.6 0.0 16.0 0 13 ssd51
29.0 10.0 3.6 0.1 0.0 0.5 0.0 13.0 0 12 ssd52
Fri Dec 9 10:03:48 2011
extended device statistics
r/s w/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
12.6 187.9 1.6 20.9 0.0 56.2 0.0 280.3 0 58 ssd45
7.0 195.9 0.9 20.6 0.0 60.1 0.0 296.3 0 58 ssd46
8.0 190.9 1.0 20.7 0.0 58.2 0.0 292.6 0 57 ssd47
6.0 186.4 0.8 20.1 0.1 57.7 0.7 299.6 14 57 ssd48
7.0 192.4 0.9 21.1 0.1 56.7 0.7 284.1 13 57 ssd49
9.5 192.9 1.2 21.0 0.0 56.0 0.0 276.7 0 59 ssd50
10.0 185.9 1.3 21.6 0.0 56.2 0.0 287.0 0 57 ssd51
5.5 192.9 0.7 21.1 0.0 57.7 0.0 290.9 0 57 ssd52
Fri Dec 9 10:03:50 2011
extended device statistics
r/s w/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
59.8 331.2 7.3 28.1 0.0 50.8 0.0 129.9 0 82 ssd45
67.8 344.6 8.3 28.0 0.0 49.6 0.0 120.2 0 83 ssd46
68.8 339.6 8.5 27.1 0.1 51.5 0.3 126.2 11 93 ssd47
68.8 360.1 8.4 28.3 0.0 51.9 0.0 121.0 0 87 ssd48
55.4 264.3 6.7 17.4 0.0 31.1 0.0 97.3 0 75 ssd49
45.9 236.4 5.7 19.2 0.0 33.5 0.0 118.6 0 75 ssd50
52.9 253.3 6.4 18.6 0.0 32.5 0.0 106.0 0 79 ssd51
58.4 262.3 6.4 19.3 0.0 34.5 0.0 107.6 0 76 ssd52
Fri Dec 9 10:03:52 2011
extended device statistics
r/s w/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
53.3 25.9 6.6 0.3 0.0 0.9 0.0 10.9 0 17 ssd45
51.8 27.9 5.9 0.2 0.0 0.9 0.0 11.7 0 16 ssd46
53.8 32.9 6.7 0.4 0.0 1.0 0.0 11.1 0 15 ssd47
49.3 33.9 6.1 0.4 0.0 0.7 0.0 8.8 0 16 ssd48
40.4 22.9 4.9 0.1 0.0 0.7 0.0 10.3 0 15 ssd49
34.4 19.9 4.2 0.1 0.0 0.4 0.0 8.0 0 12 ssd50
42.4 16.4 5.1 0.0 0.0 0.6 0.0 9.4 0 13 ssd51
41.4 19.9 5.0 0.1 0.0 0.5 0.0 7.9 0 12 ssd52
Fri Dec 9 10:03:54 2011
extended device statistics
r/s w/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
115.3 4.0 14.4 0.1 0.0 1.5 0.0 12.4 0 23 ssd45
124.8 5.0 15.5 0.1 0.0 1.8 0.0 14.1 0 23 ssd46
124.8 5.0 15.5 0.1 0.0 1.7 0.0 12.8 0 24 ssd47
129.3 4.0 15.9 0.1 0.0 1.4 0.0 10.5 0 20 ssd48
102.8 3.0 12.6 0.1 0.0 1.3 0.0 12.3 0 20 ssd49
106.3 3.0 13.2 0.1 0.0 1.4 0.0 13.1 0 23 ssd50
111.8 5.0 13.9 0.1 0.0 1.5 0.0 12.7 0 22 ssd51
95.8 4.0 11.9 0.1 0.0 1.1 0.0 11.2 0 21 ssd52
Fri Dec 9 10:03:56 2011

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.